Well just answer me this.

How big is the db right now?

If it's reallllly small (like under 15 GB), and that it doesn't plan to grow by much short term, you...

Why do you want to change the compatibility level for all dbs at once?

Here's a quick script to identify them :

SELECT name, database_id, compatibility_level FROM sys.databases where compatibility_level <>...

rudy komacsar - Doctor "X" (3/31/2009)

---

A somewhat non-intrusive method is to set the databases to 'AUTO CLOSE'.

Then all you have to do is scan the errorlog to see which ones...

Am I the only one picturing Joe Celko as The Architect??? :w00t:

It depends on your usage. Assuming you have more than tiny dbs and a decent number of users that need to do reporting and analysis (let's say 30+), then...

So your absolute max bonus is about 8.4 days worth of pay?.. doesn't sound like much.. .tho it's better than 0 days of bonus ;-).

Yup been there, was definitly worth the...

Glad to help :hehe:.

Toreador (6/21/2010)

---

I agree with Hugo - I knew the modulus answer, but had no idea what the others were. So got it correct as only one option had the right...

only4mithunc (6/19/2010)

---

Hi

As per my knowledge there is no direct method, but explicitly you can do it by:

1. Create one general SP,say sp_ReportHeistory

2. For each repot use this...

Yes there's an history reporting built in but ou must activate it first.

ssms

connect to reporting engine

righ click on the report server name

properties

logging.

check activate. If you chose not to delete the...

Try query type : procedure

then put

dbo.stp_deliverystatus

as the datasource

then you should get the promt to manually enter the 2 parameters once so that BIDS can download the dataset properties and...

Gianluca beat me to it, but this is straight from BOL (Create synonym).

Assuming you didn't reverse the db and server in your question, this should work :

EXEC sp_addlinkedserver '06dw';

GO

USE...

MelS-512196 (6/16/2010)

---

Since all the "big guns" are posting on this thread, wonder if I could get some thoughts on a design I am contemplating. We will have multiple sites,...

scott.pletcher (6/15/2010)

---

Jeff, you can over-engineer, I'll give you that. Huge amounts of wasted I/O to no purpose. But you feel good about it, and obviously for you that's...