Mark,

why don't you just change the Local Security Policy on the server to accept a weak password?

Once the login has been created you can change it to not enforce the...

Read this document first:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

It covers all the standard questions you should ask yourself and also special situations like replication.

Markus

Ammad,

you probably need to stop the SQL Agent before executing the ALTER DATABASE command. The command needs exclusive access to the database and is just waiting until thats possible.

In fact...

Stephen,

if the transaction never committed, you won't find anything in the transaction log either. The best way to solve these kind of issues is adding some error handling to...

Hi Colin,

I would start out with sp_who2 and sp_lock. Also the dynamic management views should deliver some information. See here for more information:

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

http://www.sqlteam.com/article/dynamic-management-views

By the way you can also...

Colin,

did you ever try to access the "Hanging" machine through a DAC connection ? Look for blocked processes.  

Markus

Brandie,

you can suspend the mirror session while you install the SP on the passive node first. Then after restarting the mirror session, when status is back to synchronised, you need...

Hi Brandie,

99.995% means a downtime of about 28 minutes a year. You might think that a clustering failover takes about 30 - 60 sec, so I'm fine, but in real life...

Jay Bee

 Select SERVERPROPERTY('MachineName')

will work unless it's a clustered server. In SQL 2005 you can find out the name of...

Not sure if this applies to your case but it's worth checking:

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

Markus

Adam,

you need to create a global temp table using ## instead of #

Markus

Hi Art,

the detaching and attaching actually only take a second. What will take some time is the copying of the file, but the exact time depends on your hardware.

As...

Hi guys,

I finally found some time and wrote the script I had initally in mind. Even though both your scripts provide valuable information none of them reports the correct...

John,

if it's just the starting of jobs you're users need, you can give them execute permissions for the sp_start_job procedure in msdb.

Markus

Richard,

first of all Taskmanager is not very reliable when showing SQL Server memory. Use Performance Monitor instead.

Second SQL Server wil not reserve RAM at startup unless you defined a minimum...