Lowell,

Thanks for your input.

i have it scheduled on my dev machine to run daily, since i never turn it off; i may be biased but i think it makes a...

Looks like shrinking, backup, restore is only way here.

: (. Like to know any precaution/catch to shrink a 300GB datafile to under 100GB.

My PROD is a 2-node clustering with a...

The logic is more complex than just direct update to another table from inserted and deleted virtual table.

I need to process row-by-row in inserted and deleted. That's why my concern...

old hand,

What do you suggest? Will WHILE loop better than cursor?

Thanks for your reply. Looks like logic has to be in trigger. : (

I understand that after trigger in SQL 2000 fire on per stmt basis. Thus, I need to write...

If I do need to remove BOL, how do I remove BOL after SQL Server installation?

I tried loaded back the installation CD and choose "Upgrade, remove and add components...." from...

Thanks, Enthusiast

I am thinking is there a more generic way of achieving this rather than hardcoding the table name in filter. Reason because if new tables are created the filter...

PROD & DEV is on diff site and on diff LAN zone. I can't use DTS. The data is in tens of GB in size and 300s of tables. If i use...

Yes, it's DB restore from DEV to PROD.

use master

go

RESTORE DATABASE [DB1]

FROM DISK = 'D:\DBA\MSSQL\BACKUP\DISK[DB1]_AFT.BAK'

WITH Recovery,

MOVE '[DB1]_Data' TO 'D:\MSSQL\DATA\[DB1]_Data.MDF',

MOVE '[DB1]_Log' TO 'D:\MSSQL\data\[DB1]_Log.LDF',

REPLACE

go

Because DEV only has only 1...

With more than 4GB memory and Awe enabled, Memory will not be dynimically allocte to SQL Server anymore. SQL Server will grab all the physical memory minus leaving 128MB for OS....

Michael,

Thanks for the advice.

1. That's exactly my concern. The domain user is merely a normal user account in the SQL box with minimum rights. Security people refused to grant higher rights...