I'm not sure that works properly.

DECLARE @Table1 (X int, Y int, Latitude float, Longitude float)

insert into @Table1 values (1,1, 90,0) -- the north pole

insert into @Table1 values (2,2, 52,0)...

Could you start a new thread with that question in the performance forum?

Standard forum etiquette is to post a question in a new thread, with a descriptive title, so that...

I'd recommend you run a checkDB on that database asap. Make sure your backups are available and you know what your recovery options are. How long have you been getting...

Perhaps change the jobs on both principal and mirror to check the status of the DB before backing it up. So

IF (select DATABASEPROPERTYEX('AdventureWorks', 'Status')) = 'Online'

Backup database AdventureWorks to disk...

Do you know where the error's occuring? The error message should include the line number. Can you run the function im Query analyser and post the full error message, including...

select @startbase = convert(datetime, convert(char(2), datepart(d, @startdate)) + '-' +

convert(char(2), datepart(m, @startdate)) + '-' +

...

Then find the job that runs the log backups. In the properties of the job step (second tab) there's an option to log output to a file.

And his environment is a 24x7, no downtime, no data loss environment.

I wonder how much longer it's going to last..... 😀

Is upgrading to SQL 2008 an option? There are geospatial data types built in and solving your problem there would be trivial.

pseudo-code:

DECLARE @g geography;

SET @g = geography::STPointFromText('POINT(30.0045, -93.8824)', 4326);

SELECT MIN(GeographyColumn.STDistance...

That should not be possible. Running as sa is definitely not recommended. Too many security problems.

Can you please post the udf so that maybe someone can spot the root problem?

It could be worse. Like this one - developer background, now a senior DBA, depends on forum answers to do their job

Train wreck waiting to happen.

If you want some laughs,...

There's an option within the maint plans to log all output to a file. If you do that, what's the exact error that you get?

I'll help you if you can answer my questions please. Right now I don't know what you're trying to do or what errors you're getting.

Why are you trying to restore...

I started posting on this forum because I wanted to improve my own SQL skills, and trying to figure out other people's problems seemed like a good way to do...

Anything in the SQL error log from around the same time?