Hope this helps:

SET NOCOUNT ON

Drop Table #Usersdetail

Create Table #Usersdetail

(

IDintidentity(1,1),

DBName sysname ...

Execute your stored procedure and check under sys.dm_db_index_usage_stats DMV whether the underlying indexes have been used or not.

Also, tables and indexes dispalyed under actual execution plan are always utilised during...

What is the output of below mentioned commands:

Restore filelistonly from disk='Full path of backup file'

And

Restore verifyonly from disk='Full path of backup file'

MJ

Okie thats fine. Have you checked using logins current security context under security options?

MJ

What provider did you chose under other data source while configuring linked server to sql server 2005 instance?

MJ

Thanks for sharing the link Anrew.

MJ

If yours is an enterprise edition then you can make use of Database Snapshot feature for reporting purpose. Your way of reverse engg. looks fine. If you don't find any...

Something like:

USE MSDB

DECLARE @backup_date char(10)

DECLARE @countback int

DECLARE @sql varchar(150)

set @countback = 200

while @countback >=0

BEGIN

print @countback

select @backup_date=convert(char(10),min(backup_start_date),101) from msdb..backupset

print @backup_date

BEGIN TRAN DELE

set @sql='SP_DELETE_BACKUPHISTORY '+''''+ @backup_date+''''

exec (@sql)

COMMIT TRAN DELE

select @backup_date

set @countback =...

You should do the deletion in chunks rather than in one shot. Also, whats the size of msdb database?

MJ

Check this once:

http://www.sqlservercentral.com/articles/Auditing/62126/

DDL triggers will help you to audit database/server level ddl statements.

MJ

Try this:

Copy your msde instance master database files to a test system and attach it there (database with new name) and open check under sysxlogins table whether builtin\administrators group is...

Is the mdf and ldf files sent by client for system databases(master, model, msdb) or is it for user created databases?

MJ

Is autoshrink option turned on for tempdb database? What is the edition of sql server you are running on? Is there any transaction running at that time which is making...

Thanks for sharing the same Ricky.

MJ

Try connecting to the destination server using management studio and tell us what error do you receive? In case it doesn't work then try specifying protocol name in front of...