I agree - really good question. I originally didn't like that the difference in column names was so subtle, but after thinking about it for a bit I think it...

Hi Rayven,

I experienced a similar issue recently. My problem ended up being that the application that was making use of SSRS had installed custom authentication and stripped out my own...

Good question thanks Tom. Made learn more about sql_variant comparisons.

Got the answer wrong though as thought it was a trick question too.

How is the job being executed? Is it a SQL Maint plan, or T-SQL statements?

Do you get the same result when you run the command manually?

Could you execute sp_who2? Do...

Top question!

Thanks for the explanations too

I couldn't agree more. Best to get it right the first time.

It may cost $1000-$2000 a day for a top consultant, but that is nothing compared to the cost of...

Hey,

By 3/4 i meant we use 3 of the 4 availablity / redundancy options I listed.

We use:

- SAN based replication (which you will not be able to use)

- DB mirroring,...

Hi,

- I recommend that you run this in a cluster to help protect against hardware failures.

- Why do you need logshipping with such a small delay? If you are after...

You should change the port in SQL Server Configuration Manager.

You only need to make this change once as this will take affect on ALL nodes (ie it is 'cluster...

I agree with Jeffery. I was wrong, but close!

I thought that you had installed SQL server into the cluster group, but from the output you have given, it appears you...

Below is an example of how I think your cluster should be setup (what you would see in Cluster Admin)

Groups

CL2

Cluster IP Address

...

It certainly looks like the installation was different between QA & PR.

The information you gave is still suggesting that the SQL Server instance was not installed in the Virtual Server...

Hi,

It is not possible to change a named SQL 'instance' (e.g. Virtual Server\Instance).

However it is possible to change a default instance by changing the Virtual Server name

http://msdn.microsoft.com/en-us/library/ms178083.aspx

Hi,

When administering (stopping / starting / failing over etc.) a cluster SQL instance, you should use Cluster Admin.

Books Online recommends that you use SQL Server Configuration Manager to change the...

Just because the service is not cluster aware, does not mean the installation isn't 😛

SQL Browser is installed on all nodes when you install the database engine.

Have you checked if...