Hmmmm,

I must admit you're right.

The information from sys.dm_db_index_operational_stats seems pretty useless and because it's a dynamic view, interpreting the results after a restart is even more of a...

sys.dm_db_index_operational_stats contains a column "leaf_allocation_count "

which according to BOL means "Cumulative count of leaf-level page allocations in the index or heap. For an index, a page allocation corresponds to a...

When using mirroring your servers will always have different names. With synchronous or Safe mirroring you can configure auto-failover at the client by defining an alternative server in the connection...

Neil,

when you run SELECT @@Servername(), does it return your servers name or NULL? My guess would be NULL.

Sometimes it happens that the entry for the local server in sysservers...

GilaMonster (12/31/2007)

---

It requires updating the system tables.

Modifying the system tables is not a good idea. It is a very bad practice that is recommended against by most experts. It's...

Sorry I can't open Ed's procedure at the moment but this is a script I use:

SELECT Rolename,

[Objectname],

...

As Jeff already wrote there are loads of articles around and with a little help from google you should be able to find something. Anyway here's an article I found...

SQL Express does not include SQL Agent. Are you sure the agent you see is from the Express instance? Any how the easiest way to schedule regular backups is using...

Animal Magic (12/21/2007)

---

It is taken from the local security policy, which by default will be taken from the settings on the DC. You dont actually set these values within...

You need to create a new cluster group first with it's own drive letter(s).

After installing the new instance make sure to limit the max memory settings for both instances...

Noman Salim (12/14/2007)

---

Karthik (12/14/2007)

---

[font="Verdana"]Right click on the database in SSMS. Go to Tasks->Generate Scripts.

Go with the defaults in the wizard till you come to the page to select object types....

If you have SQL Server, Books online is most likely installed with it.You will fnd it under "Documentation and tutorials".

There's also the online version which you can find here:

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

Look in Books On-line under attach and /or backup. You find the code and examples there.

Yes, you can do this. Two possible ways

Option 1. Create a windows group, add the users to the windows group, create a login for the windows group in sql server,...

This should do the job:

DECLARE @login nvarchar(128), @isql nvarchar(2000)

DECLARE c1 CURSOR FOR

SELECT name from syslogins where name <>'sa'

OPEN c1

FETCH NEXT FROM c1

INTO @login

WHILE @@FETCH_STATUS <> -1

BEGIN

...