Not sure if I inderstand your requirement correctly but here's a way how you can create alternating colors. It's actually for alternating colors for each row,, but if you replace...

What exactly do you want to monitor? From your request it looks like you are just looking for the jobhistory and not really for SSIS specific logging.

Something similar to this...

Of course each new instance needs to have it's own cluster resource group,...

Just run the setup and install a new clustered instance.

It's not really different from installing the first instance.

Jason,

if you have multiple instances on on server during servicepack installation you will be asked which instances you want to upgrade. You can choose just one, several or all whichever...

@ry@n (12/29/2011)

---

MarkusB (12/29/2011)

---

What do you mean by accesing the B-Tree. Every time the query optimizer decides to use an index you will access the B-tree.

If you want to know how...

What do you mean by accesing the B-Tree. Every time the query optimizer decides to use an index you will access the B-tree.

If you want to know how many levels...

Not sure if this is what you want,...

To be honest, I'm not a big fan of maintenance plan either and prefer using my own custom scripts. John might think it makes the process more complex, but I...

Forget about it folks, I remembered the answer.

Of course the setup files are the same. It's the license key you use which determines which edition will be installed.

What about this:

SELECT TABLE_NAME, COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME IN 'Table1','Table2')

What version of SSRS and Sharepoint are you using?

Could this be the problem:

http://blogs.msdn.com/b/prash/archive/2010/05/05/integrating-ssrs-2008-r2-rtm-with-sharepoint-2007.aspx

You can get all that information by querying the ReportServer database.

This is a very basic example.

On your old server run the following code

SELECT j.name AS JobName

...

Detail Message: SQL server Error: @xxxxx: SQLAvailability::GetServerReachability: exited: Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Server is in script upgrade mode. Only administrator...

I would try using SSIS to import the SQL 2000 database.

I can't try myself right now, but I would think that's your best bet.