You can do it a couple ways.

1. Set up a linked server to the server in question and use the sp_testlinkedserver system procedure to check.

begin try 
exec...

Your connection string should have a failover partner parameter in the connection string if you are connecting with ADO.Net or SQL Native Client. Replication does not have that type...

I was able to solve the problem by creating a different where clause and adding a second dataset with a union to pull in the servername.

1. First data set...

There is only one database on the server, but I would like to upgrade the compatibility level of the database to 100 because I would like to take full advantage...

I found the solution to the problem. Take the two schema options you would like to change and perform a bitwise AND on the two numbers. If you...

Just make sure that you are not changing the recovery model in the process.

Shrinking a log file of the primary database is not going to break log shipping. All log shipping depends on is sequential restores of the transaction log backups to...

The high safety without automatic failover.

I personally have never had any trouble with different file layouts between the principal and mirrored server, but if you are adding an additional data or log file it would...

Why do you think this? It may be...

The first thing I would do is disable the job that is shrinking tempdb every two minutes. Just make sure you have some way of monitoring the disk space...

One more thing. Each time you either restart the server or restart the instance, tempdb gets recreated. Make sure you size your initial configuration accordingly because if you...

Each time the tempdb, or any database for that matter, has to grow the server takes a performance hit. So if you are growing the tempdb out 2 GB...

Do you have autoshrink on the tempdb log file or are you shrinking the log file on a scheduled or manual basis? How much free space is located in...

check and see if there are still open transaction in the database. dbcc opentran.