David,

Thanks for the reply, looked on google and forums yesterday and only got how to change collations etc. This should give me what I need.

Cheers,

Andrew

I have had this issue in the past and I followed the steps in the KB to fix it: http://support.microsoft.com/kb/914157

I use dts packages with a connection for each server I want to monitor, I then have an execute sql task for each monitored server that collects whatever I am looking...

Do each of the seperate queries that the union combine return values distinct from each other, if so you should use 'union all' this will just union the results, whereas...

Does the table have a primary key? I know that I had issues with openquery when the table being deleted from did not have a primary key.

If you can run the batch process via a stored procedure you could then have that stored procedure as an article as part of you publication. This way you will...

I had a similar issue and fixed it using this:

various versions or instances of MS SQL Server

you may hit the problem of

---------------------------

Microsoft Management Console

---------------------------

Snap-in failed to initialize.

    Name:<unknown>

    CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}

To...

Have a look in books online for xp_execresultset, you could also search this site, it has some examples of how to use this.

Look in books online for the union clause, as long as the data tyes and number of columns are the same you should be fine.

Yuri,

It was an install on a developers machine, I noticed that he had installed a version of Visual Studio 2005 installed that he had downloaded from msdn. I uninstalled that,...

A basic create databse command has the recovery model as full, if you are not doing regular transaction log backups then the log will bloat over time. Is the databse...

set your self up a monitoring instance of SQL, use this to run the monitoring.

I believe you should be able to do this, but be aware that you will need to use msdb.dbo.sp_update_job to do it:

EXEC msdb.dbo.sp_update_job @job_name=N'test',

  @enabled=0

If you try and update...

Check out NB article http://support.microsoft.com/kb/224071/ goes through the process step by step

select

db_name() should give you what you need