I have dev and staging....in dev its working fine without adding the LOGIN to the TargetServerRole in MSDB??

Its windows attentication

Nita

Thanks this works great, but it also runs for Tempdb, PUBS and Northiwind database which I don't want to run for this DB. How to illiminate this DB.

Thanks, Can I change this setting to mix and How?

Steve,

Thanks for replying me back, I just have backup file, which I want to restore in one of the server,without knowing there data and log file how should I restore...

Its working now....but it took longer to open

Thanks

Yelena, I tried both opitons, still its not working???

Its yellow colour Warning generated, and I yes do use terminal services.

In my local machine when I close SQL Enterprice the Error message don't appear and when I

open its...

In system:

The following message:

Printer ActiveTouch Document Loader/USER19/Session 3 was created.

Thanks Sharma ji

Nita

So I need to create SQL profiler, and yes sp's are not encrypted.

WE have very small DB...and there are only 2 users (developers) running SQL query and Running some reports out...

No its not working....when I tried to do that I cam getting in ascii words.

Thanks It worked thanks for the valuable script and explanation.

Thanks once again

Nita

It worked through shrink via EM,

When I did

DBCC SHRINKFILE ('Hr_database_log',TRUNCATEONLY)

GO

Could not locate file 'Quanta_repl_log' in sysfiles.

Thanks

Nita

Thanks for you valueble help.

MS_SQL ver 2000

DB Name: HR_database

HR_database_data.mdf  size is 403072 KB

HR_database_log.LDF size is 40125675 KB

I took Complete backup then I ran

Backup LOG HR_database WITH NO_LOG

GO

dbcc checkdb

BUT Still the...