Greg Edwards (1/29/2009)

Ninja's_RGR'us (1/29/2009)

Lynn Pettis (1/29/2009)

Michael Earl (1/29/2009)

Ninja's_RGR'us (1/29/2009)

Greg Edwards (1/29/2009)

So when The...

I just build a massive report like this.... you knoq the kind where they want to see everything for every part of the business on the same report.

The only way...

That statement compiles for me (no idea if it's doing what you want). I'm guessing it's a copy and paste error or you're missing something like : "=...

Lynn Pettis (1/29/2009)

Michael Earl (1/29/2009)

Ninja's_RGR'us (1/29/2009)

Greg Edwards (1/29/2009)

So when The Thread gets a...

Greg Edwards (1/29/2009)

So when The Thread gets a 100 posts or so, does...

I'm sure you can find the time to run this statement and get your answer :

SELECT name, crdate, cmptlevel FROM master.sys.sysdatabases ORDER BY cmptlevel

Michael Earl (1/29/2009)

Michael Valentine Jones (1/28/2009)

Should Michael...

Then when would NOW be the time to rectify that?

It doesn't matter, you're still vulnerable to attacks.

Check this out for a better view of the problem and solutions :

http://jumpstarttv.com/hacking-sql-server_76.aspx?searchid=15442

I was under the impression you were only filthy rich :D.

The limit should not be put on the amount of users, but the server should be adjusted to the needs of the company.

If you have way too many users for...

Ya grant don't rub it in, she's not a consultant anymore :P:hehe::cool:

How about doing performance tuning, adding subscriptions to run the reports at night, if all fails, adding more horse power on the server?

Why are you going down that route? What is being asked of you?

Hey guys, how long do you think it'll take for this thread to hit the 1 Million views?

We're already at 31 000+ in only a few weeks.