BUG: ????? ????? sysdepends "????? ????" ??? "????? ??? ????"

?????? ????????? ?????? ?????????
???? ???????: 115333 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
BUG #: 10215 (4.21a)
BUG #: 16652 (SQLBUG_65)
BUG #: 57903 (SQLBUG_70)
BUG #: 56127 (SHILOH)
		
????? ???? | ?? ????

???????

??? ??? ??????? ?????? ?? ????? ????? ????? ??? ???? ?? ????? ? sysdepends ?????? ?????? ??? ????? ?????? ?????? ???? ????? ? ??? ?? ???? ??? ???? ????? ??? ??? ????. ????? ????? ?? ??? ????? sp_depends ??????? ??????? ??????.

???? ??????

????? ???? ????? ????? ???? ?? ????? ?????. ???? ????? ????? ??????? sysdepends ???? ????.

?????

???? Microsoft ??? ???? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????. ??? ??? researching ??? ??????? ?? ???? ??? ???? ????????? ??? ?? "????? ??????? ?? Microsoft ??? ?? ???? ??????.

??????? ????

??????? ???? ?? ???????. ?????? ?? ?????? ???? ?????? ?????? ??? ??? ??????.
   create table testx (c int)
   go
   create procedure procx as select * from testx
   go
    select name, id from sysobjects where (name = "testx")

   or (name = "procx")
   go
				

   name                           id
   -----------------------------  ----------
   testx                          464004684
   procx                          480004741
				

???? ????? ?????? ?? ??? ?????? ???????? ??? ?????. ?? ???? ???? ????.
   drop table testx
   go
   create table testx (c int)
   go
   select id from sysobjects where name = "testx"
				

   id
   -----------
   512004855
				

????? ??????? ????? sysdepends ????? ???? ???? ????.
   select id, depid from sysdepends where id = 480004741
				

   id          depid
   ----------  ----------
   480004741   464004684
				

???????

???? ???????: 115333 - ????? ??? ??????: 27/???? ??????/1435 - ??????: 3.3
????? ???
  • Microsoft SQL Server 4.21a Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbbug KB115333 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????115333

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com