Sorry Here is the Test Data, Data in 'result' table should be the final data after processing

TIA

CREATE TABLE #mytable

( ...

Thanks,

GRANT VIEW ANY DEFINITION TO User1

This will give permission to see all rows to use1 in metadata and catalog view.

Lets say you have 2 logins. One with DBO and another without

DBO can see more rows than other login.

TIA

Thanks,

I know I can use sys.sql_modules but still I am Perplexed why sys.syscomments is not showing all rows.

Use

=MonthName(Month(Parameters!DateBegin.Value))

I am 100% agree with this article. System generated name cause so much problem when you are comparing two databases. Lets say If you want to compare Development and production...

Transaction Replication :

Creates new database in system databases : Distribution Database

All replicated table should have Primary Key

Need to deal with Identity Columns/Triggers

Creates new SPs ( 3 Sps of one table)

Latency...

Thanks Adam, I was looking Summary menu Item in SP2.

Appreciated your time and help

I am able to see summary menu item in view menu in my home computer but same is not available in my other SSMS, both have SP2 installed.

Thanks

Sandeep

I will prefer backup and restore. Don't forget to change 'Compatibility Level' to 90 and

DBCC UPDATEUSAGE (0);

thanks

Check your distribution clean up job. It might be failing or not running. I had the same problem. My distribution cleanup job was not running at all.

Generate script will generate the scripts for table structure not the data. if you want the data also, use either Import/Export or SSIS for that.

Thanks

You can also use sp_helpdb and see the dbsize column of the result. It will give you total size of database including data and log files.

Sandeep

You can you same DDL Triggers in SQL server 2005 as you were using in Oracle