Hi Thank you your reply

How can we check disk statics & other

we really appreciate

Thanks

HI Roshan,

Thank you for ur reply,

Hi Steve,

You have someone connected to the database, perhaps even you. You need to remove everyone from the database before you can restore.

I am new to ADMIN part how can...

Hi steve/sp,

Thanks for your reply

i had put it into singleuser mode using alter db

after then i had restore with tape drive but giving this error

"Device error or device off-line"

Restore...

Hi

it is possible using restore option in SQL SERVER 2000 only .......

Yes you are correct we can diable the primaykey's related foregine keys also disable

so that is the reason how can i disable only foregine keys in a table

give...

can u give syntax of this deleting with cascade

all referecing keys

Hi

I had created one job.

It will execute succesfully

Now i want to created Message for that job

Incase that job will be failes send Message that perticular clinet or user...

Hi

I had created one job. Know i want to created Meassages to that jobfail or success

How can created Message for a specific job

Thx

Thank u

what is hint ?

yes i am using sql server 2000 only

Hi Friend,

Thank u for ur reply

In Enterprise manger it will working

but in Query Analyser it is not working

can u give some good suggestions plz

Thanku:hehe:

Hi Friends,

Can u anybody explain me Exactly what is Hotfixes what is purpose of that one

There is any use of hotfixes

Hi Friends,

Sergiy

Jeff Moden

Thank u for your suggestions.

I am new in ms sql server plz help

at least i dont know how to count no of colums in a table can...

what is the command to truncate the Transaction log file or any another procedure is there plz tel me

Thx

shiv