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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:05 PM
Points: 17,815, Visits: 15,743
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #953551
Posted Friday, July 16, 2010 2:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 1,780, Visits: 6,475
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 @ 2:10 PM
Points: 5,878, Visits: 13,006
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Sunday, October 19, 2014 11:12 AM
Points: 7,791, Visits: 9,545
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