please try DDL Triggers if you having SQL Server 2005 or Higher

How many datatabase you have in SQL Server 2000?

Check your SSMS's Object Explorer

It gathers lot of information while you connect a database. Right click on header fields and select only...

If your users are in Active directory there will no issue occur. But I suggest test out your complete migration plan with new domain before go final migration

plz contact your mail server Administrator

Would u please share the complete scenario with some samples?

Same resources as you configure first instance.

Most important is SSRS Key Backup

Check VIEW DEFINITION Permission if you have SQL Server 2005 or higher version

Yes! you can install another SQL Server Instance on A/P cluster but you have to separate resource for the new Instance.

Hi,

There is option to copy .mdf, .ldf files even your database is online. The technology is VSS (Volume Shadow Copy) SQL Writer service coordinate with windows VSS service and provide...

check http://mssqltips.com/tip.asp?tip=2319

Hi,

It is possible and look like :

DECLARE @STR Varchar(max)

DECLARE @TableName Varchar(256)

SET @TableName = 'YourTableName'

SELECT @STR= ISNULL(@Str,'') + ', ' + Column_Name

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = @TableName

AND...

Hi,

check your request waiting by quering following.

select session_id,start_time,status,command,DB_NAME(database_id) As dbName

,wait_type,wait_time,t.text

from sys.dm_exec_requests r

cross apply sys.dm_exec_sql_text (r.sql_handle) t

where r.session_id >51

order by r.wait_time desc

Ask following questions to application team before migration.

1.Does application upgraded to use SQL Server 2008 version database?

2.If your application is not ready to use Database in compatibility 100 than what...

Hi,

There no native option/feature available in SQL server to do this. The Most important thing is that what is your requirement? Why you want to maintain 2nd copy of...