deleting records so there are only 50 left does not shrink the size of the database....the database will keep it's original size, so that it is ready to insert more...

looks like you've already fixed the issue where the multiple single quotes; that was fast.

I still see the issue in my example where a less-than-symbol was assumed to start an...

While I'm thinking about it, can you give us some metrics as well? how many total rows in the table? how many rows are affected in that 15 minute update?

how...

i would guess that you are looking at it wrong; an identity, if you are not searching by that now, would not help performance in the slightest.

I'd like to see...

you might want to consider getting SQL 2008 Developer Edition; it is the latest and greatest and all that.

I just got one earlier last week; I'd been running 2005 forever,...

am i missing something? it looks like a comma delimited string, so you could replace the comma with CrLf (Char(13) + CHAR(10) ) for display purposes, or did you want...

you need to explicitly start a transaction, because SQL server assumes by default that every command is auto-committed unless there is a BEGIN TRAN command;but other than that it is...

ahh, i got you...so you are simply altering them with identical code so the dependencies get entered in correctly, right?

if it's grayed out, then it's already installed, right?

your only option is SSMS's output results to file.

SQL server does not have a native TSQL command to output to a file; the expectation is the presentation layer would do...

i agree with GSquared;

if the disk is NOT full, that implies someone might have put a hard limit on the max size of tempdb; you'd need to allow it...

functionally, developer version and enterprise are identical, except for licensing.

also, enterprise can't install on a non-server version of a machine...it requires a server OS.

developer version has everything you need, without...

glad i could help and thanks for the feedback!

dunno if it will make a difference, but instead of using IN()

i always use a join for the inserted table instead:

UPDATE Vendors

SET Vendors.Modified=getdate()

FROM INSERTED

WHERE Vendors.kpVendorID = INSERTED.kpVendorID

in that situation,...

saved in my snippets: bulk insert will not accept a variable, so you need to use the EXEC command instead:

--bulk insert won't take a variable name, so make a sql...