You may want to alter your user database settings and not master's.

The error message says that there is a DDL trigger "Procedure ddlDatabaseTriggerLog" build for your user database that records...

You may want to read this article for db capacity planning:

http://www.sqlservercentral.com/columnists/aBanerjee/analyzingdiskcapacityforsqlserver.asp

However, tempdb needs special attention; you could find useful info here:

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

This is the old 17883 error under sql 7, 2000, and 2005. Please read here some useful explanations:

How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888

http://www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx

The fix...

You can see the ARITHABORT setting for your database by right clicking over db name -> script db; probably it is set to off. Check with BOL if, by changing the...

It's not a sql bug, it relates to the os (I am aware what the article says). However, the patch I was talking about was released between win sp1 and...

I've got this issue on a various sql 2k/2k5 installations (not all on the same environment). Please read http://support.microsoft.com/kb/810885 

High-end disk subsystems may experience error 17883

The error number and message...

Your workstation OS does not allow dbengine install.

You may disable the sorting property for your combo box; this way your recordset may stay sorted as in Peter's query above.

Fisrt step:

CREATE

PROCEDURE dbo.spOutputTest

@stuff

int OUTPUT

AS

begin

set

@stuff = 5

end

Second:

I would add: exclude your online database files from your antivirus (Norton is doing this sometimes); define min and max (sql) server memory that way your os would get enough...

Check that the Remote query timeout on the slower server has the same value with the one in the server that your query performs better (right clisk on instance name ->...

Ask your manager to prioritise your work and make politely sure you get double the time needed for each task. Don't pay much attention to your co-workers' skills level and...

It is strange indeed; can you run/save some profiler traces to see what happends in the 15 hours? Are there waits? Can you monitor the wait type?

Please check this http://support.microsoft.com/default.aspx/kb/834846

And yes, the performance improvement is visible.

There is not a straight relation between ldf files and tempdb; for keeping your log files under control you need at least to keep your user database in full recovery...