I believe that for monitoring SQL server remotely there is no requirement of Administrative privileges. I don’t think that an outside vendor will not restart the sql server(if he has...

use dbcc traceon (1807) with the T-sql for restore.

Using this you can restore the bkp directly from standalone server without moving any files.

Wrm Rgds

Binu John

Then what is the advantage of having Table variable compared to temporary table??

but under what circumstances that will create in memory???

Dear Remi,

But can you clear the things for me.

I read this on 'Sql server 2000 for Experienced DBAs' writern by Brian Knight.

Hi,

But this time I have made the data file size as I mb and run the query

set nocount on

declare @tmptable table

(

login char(50),

hstname char(50)

)

--select * from @tmptable

declare @i int

set @i=1

while...

Sorry Friends,

I got the T-sql from BOL,and added a new file without restarting server.

ALTER DATABASE Test

ADD FILE

(

NAME = Test1dat1,

FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\data\test_Data1.ndf',

SIZE =...

I have also a similar environment, RMS(remote management services).But we do with some third part tool that is Hp open view and defined some matrices like you mentioned and that...

Hi,

Hope you are using System Dsn.

1.At the client system, select System Dsn and click on add button.

2.Select driver as Sql server.

3.Name the Dsn and select the server.

4.if the server not...

What is the recovery model? If it is Full recovery I think by restarting the sql service that will work.Or restore from last backups.

Regds

Binu John

select name from sysusers

Regards

Binu John

Urgent help needed...

I want to know T-Sql statement that how to update a login with password and enable 'always prompt for login name and password ' option in the...

Use EM.

A.To shrink Log file

1.Right click database.goto All Tasks.Goto shrink database

2.Select box shrink files.And click on files button.

3.In the database file select the log file.

4.In the shrink action select shrink...

1.Shrink log file to required size.

2.Restrict log file growth.

Regds

Binu John

Dear Milner,

Thanks for your help,and also want to find is there any sigle step/command to tackle this kind of situation?

Rgds

Binu