You're very welcome 🙂

Jeffery Williams (3/1/2011)

---

I am very very close now.. thank you so much for your help..

I have one more issue. Now I create an export that is 0 bytes with an...

Not that you won't receive help here...but there are dedicated SSRS forums on SSC:

http://www.sqlservercentral.com/Forums/Group416.aspx

You'll want to provide the "server\instance" name after -S.

Is your login in the sysadmin Server Role? Is it a domain login, a local Windows login or a SQL Login?

DECLARE @bcpCommand VARCHAR(8000)

SET...

SELECT ukey,

intman,

admtype,

los,

...

What are you executing in the call to xp_cmdshell...are you running something that connects back to the SQL Server, like bcp? If so, please provide the command line (with any...

Not always...it depends on who is executing it. Have a look at the "Remarks" section...

I see your concern now...and I was able to recreate the plan on my instance after looking at your plan using this code:

DECLARE @0 BIT = 1,

...

An alternative is to enable mixed mode authentication, setup a SQL Login that has permissions to run the query in your bcp command and change from using -T to supplying...

In SSIS you can use the Derived Column Data Flow Transformation in your...

Hmmm....when I run your sample DDL into my SQL 2008 R2 test DB and run your select query I see index seeks (see attached sqlplan):

SELECT child.PATH

FROM ...

Please post your DDL and DML.

For functions:

SELECT *

FROM sys.objects

WHERE type IN (N'FN', N'IF', N'TF', N'FS', N'FT') ;

/*

From http://msdn.microsoft.com/en-us/library/ms177596.aspx:

FNSQL_SCALAR_FUNCTION

FSAssembly (CLR) scalar-function

FTAssembly (CLR) table-valued function

IFSQL_INLINE_TABLE_VALUED_FUNCTION

TFSQL_TABLE_VALUED_FUNCTION

*/

USE some_database_name

GO

SELECT name,

create_date,

modify_date

FROM sys.views

SELECT name,

...