I've used Stefan's suggestions before successfully. Batch this into smaller transactions, say 10k at a time and it will probably go quicker.

Have you been testing it on your machine? Maybe the cache is primed and none of it is loaded on the server?

Likely there are a few things different. I'd check...

Everything is in a schema. Likely it was in the dbo schema, so change it back to that one.

If you are just looking for the instance, and not the server, you can have the service send a message when it's down. Otherwise you need another server running software,...

The explanation above is essentially correct. You can have users without logins as orphans after a restore, but essentially the login gets you access to the server, the user to...

bkubicek (5/17/2010)

---

Steve, a EULA is not going to keep your common DBA from opening up a stored proc and messing with it. If there are having problems most likely...

Fair enough, perhaps you can do something worth protecting in SQL Server. I'm not sold, but I'll stipulate I could be wrong.

In terms of a fence, perhaps there is some...

If that's what I'm implying, I don't mean to. I mean that it's not that secret. What you can do with SQL is fairly limited and there aren't necessarily a...

Red Gate has Log Rescue for free if you want to try it http://www.red-gate.com/products/sql_log_rescue/index.htm

My argument is encryption of stored procedures isn't worth doing. It's a PIA and doesn't provide protection. It can be broken.

I see two arguments back.

- Customers mess with stored...

Protagonist.

My 11 yr old went to see Iron Man last night with my wife and this morning I asked him if Iron Man won. He said

"Iron Man always wins....

Thanks, been trying to get those down. After editing 5 articles last week that can't figure out how to use a "the"...

Not remove shrink. Remove auto-shrink.

If something expands to fill the disk, autoshrink won't prevent that. you will still need to, and can shrink the dbs.

We did that at one point here. Someone had sent us a plagiarized articles and we published them. It wasn't until about 6 months later that the person was caught....

jcrawf02 (5/17/2010)

---

Um, Steve, not sure what's going on here, but the Database Weekly newsletter shows a link to this article: Are you Making This Common RAM Mistake?, which seems to...