Viewing 6 posts - 61 through 67 (of 67 total)
Two good solutions- thanks guys!
January 10, 2007 at 12:43 pm
Ok, thanks. Good to know I'm not missing anything obvious.
December 1, 2006 at 12:05 pm
Good question. Here's the scenario.
I need a re-useable script to import an excel spreadsheet of users, import them into a Users table (creating the proper user id and password along...
October 30, 2006 at 9:45 am
That makes sense, but then I lose my variable values. But I can either put that in my table too or re-calculate it after the GO. Thanks!
October 27, 2006 at 8:03 am
I just need the rows numbered sequentially, starting with a variable number. I got it to work by creating the ALTER TABLE statement dynamically, as suggested above.
Thanks for your help!
October 26, 2006 at 1:27 pm
The DBCC CHECKIDENT call doesn't seem to do anything, the identity values are the same after the call (start with 1). I get this message:
"Checking identity information: current identity value '1058',...
October 26, 2006 at 1:10 pm
Viewing 6 posts - 61 through 67 (of 67 total)