Wow a 323 GB DB for US Veterans. The guy needs help knowing the setup for SSAS AND SSRS. I'm a little out-classed on that one.

http://www.sqlservercentral.com/Forums/Topic941073-391-1.aspx

0.3 TB of data for the veterans DB WOW.

With that scenario in mind there may be a way to use the same server for all 3.

Depending on how and who...

Only 1 solution here ... test it out.

Depending on the importance of the applications that are using the databases :

1 - If not critical, take backup in 80 or...

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...