It appears that db_cursor is already opened with more than 1 output column names before executing query provided.

You will need to close db_cursor just before query block that you...

You need to set "Copy default value specification" to TRUE

This parameter is FALSE by default.

In 2005 also, C: drive will hold some binary files

Right Click on "Data Transformation Services", Click on "Open Package" and select .dts file.

Integration service is not a cluster aware service. Hence, it will show you physical server name and that is correct.

Yes, you can.

To my knowledge, Microsoft Licencing policy encourages this strongly.

use "move" option in restore command to do this.

this error came after a year from date of installation. when service was already disabled.

Carla, you are right. there is no reference in BOL.

Its just a way of writing query that does not return error but does return data.

ezlikesundaymorning (5/14/2008)

---

OK, just plain and simple, I am going to give my 2 cents worth here. This question is pure BS. I mean has anyone here ever seen a query...

Thanks so much Anirban!!!

I doubt.

(Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine")

(Object)

(DatabaseID)POM(/DatabaseID)

(/Object)

(File)C:\PO.abf(/File)

(/Backup)

Above query will help you in doing it. You need to replace ( with Angular Bracket and ) with closing Angular Bracket

P.S. I could not write proper query as...

You have only option to restore latest available backup of Production DB.

Hi Oberion

I tried all possible way to generate error that you are getting but could not do so untill I changed my data type.

I even tried setting "convert...