Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Stored procedures Expand / Collapse
Author
Message
Posted Monday, October 26, 2009 5:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:50 PM
Points: 7,923, Visits: 9,649
Well, I know what is supposed to happen so I got my point. But anyone still using SQLServer 2000 should be warned about this - the behaviour is erratic, it may decide that although the proc name begins sp_ it's not going to look for it in master. So it's best always to use exec master..sp_ (in modern SQLServer, exec sys.sp_ - this is explicitly recommended in BOL for 2008) rather than just sp_.



Tom
Post #808612
Posted Saturday, November 21, 2009 2:20 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297
Good Q.

Learned something new today.




Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Post #822862
Posted Thursday, February 11, 2010 6:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 5:03 PM
Points: 2,262, Visits: 5,427
Pretty question
Post #864040
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse