Hi, Has anyone come accross a issue when a SQL Alert is emailed to you it has the incorrect date at the top of the email body?! I have checked...
hi, Aquick question, If I setup MDW on a 2008 box, can it monitor 2005 servers?!? Cheers Stew
Hi, I have recently started a contract position where they have a Active Active cluster with all the instances listening on 1433. Is this...
Hi, I have a maintenance plan that has been running for months that backs up the database to a remote share. Now the job is failing due to...
Yep managed to get a solution thanks, for the record 1) create a reporting services report 2) create a subscription that doesnt start for a while 3)...
cheers for that, hopefully I will be able to get something running. stew
Hi, Is there anyway to lauch a reporting service subscription via t-sql. I have a job that through out the day checks a folder, if a file is...
I am trying to interrogate a xml field I am trying to use the below code: select convert(xml,a.manifest).query('/Outputs/* ') as result,a.manifest...
Hi, I have a weird problem, that seems to me is a bug in SSIS and I was wondering if anyone else has come accross it or has a fix. I have...
Why dont you just do the following:SELECT * FROM [msdb].[dbo].[backupset] where backup_start_date >'2010-01-01'
Why dont you just do the following: SELECT * FROM [msdb].[dbo].[backupset] where backup_start_date >'2010-01-01' OR SELECT * FROM...
I also have a textdata column value of '1:726640'
I have done a trace to find some sporadic timeout issues. I have located them in the trace table but I am now trying to find out the underlying...
I have come across one of our servers, Which has a 64bit windows 2003 enterprise server O/S with 8GB of Ram. The SQL version on this server in SQL...
Hi, I have a relatively simple report that is using a graph which plots total costs by month. I am trying to link this to another report using...
Yet whenever I try and setup the replication on the SQL 2000 box it says that This SQL Version (10.0) is not supported!
Is there anyway I can setup a subscription on a SQL 2008 server with the publication on a SQL 2000 server. I keep getting the error message version...
Hi, A client is currently running merge replication between two servers. The publication is only two tables but they use Automatic identity range...
Hi, The identity range is part of the primary key which means I cant exclude the column from the replication. I guess the only other way to...
Hi, To be honest I am not too sure why they want to re-publish, we dont really support this customer, but I expect its maybe for a test server. I...
Separate names with a comma.
