I believe developer edition is licensed differently. There isn't a per processor or client AFAIK. You cannot use this for production. You'd need to uninstall, then reinstall the server version...

seemed to drop it fine when I did it on my local server. I expect that somehow the constraint got linked to a different table. Can you check in sysconstraints...

If there is an error in the first item, a rollback will occur and there is no transaction. You don't want to do the save if the first rollback occurred.

That's the only way I know and it only works for indexes or tables that have a clustered indexes. not sure how to determine for Stored procedures, heaps, views, etc.

I used a low tech approach.

http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

SQL Server will move through the log files and log to one, then the other, using virtual log files within each physical file. You need to add some transactions, truncate...

My process isn't without flaws and I'm sure I can learn a few things from you guys. It worked well and 90% of the time, so I just dealt with...

Not that I know of, but I plan on doing some sp2 testing on a VM over the next few weeks. Will let you know how it goes.

How are you doing the insert? You cannot turn off logging, but you can BCP in with different logging or commit after xx rows to minimize the log growth.

You must be rebuilding indexes or doing something I don't do. None of mine fail when a conneciton is open. Some of the options require an exclusive connection in the...

Correct, because it can see every event in SQL Server, only a sysadmin can use this.

I haven't seen this, but one of my tasks over the next few weeks is to do some testing on full text search. Hopefully I'll learn a few things.

Great catch. I was suspecting some type of process, backups, anti virus, defrag, etc. holding part of that file open.

Brian Kelley has a great article today on Anti-virus and SQL...

you can, but the backup utility is not very tolerant of network delays. I'd backup locally and then copy the file over.

select count(*) where yada, yada

then set rowcount = count(*) - 1

delete where yada, yada