stop the sql server service and restart it.

stop the sq

i dont think an index can be indexed. When you query a table having index and the where clause contains a column on which index is built, the index is...

run this command

alter database mydb set multi_user

Edit - This would put the database in single user mode not the server.

Also, this is a dupicate post. Please post your...

shanila_minnu (8/21/2009)

---

how can we restore master datbase apart from command prompt...i tried using commang prompt by typing sqlservr -c -m but it is not working...is there any other method to...

groads2 (7/1/2008)

---

I created a new table in a data base. I then setup transactional replication. I created a snapshot and synchronized the subscriber. The new table did...

If there is no primary key on the...

I'd used pessimistic and optimistic locks in the past in visual basic 6.0.

In pessimistic lock, a particular user wont...

Build 9.00.3325 is the Cumulative update 13 for SP2 and yes, installing SP3 will have all cumulative updates in...

Can you recheck with the ppl who told you to install that patch?

http://www.sqlservercentral.com/articles/Administration/2960/

gives all patches/hotfixes for 2005 including their KB links.

It's safe to reboot the server after applying a...

Tara (8/20/2009)

---

This moight look simple, i am not getting the result i am looking for.

I want to select database names that end with _CA or _NY and so on, i...

espanolanthony (8/20/2009)

---

But pradeep i do not find the particular hotfix. or can you please send me the link where i will find this HotFix.

The hot fix is 41609.

I would...

Mani Singh (8/20/2009)

---

you Just take care to see that your logs are not heafty in full recovery mode. (Check bulk-logged as an option.. but it should be your call, if...

For safety, take backup of your system and user databases before applying the patch.

Also resource database, just in case if you need to revert back.

download the patch from MS site and then run the executable.