Create and agent job and have the stored procedure start the job.

Okay - I see what I was missing the first time. Thanks.

Restore from the latest good backup and apply transaction log backups up to current point in time.

Other than that - I think you are going to lose data.

Sorry, but that won't work either - you need the following:

SELECT 1 WHERE '111' NOT LIKE '%[0-9]%'

Schadenfreude-Mei (1/7/2010)

---

Thanks for your response. Unfortunately that was the first thing I tried. It was a problem in the past with 2005 servers and that was the MS suggested fix.

However...

It's not a question of whether you can or can't - it is a question of whether you must or...

That is good to hear - thanks for the feedback.

Before you go off and start creating multiple files - read this:

http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx

Lynn Pettis (1/6/2010)

---

I don't apply those unless I have a problem that would be corrected by a CU. Those don't go through as stringent testing as the service packs...

Instead of trying to roll your own - and ending up with all sorts of problems - why don't you just use IDENTITY instead?

I don't think your error has anything to do with whether or not your data has commas in it. The error is very clear - you are attempting to...

Just finished a quick test - converting to a scalar UDF took the following on my system:

SQL Server Execution Times:

CPU time = 984 ms, elapsed time...

Lynn, would schema binding that function make any difference to the performance? Could it be modified to a scalar UDF and would that make it perform any differently?

Just questions...

donne4real (1/6/2010)

---

I think I should have added more information. I have 2 tables. It loops through the table to see if a filename exists in both. And if it does,...

And don't forget the cumulative updates - I think CU4 is the latest. 😉