Only if a hint will help the query, and only if its one...

Please post a new thread with your question and don't hijack a completely unrelated...

It's not an error. In transactional replication the snapshot's...

Yup, because a proc doesn't have a defined output. It's possible to have a procedure that returns various different resultsets (or none at all) depending on parameters passed.

Um... Did anyone notice that this thread is 4 and a half years old, and was answered accurately 10 days after it was posted?

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?