PS @@VERSION = Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86) Aug 5 2008 12:31:12 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows...

Steve Hindle-535638 (6/13/2011)

---

Apologies - my first post should have said db_owner (fixed database role) and not dbo (user). If a user DOMAIN\steve is a member of the db_owner database role...

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...