great. I gave error in begin try block and catched it in catch block. It made it fail. Thanks

In My Log table, the ErrorProcedure is not being captured when there...

I am getting the error in SQL 2008 with service pack 3

Thanks all for the query. It is working.

Yes. Exchange properties are not known to me too. Display name should display in mail.

Ok. only SQL 2008 in Windows Server 2012. Thanks everyone.

Perry, should i take it as Yes then.

🙂

thanks. Then the conclusion is ....

SQL 2000 on Windows 2012 - No

SQL 2005 on Windows 2012 - No (from the given link, it is supported till windows 2008)

SQL 2008 on...

Link is specific for 2008. I have 2000, 2005 flavors too. Are they supported in 2012 server?

We use,

1. SQL 2000, DTS

2. SQL 2005, DTS

3. SQL 2008, SSIS, SSRS

Thanks for the query. It was helpful.

josh

percent fragmentation is got from dmv

other columns are got from sysindexes, filegroups

Only To get percent detail i need to go to physical stats dmv. I need result which has...

Lowell,

to make things clear, deletion on local table .. joins happen on remote tables (linked server tables)

delete from table where .. join linkedserver.db..table on ...

...

Thanks Lowell. I followed your steps. Will have to wait and see if there is an issue.

Thanks

Yes. That thought stuck me too. treid. It Wroks like charm.

🙂

Yes, have gone through the links before. i dont like to tweak registry. somewhere I read that when it is .xls, excel tries to read it xml and hence it...

Export to .xls is possible. Its working.

The file you are trying to open, YYY.xls is in a different format than specified by the file extension....

Above error is common when...