Gail gave you all the code you need. Now you have to create a job with a T-SQL task. Do you have any other DBAs on the team that can...

Hmm. Point taken. I can see that working.

GilaMonster (3/28/2011)

---

That's actually very simple.

Set up a SQL Agent job scheduled to run at midnight. The job step needs a single line of T-SQL

DBCC CHECKIDENT (CALLS, RESEED, 0)

Needless to say,...

Here's an article link on how you can post your code (and questions) so we have enough information to assist you.

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Your question doesn't sound very complex, but it would help...

I hate to say it, but this might be a case of "Call Microsoft." I certainly can't think of why your connection would fail out of the blue if nothing...

[Jim].[dba].[Murphy] (3/27/2011)

---

Also, even though tempdb is recreated each time SQL Server starts, unlike a brand new user database, the new tempdb file settings, including it's size is taken from...

Sachin Nandanwar (3/28/2011)

---

But just one last confusion if you can clear me on that.When the data is written to the disk in middle of a transaction and a checkpoint occurs...

DOH. I knew there was a reason I asked this question and I got so caught up in getting my DDL together that I forgot the most important part.

Rephrase: Not...

Checking for triggers or logon scripts is a good idea. Also, check the application code to see if it has a way of altering the SA password or the SA...

Maybe, but I don't think restarting the server would have resolved a changed password issue.

I do agree that SA should not be used...

Unless I'm misreading your comment, it sounds like you've already made up your mind that we can't help you.

Take a deep breath....

We have an active / active / active / passive setup. So, yes, definitely possible. Use virtual names when possible so when your servers reach EOL, you're not changing a...

If you are relying on default sizes (not altering them) when you create the databases, all you have to do is look at the size of the Model db files....

So true. When you save a package in BIDS 2008, even the...

GSquared (3/25/2011)

---

Ooooohhhhh, I WISH!!! That was the first thing I thought of when I saw a...