You could use the Showplan (see BOL) to give better estimates of the number of reads etc that each is using, however you'll probably see something easier by a quick...

Did you try

DBCC SHOWCONTIG ('TRANSACTIONS') WITH ALL_INDEXES

?

The other thing is to make sure that 1434 is open, if it's blocked you'll not be able to find the instance.

Best way around this is to use Outlook 2000.

I've found that a lot of places are cheap, however they seem to be a little better if you can show a real Return On Investment (ROI). For example I...

set nocount on

declare @myVar varchar(40)

declare @sql varchar(1000)

declare @numrows int

declare @mycount int

create table #thecount (countrows int)

set @myVar='HeaderTransLog'

set @sql = 'insert into #thecount select count(*) from ' + @myVar

exec (@sql)

select @numrows =...

It's thinking that the @myvar is a table variable in the select statement and so is looking to pull data from it. Use the variable to create a dynamic query...

Without the datafiles (or a backup of them) you will have lost all of the data on that server. The mdf files contain all of the database data.

You could run an sp_startjob as a TSQL step within the DTS, however it's not going to wait until the other job has completed before it goes on to the...

The /~Z indicates that it's an encrypted hex string, which probably relates to either the package name or the package guid.

If you right clicked on the package and selected the schedule package option then you'll find that the job name is the same as the package name.

I prefer to use...

Within the stored procedure set the @user_id to have a default value, check for this default value, if it's the default run one query, it it's the other run the...

You need to install the Oracle client tools onto the new server. Without them you can't connect to an Oracle server (you will have to update the TNSNames file as...

You may get into this situation, when you configure your replication agents to log into the publisher and/or subscriber using "SQL Server authentication" (where you specify a specific...

You can look at the script, or look in the properties of the publication, under the snapshot tab.

Be careful removing any of these as you might be removing something of...