Thanks for your reply. Here is my problem. Having over 1200 stored procedures and knowing that the database that I'm now support has been around for quite some...

Thanks Guys for your response. In my efforts to find a solution I discovered a few things. 1) I found that I have enough room on the same box...

Yes I would agree but not in this case. The process I'm referring to deals with a large volume of data.

Thanks for your reply

Kurt

DBA

RHWI, Inc

Poughkeepsie, NY

I've had to deal with very long running updates and processor intensive stored procedures that has been able to take my dual quad core w/ 8gb to it's knees. ...

HI Gary... yeah... I have a number of development databases that are quite large. All of a sudden one of the backups stopped working (of course the largest). ...

This Sproc comes from Andrew Zanevsky. It does what I need it to do.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

-- sp_grep v1.0 03/16/1995, v1.1 10/26/1995

-- Author: Andrew...

Aaron...

This works great but it has issues. If there were more than 1 email address in the text then it would only find the first one. ...

Thanks Aaron... I'll give it a try..

Kurt

I found a script called sp_grep that does exactly that. I'm sure it is much like Lowell's script he posted.

Kurt

Vinu; If you read the error message you are trying to create a file that already exists, which is preventing the backup to run.

I would suggest recreating...

Joe, read my post on this subject. I agree... Julian dates work much easier than Gregorian dates.

Kurt

DBA

RHWI

Poughkeepsie, NY

Over the years I've written several variations of work day calculator functions in a variety of different languages. The earliest was written in FORTRAN. The latest was a...

When I had this issue I went into EM, right mouse clicked on the database then left mouse clicked on Detach Database... I then forced the connection off by selecting...

I had an issue where I wanted to backup several databases across my local network to a file server (read: lots-o-room). In order for me to do this I...

One last followup... I went forward and modified my script to toggle the delete option on my temp jobs and it worked fine, without any contention or deadlocking. ...