okbangas (3/12/2012)

---

Basit Farooq (3/12/2012)

---

okbangas (3/12/2012)

---

As mentioned in my article our backup drive that contains the file backup of the system databases got corrupted as well. So this is not option...

okbangas (3/12/2012)

---

I really dislike to rebuild system databases, thus I will have a file backup of the system databases (database and log). In the case of such a scenario that...

Hi Dani,

I think this is not possible because drive...

Thanks for liking the article. Yes we did meet client SLA.

JManuelN (3/12/2012)

---

Hi Basit,

Great article: quick and effective. Just a quick question, since in SQL Server 2008 the resource database is stored in Binn directory, did the disaster affect this directory?...

mike-858099 (2/21/2012)

---

Would this work on a SQL 2000 instance? I have a dozen or so that I need to gain access to in order to sunset them later this...

Documented procedure worked for me as I recovered my access couple of times using this procedure.

No it doesn't but you can write the code your self by using sp_who2 and DMV's ('sys.dm_os_wait_stats').

Hi,

You can implement locks in SQL Server using locking hints read below:

Hints

There are times when you need to override SQL Server's locking scheme and force a particular range of locks...

Hi Dati,

I don't understand your question. Can...

Hi Dati,

I don't understand your question. Can...

Here is the other flavor of the query to get quick row counts:

select OBJECT_NAME(object_id) as Table

,rows as RowCount from sys.partitions

where...

Hi, Unfortunately you are not able to do this in SQL Server.