network profile
| bio | website | yourcodeisshowing.wordpress.c… |
|---|---|---|
| location | Quebec City, Canada | |
| age | 35 | |
| visits | member for | 2 years, 4 months |
| seen | Apr 27 '12 at 14:51 | |
| stats | profile views | 1 |
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... |
