Not sure if you are using a listener, but when you fail over and if you used the SERVER1 name, you connection may fail and that is not longer the...

Yes, sp_whoisactive and sp_who2 are very useful and have already been run. There is no activity on the server. The only action is the drop / restore. It may...

Chris, glad you solved your issue. Take a look at the solution I gave above, my guess is that you are experiencing the same blocking that I was. ...

I experienced this problem and found a solution, so hopefully this will help others.

Action i was doing; I was importing data from using a query into a table. The destination...

Another issue that is somewhat related to this is installing on Server 2008 R2, which requires the installation to be slipstreamed. Its best to check before running the installation. ...

Off the top of my head, if you have a sequential ID you could setup a loop using something like a CurrentID and select the "TOP N" rows where the...

Very Good Article: What I see a lot, are replies that do not provide the best answer. I understand that people often provide a solution without looking at...

This problem has been resolved. Not sure of what was causing the problem exactly, but applying SP3 resolved the issue

Sorry I cannot post the text of the trigger, but here is what it is doing, nothing complicated;

Insert into table( … )

Select inserted.ColumnA, deleted.ColumnA

From inserted inner join deleted

Where (deleted.ColumnA ...

This is a known issue with reporting services. We had to change the code to go directly to PDF. and then print from there.

Your original post didn't mention if you were trying to export PDF, but some of the responses mentioned it, so maybe I missed something. If you are trying to...

You are correct in you question / answer. You cannot control then in reporting services and one way to design around it is to gather the parameters using something...

on the layout tab, click on the box containing the data (cannot remember it official name right now) ; click on the group "row" that you want to edit....

there are some differences, but mostly depends on the complexity of your DB. On way of getting a good estimate is to run the upgrade advisor on the 2000...

Have you found a solution to this yet? I am having the same problem.