Thanks paul

but can u describe your statement

thanks again

IN SQL 2000

1.Right click onto your server node, - an SQL Server Properties dialog will popup, In server setting

2.Enable "Allow modifications to be made directly to the system catalogs" option

Hello Sir

I just wanna know that what is cursor

is it datatype or object and how

and what is use of cursor when we have its alternate

and how...

I have done it but when I execute

alter dababase db1 set online

it takes 2-3 hours but still the query is executing and there is no end

I have a question

if any database become suspect than i set it in emergency mode and issue command

alter database db1 set emergency

alter database db1 set single_user

dbcc checkdb...

thanks

but now i want to know that how can i know that the particular backup has fail

and how to make network cluster

User should always use the diffrent drive to take backup and if want to take back up on network path then there will be these ways

1. share the network drive

2....