Via the import/export wizard I can readily import the Excel file. I copied the connection string from the generated SSIS file and tried that in my query window and I...

All of the data in the database was migrated from another system. After migration of the data all of the indexes were re-created and all of the statistics updated. We...

I resolved this issue. I can get the seed and increment values from the sys.identity_columns with the select:

select seed_value, increment_value

from sys.identity_columns

where object_name(object_id) like 'TT_' + <table type name> + '%'

Initially I did not grasp how to work your solution into my scenario, but after a bit of trial and error I was able to use to your suggestions to...

I have not tried and I am not familiar with the xsi:nil approach that you noted. Any recommendations where I can find info on implementing this approach?

Unfortunately I can not cut and paste the error, but essentially the error is:

Msg 6926, Level 16, State 1, Procedure..... Line ..

XML Validation: Invalid simple type:...

Thank-you. You are are correct. I had declared variable of type table and referenced the XML collection in the table. Apparently I did not remove the table and it persisted...

Thank-you for the reply; no I have not tried nodes.

However, I was able to figure out the syntax I needed to get the facility information, and the desired feature. One...

I resolved the issue. I thought I had tried this numerous times and failed, but apparently not. Before the $dbObject.Create() statement, I added:

$dbObject.Logfiles.Add($dbLogFile)

🙂

Yes that is a typo. Thank you for pointing it out.

Does anyone have an example of the syntax for the node() type in dynamic SQL? I have tried numerous variations of the syntax and in each case execution fails.

The Function solution does work; thank you. However, the stored procedure approach, when implemented correctly, also will return the correct status. I realized that I had the CLR procedure defined...

Thankyou for the suggestion. I have only written CLR procedures in the past. I was of the impression that a CLR function would not allow file system I/O which is...

I did not post the resolution because it was simply my blunder. I had query sessions opened with 3 different servers comparing data. When I compared the call from my...

Please ignore this post; I resolved the issue