In the Wizard there should be a selection to apply to all instances or to the specific instance

You can run the package from the parent package.

You can also run DTS from from SQL Statement either as a job sp_start_job or as a command-line executable xp_cmdshell dtexec <parameters...

I use Management-> Current Activity window Processes view in 2000 and Management -> Activity Monitor in 2005 to find out who is connected and sort by Last Batch field.

I just ran Profiler for the opening of properties. It gives us the following for the Row Count (this is a part of Select ). If I read it correctly...

I don't think there should be differences.

while the aggregate usually don't count NULLs, count(*) counts everything including nulls and duplicates.

BOL says: "COUNT(*) returns the number of rows in a specified...

Alex,

It depends on your business process and your billing / payment practices. For example, if there are 2 departments that pay out of their budgets and you consolidate their databases, who will...

Steve, that is what I meant: space on the drive, not inside the file.

Every answer is wrong here so I just cliked any.

The question states: "You try to truncate the log, but it does not free up enough space"  Truncating the log...

Do this:

Log in to your Dev3 as the service startup account that you call in this post domainacct and try to access a share \\Dev1\Folder\File.txt yourself doing it as...

I am not sure if it was in the Resource Kit or Support Tools or AdminPack all 3 are available as Martin says at Downloads page on Microsoft website. The...

On which machine? Also, are all 3 machines in the same domain?

In IIS Manager go to your website properties and click on ASP.NET tab. Make sure the correct version is selected in "ASP.NET Version" Then go to the Documents tab and...

Did you set up the Share permissions in addition to the folder NTFS permission?

To make sure what is going on, run the package and right after that check the security...

A lot of events are listed in

Kevin,

If you need to reach an object on the same server in a different database use:

databasename.schemaname.objectname like MyOtherDB.dbo.MyTable

the login who is running code has to have permissions to the other...