What about something like:

'..\scurra\'+ Convert(varchar(8),Getdate())+ '\' + `PDF_ID`+'.PDF' AS ImageLocation

Of course, this is off the top of my head, and you would want to cnvert or cast the date for...

LMAO....

NO, of course not. Excel is also good for writing letters and text documents.....

Do you realize that sp_spaceused gets the rows from sysindexes?

If someone needed the sizes and such, I could see them using it, but it's a lot of unneccessary overhead if...

If they work as you say, you'll make me a VERY happy person as well. What I have to use is pretty ugly. A function makes it even better. I'll...

That is true, and again you are correct. I just felt that it was worth mentioning. Its an indicator of whether the rows is accurate or not. A proc which...

I've seen this situation in high transaction databases where the indexes were insufficient, and statistics went out of date quickly (due to the high amount of inserts/deletes), and we had...

I build all my linked servers using scripts but have never scripted them OUT, I am interested in knowing the answer to this one as well. I get tired of...

I've had basically the same experience as jayharper, and agree with him. In my case though, the processes were IO bound, and working with the filegroups of my server produced...

You got my attention with that one Antares686. Whats broken? Is there a workaround? What are the symptoms of the "brokeness"?

I got a buddy talking about upgrading his mdac on...

Antares686, your correct in that its not always accurate. However, (gotta hate that however) that's where rowmodcntr comes in. This value shows the changes between updates of statistics and re-indexing...

I simply assumed multiple channels, good catch Antares686, and excellent point.

I have run into issues in the past using Option (keepfixed plan). Flaky things like inconsistent recordset returns and such. It could possibly have been that I was attempting to...

A couple years back, I ran into a wide variety of problems with 2.5 and compiling and distributing a VB app. Changing over to 2.6 corrected my issues, and I...

I've been searching for a way to do that since the release of 7.0

I had given it up as a lost cause, so I am EXTREMELY interested in the responses...

I've seen that as well, and simply didn't think of it........

excellent suggestion lhughes92, and could very well be the issue.