Checked the database is not in SIMPLE recovery model mode?

You only get transaction logs for backup if you are in FULL or BULK-LOGGED mode.

Have you checked the SQL Maintenance Plan log to see what it's reporting?

sqlmaint.exe may be throwing an error for any number of reasons, and recording the exact reason in it's...

In order to connect to your server, clients first need to resolve the server name. In windows, there are multiple ways and protocols used to do this including the SQL...

You can also use the OBJECT_NAME() function as in:

select OBJECT_NAME(id)

FROM  syscomments

where text like '% text to find %'

If you want to see how it's calculated, run in QA text mode:

use master
exec sp_helptext sp_spaceused

Recursive N-Tier heirarchial queries aren't really possible in SQL 2000 without using a temporary table to store the results as you make them (in my experience).

2005 has a built in...

Query Analyzer also won't show it to you. SQL Server tools are hopeless when it comes to large binary columns.

However as a weird trick, open Access, create a linked...

I hope your not running that against a production database!

Transaction logs keep a record of all changes in the database.

BACKUP LOG WITH TRUNCATE_ONLY

DELETES THE DATA IN THE TRANSACTION LOG...

Hmm. I'm guessing that updateing to SQL Service Pack 3a (SP3a) would probably fix your problem.

Is the hotfix that you applied for SQL Server? Cause applying a hotfix out of...

put the SQL you want to execute into a stored procedure.

In the DTS Execute SQL step put something like:

EXEC mystoredprocedure @myglobalvar = ?

Then hit the "Parameters" button. Select the global...

If your database is set to auto create statistics and auto update statistics, don't worry about things. SQL Server will create the statistics as you query the table/indexes which is...

char(0) is NULL .. but not DBNULL which is what sql puts in NULL columns. A tricky thing that I see from time to time, that makes results look really screwy...

Last time I did Full Text was in SQL 7 about 5 years ago. But from what I remeber and BOL:

For the cases of

" search for Test this returns results containing...

SQL Profiler has a template for long running queries. You could run profiler and have it log to a table on the server. Then have a SQL Agent that emails...

Is that error message appearing in the Windows Event Log , or in SQL Server's SQL Log?

Are you using the Microsoft Backup included in Windows (NTBACKUP.exe)? or a 3rd party...