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...
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...
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...
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, A Client of our is trying to replicate a article that is currently apart of a merge replication publication. They are trying to setup a non...
Hi, I have a report that executes a sproc on a remote server that pulls back summary data and also creates two global temporary tables. Ideally I...
Hi, I am new to reporting services building so sorry if this is a stupid question. I have two datasets that reference two SQL Servers. What I want...
Ok here is the problem, when I run the below script I get...Msg 296, Level 16, State 3, Line 44 The conversion of char data type to smalldatetime...
I want to use a indexed view how can i re-write the following?--SELECT M.master_no, M.cust_id, M.master_status, M.barcode, L.LOCATION_DESC AS...
Hi, I am trying to build a report using the below dataset, select database_name as [Name], [Total_DB_Size(MB)] as Size, Date_Captured as [Date]...
Hi, I have a transaction thats probably copying accross say 100 000 rows. I have set the transaction log to auto grow both by a percentage and...
A DTS package is running via a three step job, each step run a DTS package. The second step is erroring with the error below: Executed as user:...
Separate names with a comma.
