BTW how did you view the function code. I am trying to look it up in my other server.

Thanks for your help.

Yes we do backup msdb.

But how do I know when was this last corrupted? Which day's backup should I restore?

Or is there any easier method?

Oh. You got it.

I don't even see that function in the msdb database of my sql server instance.

What should I do to fix it?

Thanks,

Sam.

Yes we installed a commvault client which is a backup tool, after the server install.

And does my error in anyway realted to this update:

http://support.microsoft.com/kb/970315

Thanks for the quick response.

Yes I am ruuning DTA from the server box.

Server version:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright...

Any simple select statement. For example...

SELECT [ApplicationId]

,[PathId]

,[Path]

,[LoweredPath]

FROM [aspnetdb].[dbo].[aspnet_Paths]

-------------------------------------------------------------------------------------------

BTW this is...