I got it working.

The proc uses dynamic sql based on parameter values from the report. SQL gets stored in a variable and then that sql is executed.

I modified the...

Got it... Added:

AND bh.Server NOT IN

(SELECTrel.Server

FROMReportExclusionList rel

WHEREbh.Server = rel.Server

ANDbh.database_name = rel.DatabaseName)

AND bh.database_name NOT IN

(SELECTrel.Server

FROMReportExclusionList rel

WHEREbh.Server = rel.Server

ANDbh.database_name = rel.DatabaseName)

Works as...

The issue with that is the passwords. There are about 250 users using SQL auth.

This db is used for an internal app and there's no way the app can...

That did the trick.

Thank you very much.

When you mention collation, what was it set to?

Right.

Create Partition on existing data:

1. Created a partition scheme and function.

2. Created OrdersNew table with Clustered index on OrderDate and OrderID and placed both on partition scheme.

3. ...

It looks like I can't partition an existing table that has any indexes with more than one column defined for it...

If I need to do this then I would have...

Sorry maybe I should have elaborated...

The actual table is 800 million + rows...

The example is just a made up table for simplicity...

I am curious as to how to get around...

Do you know how and where to change it?

Thanks guys.

I have verified that both servers are using ENGLISH as the default language.

I think I may have just figured it out...

I need to add the badgekey to the join clause:

SELECT AA.* FROM BADGELINK_ACCESS_ADDED AA

LEFT JOIN BADGELINK_ACCESS_REMOVED AR

ON (AA.ACCLVLID = AR.ACCLVLID

AND AA.BADGEKEY =...

Right. The catch 22 was that I could bring up the server in 'maintenance mode' but as soon as I start SSMS the resource db is accessed which of...

OK. Finally solved it...

Numerous posts explain that you can bring up the server with the 'f' switch. What this does is only brings up master database and the...

Awesome.

Thanks

Here's my current setup:

torsqla01n1 - active node

torsqla01n2 - passive node

DB instance name - sqla17n1

virtual name - sqla17

How should I connect to this guy in Studio Manager?

I assume it is TORSQLA01N1\SQLA17

Right...