Appreciate that this may seem like a silly question, but you are running the procedure on the SQL 2000 server not the new server

Also you are running this version of...

Looks fine to me

What is the output of the below

SELECT

DISTINCT

YEAR(U.START_DATE)

FROM

CSMADM.dbo.USAGES U

So something like should do the trick

=SWITCH

(

LAST(Fields.Value.Value "DataSetName") = 0, "White",

FIRST(Fields!Value.Value "DataSetName) >= LAST(Fields!Value.Value "DataSetName"), "Green",

(FIRST(Fields!Value.Value "DataSetName) / LAST(Fields!Value.Value "DataSetName")) >= 0.7, "Yellow",

(FIRST(Fields!Value.Value "DataSetName) / LAST(Fields!Value.Value...

Is the table split over two rows as shown or is it split over 4 columns?

Also will the table only ever have the same two values in it, one for...

If you run the procedure with no username it will generate the script for all logins, then you simply just need to copy and paste the output to a new...

If you want to transfer logins from ServerA to ServerB, there are a number of ways of doing it.

Can use the transfer logins task in DTS or SSIS depending which...

If the databases are in standby mode they wont be able to connect to them, this is expected behavour.

What is your DR method, mirroring? logshipping? etc etc

That procedure will generate a script which matches the username, SIDS, password etc etc, then you can run this on your DR server and when you fail over, because the...

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 4 - memory management

Easiest way would be to lookup a procedure called sp_help_revlogins

Unless you have some form of custom auditing which is already switched on, getting previous update information will not be possible.

However, if you enable things like CDC or write your...

yes it will work after the ghost cleanup task has gone in and removed the data but your only buying yourself some time, you will need to get more disk...

You will have to do 1 or more of the below

Drop objects

Delete data

Add more drive space

Enable AutoGrowth if disabled

Remove unnessesary files from the file system

I would build a calendar table, something similar to the following here[/url], then you can query that table on a date you have and find the right date based on...