Just had a very similar issue this morning with 2008 Ent on Win2008Ent..

My problem was that the SQLServer service account did not have permissions on the file in the new...

Publishing an article gives kudos to the author, and can be used during a job interview or such to spruik oneself. Given the size – and prestige – that...

Lynn Pettis (8/11/2009)

... Just because a topic has already been covered in an article is no reason to deny someone else the opportunity to also write about the same topic....

I have formerly worked as an articles editor at http://www.strangehorizons.com and so should offer my comment for this thread. Strange Horizons is a volunteer run online publication that published...

Steve,

A server version that doesn't appear to be on the list:

Microsoft SQL Server 2005 - 9.00.3310.00 (Intel X86)

Dec 19 2008 00:58:18

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows...

The sys.traces view has a "max_files" item with a value of 5.

Is it possible for this value to be changed to allow more/less trace files?

S.

For what it's worth, I just retested this and got 1 proc with...

Certs are really an "eye of the beholder" thing. Some people will swear by them, and others will consider them nothing more than a money making gimmick.

Recently my company...

I should point something out that has caused me grief.

Doing a test run on my desktop worked like a charm, but when it came time to run it on our...

Mike C - sounds like you have a lot more scope to work with than I do, but then sounds like you task is considerably larger than mine. 

There's a raft of reasons why the process tries to insert dodgy data.  Not to bore your socks off, but I'll try and cover them briefly and without justice:

We have...

Yes, all true.  Dodgy data is dodgy data, and it would be brilliant if SQL Server 2008 had a "SET DODGY_DATA OFF" switch.

However, you can only cleanse bad stuff you...

Ah, the good ol' cursor debate.

So, for all those Cursor Daleks I have a problem.  We have an existing loop-based process to copy rows of data from one system to...

The DBA died

Server performance increased

What was he doing?

S.

Neat - I've not seen a select that way before.  Closest I've come is something along the lines of "SELECT dbo.fn(...) FROM <table>"

Only change I'd make is initialize @strReturn first,...