Viewing 15 posts - 13,441 through 13,455 (of 13,849 total)
This thread should give you what you need:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=201594
July 21, 2005 at 6:21 am
I'm sorry, but I'm afraid that confusion still reigns in my mind! Why would you want to write a program that works exactly like IDENTITY?
Does your prog need to generate...
July 21, 2005 at 5:58 am
I think you're right - I tend to do dev and debugging on my PC and so it all works fine for me.
No problem about the help - people in this...
July 21, 2005 at 5:06 am
When you say 'automatic' - I presume you mean exactly that, ie users do not need to do anything special, they just INSERT to the other fields and the key...
July 21, 2005 at 5:01 am
OK - the code is in the right pane and there should be a yellow arrow pointing to the first line of executable code (after any declarations).
Just use the step...
July 21, 2005 at 4:16 am
Check out the NEWID() function in BOL and see whether that suits.
July 21, 2005 at 3:28 am
There's something fishy going on here - presumably the fields were defined as not null for a reason, in which case you should be populating them with sensible data. Or...
July 21, 2005 at 3:24 am
Sounds promising ...
Debugging: right-click the stored proc in the QA object browser. 'Debug' should be one of the options available to you.
Regards.
July 20, 2005 at 10:02 am
OK, no offence intended.
This link may be of interest - they seem to have the same symptoms as you.
http://www.talkaboutdatabases.com/group/comp.databases.ms-sqlserver/messages/123008.html
Other than that, I'm running out of ideas.
July 20, 2005 at 9:21 am
Did you use the debugger to track down the NULL problem? If not, running the stored proc step by step in debug mode might point you in the right direction. ...
July 20, 2005 at 9:14 am
Yikes, way too much code for me to trawl through while doing my day job!
Leaving the function as it is, are you able to put the function call (only) in...
July 20, 2005 at 8:57 am
No - looks OK from what you've said. Can you post more info (eg the stored proc definition) so that we can the help further?
July 20, 2005 at 8:37 am
OK - so have you run out of growing space?
July 20, 2005 at 8:33 am
Use EM if you really have to, but check out this thread first and maybe you'll not worry about it
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=98351
Doing this in T-SQL is non-trivial and not recommended.
July 20, 2005 at 8:31 am
Viewing 15 posts - 13,441 through 13,455 (of 13,849 total)