Can you provide a sample of the data and how you would like the results to look based on the sample data?

-SQLBill

The maintenance plan is probably reindexing your database tables. This can cause the log file to grow 1.5 times the size of the database itself. This is normal and is...

What are you talking about? When I edit a schedule for one of my jobs (or create one for a new job), it gives me the option to chose...

You need to post this in an appropriate forum. You've posted it in the SQL Server 7, 2000 TSQL forum.

-SQLBill

See if you can find "Start To Finish - A Guide to SQL Server Performance Monitoring" by K. Brian Kelly (Copyright 2002) from NetImpress Publishing, Inc.

It's an e-Book and I've...

I guess you were missing my point - I really do NOT recommend using Veritas' Agent for SQL Server. I have had bad things happen in the past with it....

BTW- if you want to read funny 'tech' stories...check out the Shark Tank at http://www.computerworld.com

-SQLBill

We will never get rid of bugs. Basically, a bug is anything that did not work as planned and is repeatable. You can't plan/test for every thing that a...

Why is the user using Query Analyzer? Do they have to be able to use it? Or is this just a case of "it's on their machine"? If that's...

First, please pay attention to where you are posting. This forum title is 'Anything That Is Not About SQL Server'. Notice the NOT........

Second, you don't post a problem/question. What do...

Use SQL Server to do the initial backup to disk. Then use whatever third party software you want to make a copy of the backup file to tape. This way...

First, you don't want SUM. You want to COUNT the number of rows, not add them.

This is untested.....

SELECT (SELECT COUNT(Col1) WHERE Col1 BETWEEN 15 AND 25) AS '15-25',

...

Shrinking a database or file doesn't always happen immediately, especially the log file.

If you do truncate it, do a full backup as soon as you can. Truncating the log 'breaks'...

There's a couple of great articles on this site about moving databases. Do a search or go to the article link.

The specific titles you want are:

Moving System Databases -...

EXEC is short for EXECUTE. That's what causes the stored procedure to run (or be EXECuted).

-SQLBill