Hi sourav,

Resource databaseid is 32767 by default. You cannot change it or find it.

BOL: The ID of the Resource database is always 32767. Other...

As far as I knew expired version cannot be upgraded.

Checkout sp_who2

Hi,

Refer http://www.mssqltips.com/tip.asp?tip=1484 and http://msdn.microsoft.com/en-us/library/ms191128(SQL.90).aspx

Hi Nanda,

Take a look at replication monitor also. It will help you to monitor and troubleshoot replication. You can find lot of references on...

Hi Sourav,

Sometimes the service pack will not be applied to all the nodes. After applying check whether all the nodes are...

Hi,

Suspect database should not be detached and dont try to restart sql server also. As you had already detached the database you have very few...

Hi,

Logical design and physical design. When we have articles for reporting services architecture why cant we have for sql server.

Hi,

Are you backing up directly to another system without share or using a share. I hope you are running win2003 or win2000

If you are running using...

Hi San,

This is not a job portal. Please post your cv on monster.

Increase the value to 500 or 1000

Hi,

Check out the eventviewer it will give more info on the error. start->run->eventvwr

Thanks

Chandra Mohan N

Hi Moorthy,

Replication does not require any downtime. But generation of snapshot causes some overhead on the server. so it is recommended to...

Hi Sourav,

You have many tools with sql server like profiler, perfmon... You can utilise these tools to check out whats happening in your...

Hi,

Check out this

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

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

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

http://sql-server-performance.com/Community/forums/p/22947/130820.aspx

http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx