Do the developers require the production data also every night?? But why do they require the production data everynight?? You will have to ask the purpose for this. And if...

Well I 100% agree with Gail that why would you delete the log file??? This would certainly lead to serious implications including the database going to suspect status. Also if...

Are you able to connect to reporting services through Management studio. What login you use to connect there?

If you only want to browse through the reports then your account needs to have the browser permissions. You need to have the admin rights(content Manager) to assign a role to...

The autoclose option must be checkd for this db. If you remove the autoclose option for the db you would not get the message in the log.

Your transaction log backup will be blocked by the full backup and until it finishes the tlog backp won't complete. So the restore process will not happen till then at...

This login is used for the linked server processes at quite a few servers and is also used for few jobs. So it is really difficult to reset the password...

Simply do this.

use master select 'kill',spid from master..sysprocesses where db_name(dbid) =  'PIT_TEST'

Take the output of this and do the following

--Make sure that you run all these commands in one...

Use this script. I got it from on this site only.

--Script to script out all linked/remote servers

--Works on 7.0 and 2000 servers

--remote password decrypt only works on 7.0

declare

You will have to enable the logging for the dts package to get the detailed description. The job history would not give you the exact details of the error in...

You can also query the sysprocesses table to check that.

We already have a central repository where we store the information of each server. The set up goes like this-- We have a admin database on each server and every...

You can truncate the transaction log and then shrink it.

Backup log <you db name> with No_log

Dbcc shrinkfile(<log file name&gt

You can set up recovery mode...

Hi Sugesh

How can we foramt the output and put it in a table so that we can easily query it.

BUt how do I alter the database when sql server is not running. How do I connect to the query analyser??