If you just want to know which tables have the most rows, try a query like this:

--

-- Number of Rows In Each Table

--

select s.name AS 'Schema', o.name AS 'Table', i.rows...

Don't have an exact answer -- but here's something to try.

Make a copy of your database on the publisher, and set the compatibility mode on

the copy to normal SQL 2008...

I don't think your OPENROWSET() syntax is quite correct.

In particular, I think you need to capture (i.e., SELECT) the recordset that OPENROWSET()

returns, and stuff it into a temporary...

Not sure this is a totally accurate indicator of utilization, but might be "in the ballpark":

-- Low-Budget Way to Get CPU Utilization

DECLARE @CPUStart INT,

...

You might look into creating a CLR function involving the "String.Split()" method.

>> Being Around Smart People is Exciting

OK, sorry -- I just have to ask...

What is it then when one is around "Dumb" People?

What kind of error messages are you getting when you fail to connect?

Are your domain accounts members of the local administrators group on the server?

Well, I've not really ever had to deal with this matter either.

But my thought is simply to make sure you capture the UserID and current date/time whenever someone makes a...

You could write some SMO code that would basically iterate through all the stored procedures in your database, extract the underlying TSQL for each and try to compile it. ...

Anyone?

Well, I don't really know the answer--but I can tell you that if things are set up in your environment properly, "failover" should be a fairly rare occurrence...

If...

If you don't wanna use full text (it's a bit tedious to set up and configure), and your description field in the table is less than 900 bytes, you could...

Cool. Glad it helped.

I often use parameter validation in the proc -- ALONG WITH default parameter values on the proc --e.g.,

CREATE PROC spMyProc

@State CHAR(2) ...

You've got some huge tables.

Where is your "reporting" database?

same NAS / SAN drive(s)?

different server/different drive(s)?