Robert Frasca (4/8/2009)

---

Actually, if memory serves, in SQL Server 2005, table variables are stored in TempDB as well. In SQL Server 2000 they were stored in RAM. There's...

Lynn Pettis (4/8/2009)

---

It may be possible to download and install the SQL Server Express management tools (Gail, am I right here) and use those from a remote PC to make...

Because...

Don't you mean sysadmin?

bob.willsie (4/8/2009)

---

Perhaps people fell into that trap because some programmers don't clean up after themselves. I've come across code that continually created random named temp tables rather than creating...

Ok, so no database corruption. That's good. Just to be sure, you ran that on the database that has an ID of 10?

This may be a transient condition that doesn't...

Where did you purchase the computer from? It's really, really odd to buy a machine that has SQL pre-loaded. Especially if you didn't get the installation materials

This is going to...

Edit: Nevermind

Enterprise manager is the SQL management tool. If installed, it'll be somewhere on the start menu, probably under Microsoft SQL Server.

Is there anyone there who knows anything about SQL? This...

It was another thread, it was mid-late Jan. I remember because I was working on a very similar problem at the time.

Unfortunately, that's all I remember.

Why do you say that? Locks and blocking it will definitely cause, but with only one update, it's unlikely to deadlock, unless...

Please run checkDB on that database and post any errors here.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

You may also want to take a look at this article....

The transactions will never be committed, the locks those updates take will be held until the connection is closed. When the connection is closed, because there has been no commit...

You can't delete threads, don't worry about it. If it happens again, just post into one of the threads a note that it's a duplicate and where the replies should...

Quickest way is to reverse the string and look for the first occurrence.

DECLARE @StringA varchar(100), @pos int

SET @stringA = 'DirectoryA\DirectoryB\FileName'

-- Where is the last '\'?

SET @pos = LEN(@StringA) -...