There are a LOT of things that cause TEMPDB to grow. That's it's purpose in life.

It's used for temporary tables explicitly created by users, for worktables to hold intermediate...

When you append a backup, SQL Server adds a header with the backup number. But when it has to delete a file, that's what it's deleting - the whole file....

Here's the issue:

You create a Backup for the first time on 1 April - retain for 8 days. The backup file has the date of 1 April. You append a backup...

I suggest two books, one free and one not...

1. MS SQL Server's Books OnLine (BOL).

You can download this from Microsoft's SQL Server website:

http://www.microsoft.com/sql/techinfo/productdoc/

2000/books.asp

2. Ken Henderson's The Guru's Guide to...

A couple of things to consider when making the decision:

1. Validation: INT can ONLY be a number. CHAR can be a letter, number or symbol.

2. Addition or concatenation: try this:

DECLARE...

Or you can find QA at Start>Programs>Microsoft SQL Server>Query Analyzer

Also, if you aren't aware of it, SQL Server has the Books OnLine (refered to as BOL) which is it's Help...

First the files:

The .mdf is the Data file. That's your actual database. The .ldf is the LOG file.  That's the transaction log. The transaction log keeps track of all the...

At this point you might have to reinstall SQL Server and then attach the old MASTER and user databases. You might get away with only attaching the user database after...

I agree with whug. Look into the permissions/access rights.

When you run it - it works. When your boss runs it - it fails. That indicates your boss doesn't have the...

Everything!

Just kidding. It would be nice for the DBA to have sysadmin rights on the server that hosts SQL Server, but it's not needed.

To do your regular DBA job, you...

CampbellM,

I just found something (and then I lost the webpage) that talked about what you seem to be experiencing:

1. backup job

2. [SQLSTATE 01000] [Message 0]

It indicated it's an issue with...

CampbellM,

All is forgiven. I seem to recall in my searching something about this error and backups. I'll find it and post it here.

Stacenic,

Glad I was able to help you, now...

CampbellM,

Despite the fact that the only information you gave us was:

1. you had amended a script

2. you turned the script into a procedure

3. you get [SQLSTATE 01000]

4. you were awfully...

The SQLServerAgent service for the instance probably isn't running.

You can check two ways.

1. Open the Service Manager, in the Server box, chose the server\instance you want to check and in...

I found it out totally by accident. I was typing fast and managed to slip and hit the shift when I hit the enter key. I saw what happened and...