Hi,

Regarding Sharing single disk for all Installed Instances in a cluster. If I am not wrong we cannot do that as If we add a specific disk into a resource...

Hi,

So...we already have Transactional Replication enabled on this database and on top of that we want to restore a fresh Backup of Database.......? What is the need of that? Isn't...

Hi,

Below KB perfactly matches it and as per it there is a hot fix for it.

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

FIX: A .NET Framework 2.0-based application may require read/write permissions to a registry...

Hi,

I wish Microsoft can give it free.... 🙂 but lets come to reality its not. You can try to download 180 days trial version of it. If SSMS is part...

Hi,

Gilan is right Log files are not part of any filegroup.

A small test. If you try to add a new file in thru SSMS you will see that for Log...

Hi,

I must say did we re-register this DLL after copying it or did we tried rebooting the server. If not please do the same and check how it works.

You can...

Hi,

I would suggest you to check the complete error logs so that we can see whether this is the only message that is logged or we have couple of others...

Hi,

I think this document has explained things pretty well (diff between SP_ATTACH_DB & ALTER DATABASE). A small curx of it.

So why exactly is this important, and what difference does it...

Hi,

Here's a handy query for finding duplicates in a table. Suppose you want to find all email addresses in a table that exist more than once:

SELECT email,

COUNT(email) AS...

Hi,

One thing is sure that there is some memory crunch which is causing this problem. Now we need to identify when this occurs and why? When say Why I mean...

This is the real question :

When to decide that I have to touch MAX DOP settings?

Now normally when we saw that in SYSPROCESSES output continously we are seeing...

Hello Ajay,

First of all How many CPU SQL Server should use on your machine it depends on the Licence that you have. As you mentioned you have 2 CPU on...

Hi,

If I have heard correctly, while installing SQL Server on client machine its failing with error i.e. Unable to Start SQL Server.

If this is the case please let us know...

Hi,

Good question but I hope you understand that Programming cannot be taught. You can try downloading scripts from SQL Server Central and accordingly write your own. Below is a good...

Hi,

Open CLUSTERADMIN and select SQL Server Resource. If rest of the drives are added in this group then you should be able to see it thru SSMS. So add these...