Why bounce the instance? What do they think that does? If you bounce a db, you aren't necessarily doing anything to the server. I'm not even sure if the cache...

Chad, please feel free to submit it. If it's new to you, it's probably new to 100s of others.

Agree with Jack. I'd talk to the Day Care, and possibly the police. No need for you to do it and escalate things unnecessarily. they might have a kid there.

Please don't start asking a new question in this thread. Start a new thread if you have another error.

And please read the error message and look it up.

deprecated? deprecated? I keep seeing more of them all the time. Even one for the iPhone!

http://www.macworld.com/article/134425/2008/07/etchasketch.html

There's additional load, and you might have slightly higher latency. You also might need more log space. If there is a hiccup somewhere, the log won't clear until the subscription...

Which one is "that" server?

You can run replication on the primary server of the mirror. If it's really busy I might put the distributor on another server.

you cannot run replication...

I think I might suggest removing replication from the 2000 test server and then resetting it up again. I have seen it flaky at times, and once it's off, it's...

But crappy cars do create opportunity for mechanics. Whether that's good or not is another story.

I can't tell if it's that crappy, or it's just a little shoddy. There...

I agree with Flo. You don't want to do this. Renumbering all rows is a mistake based on data changes.

Perhaps you want to examine why you think you need to...

That's interesting, and I think you are in for some heartache.

My guess is that signing things, or maybe not including the functionality would be better. But ultimately, if you are...

When you restore the users move, but not the logins. The sp_change_users_login procedure can help you.

http://www.sqlservercentral.com/questions/T-SQL/67309/

Offline works great if you don't need to access the instance. I like that.

But if you want to kick everyone out, Lowell's first command is what I thought of.

why do...

LOL, the only reason I know this is because it's happened to me 🙂

Always be sure that you check data in SQL Server when examining code. It can introduce strange...

Ultimately you can't stop anyone. Unless the app has the keys to encrypted data, if someone has control of the machine and domain, they can get in. The service account...