Here's how to do it... you will need to replace "dbname" with the actual name of the database.  You will need to do like wise with "servername".  Once you've tested...

Why on Earth would you put the creation of a temp table in an explicit transaction?  And, so far as exclusively locking the system tables when you use SELECT/INTO to...

You bet, Remi... we actually put the requirement in our "SQL Coding Standards" document so the Developers are made keenly aware of the problem.  Since we do code reviews on...

Sreejith,

Yep... we had a bunch of these... they all worked fine until, one day...  That's what's so insidious about it.  Works fine until you reach some unknown tipping point and...

I'm with you there... one of my favorite sayings is "Anyone can make a mistake but to really mess things up, you need a computer."

Nope... it doesn't matter if they're 2 or 20,000... especially when someone posts as well as you do   Dunno... maybe I need some stronger...

Can you post some sample data, hopefully in the form of INSERT statements, along with the CREATE statement for the table you're trying to get the data from, please?

I wouldn't say "never"... they're pretty handy when making a temp table and, since no one but the current session can use the temp table, there's no concurrency issue to...

Heh, heh.... mine are getting worse... old brain.

You hit the nail on the head about the scope thing... I was curious as to why you declared the variable external to...

Off the beaten path a bit, Serqiy, but what happened to your number of posts?  You were way up there and now you have less than 1000?  What'd they do? Reset...

As usual, Remi did it absolutely correct in the first reply above...

Ohhh no, no, no... we ran into that little jem... "death by SQL"...  pegged 4 cpus for two hours to do a lousy 2 minute update...  THAT was repeatable with...

Dollars to donuts says that someone change the privs on a folder or deleted a user with the privs... did you do a search for the DLL to find out...

If you have a clustered index, change it to a non-clustered index.  That'll help a highly transactional table a bit, as well, especially if you have a lot of inserts...

I found an alternative in XP... right click on the desktop, select [Properties], select the [Appearance] tab, and change the [Font Size] setting to LARGE or EXTRA LARGE.