If a stored proc call is not the first statement in a batch, you need to use the EXEC/EXECUTE command.

You code should work if you change it as follows :

Select...

The fact that SQL is using 6 Gig of memory is not a problem. SQL is designed to used memory to cache data and does not release that memory...

I would use SQL Profiler to check for queries that "take a while" to run. The "DUration" filter is what I would normally use as the first thing I...

Have a look at the "CREATE SCHEMA" statement in books online.

You will need to run something like

CREATE SCHEMA Production

Jeff is spot on with his recommendation about telling them the truth and highlighting your learning abilities (and contacting this forum is part of that) - it really is a...

Have a look at http://www.sql-server-performance.com. You should be able to get some good info about capacity planning etc

Right click on the server and select delete server registration.

You can also choose to edit the server registration and change the credentials (username and or password) used to connect to...

I agree that this can be an issue but you can help yourself out a little by reviewing the syntax of the "CREATE LOGIN" or "sp_addlogin" commands.

Both of these commands...

You could use the tail function to return the dates you want.

e.g

WITH

MEMBER [Measures].[Name] as [Date].[Date].CurrentMember.Name

MEMBER [Measures].[UniqueName] as [Date].[Date].CurrentMember.UniqueName

SELECT {[Measures].[name], [Measures].[UniqueName] } ON COLUMNS,

NON EMPTY { Tail...

Not sure that you will be able to do that. I don't know whether the Windows Cluster will be detected by the installer and force the issue...anyone else got...

You are right wrt log shipping to a passive node not being possible. Log shipping needs to be able to restore the transaction log backups. In its simplest...

My first thought is - Why do you need to access the object model when you have a perfectly acceptable (IMHO) IDE ?

If you found programming the DTS object model...

You should be OK to attach the MDF/LDF files. I would use a copy of them - just in case.

Yes - you certainly can. Simply detach from SQL 2000 and then attach to SQL 2005.

A word of warning : this is a one way process. When SQL...

1. You must always have a transaction log backup file so that you can roll forward. When you do a restore, the uncommitted transactions that are in undo...