I already use sp_help_revlogin to invoke 'sp_hexadecimal' and script out the users.

what I'm concerned about is scripting out the users permissions so that I can restore my PROD DB...

With the additional Memory, what kind of parameters would have to be changed or what kind of tuning would ahve to take place in order to take advantage of the...

http://msdn.microsoft.com/en-us/library/ms345408.aspx

I used these commands to modify where the files exist (model and msdb data and log files)

ALTER DATABASE database_name MODIFY FILE( NAME = logical_name , FILENAME = 'new_path\os_file_name' )

and...

After the 'components to install' screen , The upgrade is blocked because it thinks that I am installing a different edition.

on the Feature Selection screen or ''components to...

It is never Prompting me to keyin a new Instance name !!!!

Why all of a sudden do I have to run the install from a command prompt??

My mistake. I have 1 default Instance and 2 named instances and am looking to install a third.

We only have SQL Server 2005 Standard Edition in House so...

We are upgrading for a couple of reasons: Support has ended for SQL Server 2000. Our SQL Server 2005 Instance is on a shiny new and...

Thank you for the clarification and information : )

I do not have a SQL Server 2000 instance that I can try this in..

So there is no way to de-cyrpt these stored procedures in a 2005 database?

Thank you! I tried this method and it dropped my stored procedure!? Here is what I did:

I downloaded the script to create the stored procedure then created...

Thanks. I read that before. I was looking for some pratical experience advice.. : )

Thank you all so much for your help!!! The last one worked best for me!

Thanks... I have about 60 rows in this one table and your select returned over 400 rows.. duplicated most of the tables many times.. I'll...

Mike,

Thank you for your insight. I will try a couple of things and let you know how I make out!

I know this should probably be a different thread.....

but now that I have my 'sa' problem resolved, I am getting this error on a bunch of tables:

Could not...