Thank you, Daniel for your response. I actually did the same way you described in your post and it worked. Thanks.

I'm using SSRS 2005 to build the reports. In my solution, there are two reports (R1 and R2). In the report R1, there is a variable x which is changable...

I finally found the solution without restarting the SQL server. Here are the steps I did:

1) Check if the Default Trace is enabled

2) If it is disabled, just enable it...

We have the exact same issue as you had on one of our production database servers (MSSQL 2005). Did you fix it? If yes, could you please share your light...

I would try to execute the SP on SSMS and see what returns:

EXEC [dbo].[COB] @ItemCode = N'S270740', @DelDoc = N'0625117GWJK'

I think there are three tables (MainProjects, mmaster and ITEMS) related to your query. If you can post the definitions of these tables and what you want to do, we...

Welsh Corgi (7/22/2011)

---

OK, you are correct assuming that you you have a monitoring system but you you still have to determine what the source of the problem is and the...

You are wrong. The alerts will be sent out from monitoring system.

Since SVR said "The server crashed. You cannot access anything". it means you could not log on to the server. That is possible. I agree to use disaster recovery first,...

If they told you that you were not able to log on to the crashed box, you could ask them if the system engineer took a look. Usually when the...

In your SSIS package, is there a step to export data to Excel? If yes, you are using 64 bit SSIS which does not support Excel driver. You need to...

I do not know if the Windows can be restored to the new server since I'm not a system engineer. But if I get a new server, I will ask...

If you only need to back up a specific table, bcp Utility is the easier way to do it. Check the bcp Utility at http://msdn.microsoft.com/en-us/library/ms162802(v=SQL.90).aspx.

I think you need to remove ")" from your code at 4th line from the bottom. It should be

GROUP BY G.GroupName

FOR XML PATH('tr'), TYPE

) AS NVARCHAR(MAX) )

+ N'</table>'

I would suggest to use the system stored procedure sp_addarticle and sp_addsubscription to add your tables to your replication. You can put your 100 or more table names to a...