throw him a pork chop, Bob!

I'm not sure what his problem is either. I think he's written a sh**ty application and now wants to overengineer the SQL code to back...

To move just tables in the same db, you need to create a new filegroup on that new drive. Then rebuild the clustered index on that filegroup, and the data...

First, why shrink the log? If you load again tomorrow and it grows, what have you accomplished? Nothing.

Your strategy of backing up the log every hour is sound. You should...

I tend to agree on the restore. It's not a hard thing to do if the db was running in SQL 2005. Worst case, build a DTS/SSIS package into the...

Kurt,

I've tended to agree. I never missed Intellisense in T-SQL, and never wanted it, but I have used it and liked it in VS. I think part of that is...

SQL will let you know if you're out of order. Typically you're restoring by times anyway.

Be sure that you always restore with NORECOVERY. You can always bring it online later,...

Well

, I think leading commands are

, well

, easier to read

:hehe:

No difference. This forum software allows for multi-threaded posts (replying to a specific post), but we have removed that. All discussions are single threaded to avoid confusion.

There must be some process that is changing the mode. You might need to run a trace to try and catch this, or run a script that checks it every...

Please don't cross post. Reply here: http://www.sqlservercentral.com/Forums/Topic451573-150-1.aspx#bm712110

Feeling hungry, pork chops sound good this am 😉

Honestly, I don't think this is a DBA's job. I was curious if anyone would bring it up, but there should be someone doing compliance, that looks over the DBA.

That...

For the record, I'm a leading commas guy, Jeff is wrong, and it's easier to read. All you trailing comma folk need to change!:-D:-D:w00t:

However, I do think that in your...

Have you tried to run it interactively to see where it's failing?

Actually you would typically "retry" a couple times if you get the duplicate error.

The chances of there being two inserts at the same time is extremely small, so likely you...