Thats it...

Why you want to hide them?you can make them not accessable...

In 2000,query analyser one can only see the databases they have access and in 2005 Mgmt studio its not...

I think even "public" role can run this...not sure

Otherwise look for "View server state" permission

You can script out the logins and database jobs and run them in master and msdb databases respectively on the secondary server(which is now online)

For user mapping use sp_change_users_login which...

Go to login properties-->user mapping and select the only database that the login require.When login 1 connects he'll see db1 only.

if the table has one millinon rows:-)

Try something like this...this works i think

while @startposition<=6

(

select SUM(Value) from

where id >= @startposition and id<=@endposition and DID=@DID

select @startposition=@startposition+1

select @endposition=@endposition+1

)

Create a AFTER TRIGGER for INSERT....or you need to manually insert the rows in currencyclosed table everytime.

Since you have performed a log backup,you'll have free space in the log file.Now shrink it.You'll get space released to the disk.

Never truncate it....it may lose uncommitted transactions by doing...

Check out any windows scheduler tasks are scheduled on the server.

We too had the same problem.we had dual core cpus that time.After changing them to quad-core the issue was solved.cpu...

Sql server takes care of restoring the log backup files on the secondary server.You need not make a batch file for this.The restore job on the secondary server will do...

In full recovery model,all the DML transactions are logged and unless you have a periodic transactional backups,the committed transactions are still there in the log file.This makes it to grow...

When you move a clustered index to different filegroup,that means the table is moved .sp_help 'tablename' will show you that the data is located on secondary filegroup.

Moving clustered index means...

I tried to shrink it with management studio wizard.....database-->tasks-->shrink-->log file

Did'nt get any error message ...but the free space is still the same

Thank you...

But this is a production server and I cannot keep testing on it.I need to take downtime for this which needs many people's approval.I need to give the statistics...

Thanks for your posts.

Yes...we are upgrading to SP2 in couple of weeks.

We have index rebuild job running every week.If the tables are more fragmented ,performance should be same in all...