I'm new to the Index Tuning Wizard.  It's asking for a source table for the
trace.
How do I create one or is there a default one with SQL.  I'm using SQL 2000.
Any hints or links would greatly appreciated.

I have used SQLDMO Backup to do a full backup of a database to a single file.
I then copy that file to a different server to fully restore under a
different name using SQLDMO Restore. However I cannot figure out how to tell
the restore object to do this. I have played with the ...

I am experiencing lost events when using SQLDMO in VB.NET. For Example, I am
using the Backup object to backup a database to a file. I provide a call back
for Percent Complete and Complete, but only the percent complete gets called,
the complete never gets called.

I have this problem on a couple of machines, where when I expand the
Database list under the server (typically the local server, i.e. the one EM
is installed on) it takes a very long time to respond and sometimes hangs
for over 10 minutes.

When I try to add an ORDER BY clause to a SELECT with a UNION ALL
clause I get the following error.
Server: Msg 8626, Level 16, State 1, Line 1
Only text pointers are allowed in work tables, never text, ntext, or

I am running SQL Server 2005 bata on my Windows Server 2003, web edition
machine. Recently got an error that the Bata had expired. I ignored this.
However, other C# apps using the Db started having problems.
Uninstalled .Net Framework Version 2. I downloaded the most

Can sql server DTS packages be setup to run at a scheduled time by the SQL
server scheduler? if so, how would you do this?

In Query Analyzer you can save a lot of time by using this trick instead of
typing all the column names of a table
Hit F8, this will open Object Browser
Navigate to DatabaseName/TableName/Columns

Using SQL2000
I run a daily back up for DB and Logs as part of maintenance plan. I set the
option to delete files older than 7 days for both Dats and Logs. It does this
for the Dat file but not for the log. Is this a bug or is there something

I have a 300mb database, the transaction log is currently 1200mb!
I have tried to use DBCC SHRINKFILE and DBCC SHRINKDATABASE but neither are
having an impact on the size of this file.
The database shrinks, the system reports back the following:

Is there a tool that can tell me when was the last time a proc was used?
Thanks.

...using SQL SERVER 2k
I know how to hide system objects in Enterprise Manager, but can this same
sort of thing be done in Query Analyzer... like what I see done on the Server
tab of Visual Studio?

I am working with SQL Server 2000 table called dbo.proofofconcept".
I need to separate values that are all in one column that are space limited.
For example I have a column called tryit and the
value = '1234 456.75  01/01/2001 ABBR TRY@GSU.ORG 75%   $12.75  '.

I've just installed the latest Sept. SQL 2k5 CTP and they still have a
feature that is greatly annoying.  When I add a colum, I can only tab and
specify the name, type, and whether it allows nulls.  Why did they have to
remove the "Size" colum?  It is a real pain to have to click ...

I need to monitor creation/deletion/modification of objects in a database.
I decided to use sql profiler with objects events auditing(create, delete)
and TSQL events (SQL: STMstarting, SQL: batchstarting) for 'alter' statement.
It's working, but I've encountered a few problems I ...