Hi David,

One quick one. In session II of Stairway to SQL Server Indexes you mentioned that:

* Non Clustered Index Is a sorted set of entries.

I have little doubt on...

Hi,

Please go thru below post this is perfact example of restoration of Master Database in SQL 2005.

http://geekswithblogs.net/travis/archive/2005/07/27/48400.aspx

Regards

GURSETHi

Hi,

Please find below a small repro of this.

use test

go

create table hello (I int)

go

insert into hello values(1)

insert into hello values(2)

insert into hello values(3)

insert into hello values(null)

insert into hello values(5)

insert into hello...

Hi Sourav,

Please send me below logs.

1) SQL Server Error Logs

2) Application & System Event Logs (Saved in Text Delimited Format)

* Please don't save in EVT format

3)...

Hi,

First we cannot KILL a process which is in ROLLBACK state. When a process is in ROLLBACK state it has to complete its work only then it will come back...

Hi Stephen,

I sure this post will help you.

http://www.mssqltips.com/tip.asp?tip=1859

Regards

GURSETHI

Hi,

I am confused after reading your post. I am not able to make up what extactly you are trying to ask. Normally if your PC is on WAN and has...

Hi Sourav,

To be frank when ever we failover/move resource we have a entry logged in Event Viewer and ofcourse cluster logs. One thing in cluster logs times are in UTC...

Hi,

Let me put some more light on this.

A 32 Bit Environment has a limit of reading memory upto 4 GB by default. If we have more memory on the server...

Hi,

Please check this MSDN link.

http://msdn.microsoft.com/en-us/library/ms174313.aspx

also

http://support.microsoft.com/kb/822101

Hope it will help.

Regards

GURSETHI

Hi,

You can reffer below BOL for restoring system databases.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/0bc9eed6-3441-4b75-af02-2944d321daf7.htm

Regards

GURSETHI

Hi,

This is pretty much strange. I would like you to check setup files to see if it was succesfully installed (means components).

Please also let us know if there is any...

Hi Svan,

I wish there could be some method to do that but no this thing is not possible. We have to delete this subscription and then re-create it and specificy...

Hi,

You are right there can be some problem in this configuration. Please go thru this article posted on Database Journal (with examples).

Beware of Mixing Collation with SQL Server 2000 Part-I

Hi Serge,

We can very well install Different Editions/versions of SQL Server on a single machine or cluster machine. Like in our case SQL 2005 & SQL 2008. Now the thing...