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 «««123

Predict the outcome Expand / Collapse
Author
Message
Posted Thursday, July 15, 2010 5:37 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
Thanks for the question. I think this serves as a good reminder to people that an increment must be some value other than 0.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #953551
Posted Friday, July 16, 2010 2:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:20 AM
Points: 1,740, Visits: 6,366
Good question. I was thrown by the 'does not have permission' option, and thought that maybe if the user did not have permission to create tabbles then this is the message that would be given, so chose the 'cannot tell' answer.
Of course when I tried it, even for a user without permission, it failed with the syntax error rather than the security error
Post #953679
Posted Friday, July 16, 2010 3:15 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:23 AM
Points: 5,989, Visits: 12,926
I really, really knew the answer to this, but it seemed so simple and obvious I thought there must be a catch and didn't answer it.

I think I am suffering a pavlovian reaction to QOTD.


---------------------------------------------------------------------

Post #953706
Posted Saturday, September 18, 2010 12:55 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 7:14 AM
Points: 8,739, Visits: 9,286
Good question.

I think the question demonstrates a sense of humour.

Some of the comments though seem to attribute mystical properties to the identity property.


Tom
Post #988768
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse