carsten.jorgensen (6/12/2011)

---

You are asking about the owner of A.SomeTable and you sent a SQL for retrieval of that information.

The result of that SQL is 0 rows.

And the reason is...

You're very welcome, thanks for the feedback...and welcome to the site 🙂

For files larger than 2GB you'll be forced to use the FILESTREAM data type. Luckily full-text...

I just want to clarify one other point for you Steve: dbo is not a Database Role and...

Jeff Moden (6/10/2011)

---

opc.three (6/10/2011)

---

Maybe I am just being closed-minded here, but I would not choose to kick off any file manipulation tasks directly from T-SQL. I understand the need however...

PS I meant to attach my two proof-of-concept scripts. Maybe if you try something, or figure something out you can alter these scripts and shoot them back to me so...

carsten.jorgensen (6/10/2011)

---

Thank you for a very detailed walk through of all the steps.

The set-up is exactly as you describe it.

And I totally agree, that the ownership chain breaks when...

You're inside a ForEach Loop correct?

You can set a condition on one of your constraints based on the expression below to prevent further execution where @file_name is the variable mapped...

It looks like we are running the same version...however I do not receive the error mentioned in your OP.

Which version of PowerShell are you running?

"Applies to PowerShell 2.0"

http://technet.microsoft.com/en-us/library/dd315258.aspx

You can check by running this in a PowerShell session like this:

PS C:\> $Host.Version

Major Minor Build Revision

-----...

Here is another hint:

http://www.sqlservercentral.com/Forums/Topic1123031-149-1.aspx

For additional help please post what you have tried so far.

Sorry to keep pinging...just REALLY interested in whether you found a root cause :Whistling:

:hehe: I only picked up...

Maybe I am just being closed-minded here, but I would not choose to kick off any file manipulation tasks directly from T-SQL. I understand the need however so for discussion...

PS he script is for PowerShell 2.0. It may work in PowerShell 1.0 but no promises.