120 reputation
6
bio website yourcodeisshowing.wordpress.c…
location Quebec City, Canada
age 37
visits member for 3 years, 9 months
seen Apr 27 '12 at 14:51

Developer with 8 years experience. I work with J, C, C++, C#, SQLite, MySQL, VBA, and a bunch of other odds and ends.

On Twitter: @MPProg


Apr
27
awarded  Supporter
Mar
20
comment IDENTITY_INSERT seems stuck
@AaronBertrand That I always did, on my side. I don't know if it's the connection, but ultimately I started a new one, encapsulated the operations in a transaction, and now it works.
Mar
20
accepted IDENTITY_INSERT seems stuck
Mar
20
awarded  Commentator
Mar
20
comment IDENTITY_INSERT seems stuck
Same table names. Dammit, I can't post my actual code (as per contract) and that makes you guys look at the wrong things. Alright, I'll work with that.
Mar
20
comment IDENTITY_INSERT seems stuck
@MartinSmith Correct. I broke down my original script to just these 3 commands, which I attempted on a new connexion, closing and restarting the query analyzer prior.
Mar
20
comment IDENTITY_INSERT seems stuck
@Shark I know, but it's already ON for DestinationTable. I want it ON, it says it's ON, but when I insert, now SQLServer says it's OFF.
Mar
20
revised IDENTITY_INSERT seems stuck
added 24 characters in body
Mar
20
awarded  Editor
Mar
20
revised IDENTITY_INSERT seems stuck
added 236 characters in body
Mar
20
comment IDENTITY_INSERT seems stuck
Same window. My script is exactly that (save for the actual table structure. The Set followed by the Insert. Followed by a final Set to turn it back off.
Mar
20
comment IDENTITY_INSERT seems stuck
Dropping and recreating the table does not resolve the issue.
Mar
20
asked IDENTITY_INSERT seems stuck
Mar
14
awarded  Student
Mar
14
awarded  Scholar
Mar
12
comment How to change a user's name in SQL Server 2000?
Yeah, I'll just drop 'em. It really doesn't seem supported in 2000.
Mar
12
accepted How to change a user's name in SQL Server 2000?
Mar
12
comment How to change a user's name in SQL Server 2000?
@Dirk: Not linked.
Mar
12
comment How to change a user's name in SQL Server 2000?
That's the thing, in SQL Server 2000 I get "Incorrect syntax near the work 'USER'."
Mar
12
comment How to change a user's name in SQL Server 2000?
Oh, but I wish there was a move to dba option now...