The Steps mentioned looks to be fine, But the question about adding another Instance on a Production Server needs some clarity, You must be aware that the Performance would be...

Then If I am in your position, I would create a Cursor that iterates through all the Tables in that Database and run this Command,

DENY UPDATE ON [dbo].[TableName]...

USE [DatabaseName]

GO

EXEC sp_addrolemember N'db_denydatawriter', N'UserName'

GO

Should Work

You should be looking at the DMV sys.dm_db_index_usage_stats

http://msdn.microsoft.com/en-us/library/ms188755(SQL.90).aspx

If Your Database Compatability Level is set to 90, then you can use the Reports available in the SSMS.

Select the Database in The...

Again Confusing...

You would not be...

I hate to say this nth time over the past week, Post the DDL Scripts for your tables and some insert scripts that helps us to setup the same data...

Please follow this Link http://www.databasejournal.com/features/mssql/article.php/3771296/Setting-up-a-Two-node-SQL-Server-2008-Cluster-from-the-Command-Prompt---Preparation.htm

Had the same problem in the past but did not worry going backwards since SSMS is more easy to use, any way I would keep an eye on...

I am unable to understand by this

From my knowledge, SSIS Package can run an SSAS Process but I have not come across...

Why would you need the Column Analyse in the Temp table when you don't need it?

Can't the below code work?

SELECT IForf.Bundle, IAM.Material

...

You should have moved the Files to new locations and that was the reason Gail or I was repeating what / How did you perform....

Hey, Those are not their Profile Names, they are...

So You don't need the Analyse Column at all?

That's true Lynn, I have not seen any clarification from the Poster what they are seeking and we sit in the middle to decide what's best for them without knowing...

Clive Strong (11/3/2009)

Bru Medishetty (11/2/2009)

You need to Shrink the Database.

Use DBCC SHRINKDATABASE or the Individual Data Files, using DBCC SHRINKFILE

Rather Use...