Hello,

Yes, it is possible to install SSRS on Windows XP.

What version are you trying to install: 2000, 2005 or 2008?

Do you already have any SQL Server versions running on the...

Hello Hema,

Just to check, can you create one connection to the SQL Server Okay and then subsequent Connections fail with this error?

If so, I just wonder if the maximum number...

Hello,

Here is a decent article on tracking down the causes of Deadlocks:-

http://www.simple-talk.com/sql/learn-sql-server/how-to-track-down-deadlocks-using-sql-server-2005-profiler/

The good news for you is you know when the Deadlocks usually happen and therefore when to profile.

Regards,

John Marsh

Hello again,

A couple of other thoughts:-

1) Although you have granted permissions to the Object XYZ to the Login, is there any possibility that they are in a Group that explicitly...

Hello Sylvia,

Have you had a look at any of the Third Party Tools on the market? I am thinking of ones such as RedGate’s SQL Compare and Data Compare. There...

Hello Alex,

The KB article is also relevant to SQL Server 2005 (there is an “Applies To” Section towards the end). I don’t know of any significant changes for SQL Server...

Hello again,

When I changed the name of the Table in the Create Table script that you provided, the query worked on my Server. (Strictly speaking, I also had to add...

Hello again,

Any chance you could test with the NoLock Hint commented out? At the least it would eliminate it from our inquiries 🙂

Regards,

John Marsh

Hello,

The Table Definition provided is for a table named "ALARM“, while the SP references a table named “CAF_ALARM”. By any chance, would this typo be your problem?

Regards,

John Marsh

Hello,

I would just like to clarify a few points:-

1) When you say “delegation settings r done” does that mean you are using the Linked Server security option of “(connections will)...

Hello again,

As we don’t have your table definitions, we can’t test it, but at a guess all you seem to be missing is an Update statement before the first “Return”...

Hello,

I guess you are using Print statements to generate the total lines? Try using Selects instead, it may help. Have a look at the following sample code:-

Set NoCount On

Declare @Total1...

Hello,

What is it that you want to know?

Regards,

John Marsh

Hello,

For your first question, it may be worthwhile taking a look at this article.-

http://www.sqlservercentral.com/articles/DTS/portabledtspackages/865/

For the second question: It is possible to Password protect DTS packages. Please see the Books Online...

Hello,

Your ASP code is not visible. It may be best to include it as an attachment.

Possibly a good starting point would be to set up a Profiler on a Dev/Test...