Can you logon to that server either at the console or remote desktop and run that very same command? If not then you could specify the "/Q" option on...

No. And even if there was, it isn't licensed that way.. Sorry.

CEWII

Yes, there is, it is on the same disk (if I remember correctly) as the x86 and Itanium version. I don't believe there is any licensing differences between x86...

Are you sure you want to use a local GSM gateway? If not, there are providers like ClickATell who provide several different interfaces. I like them and have...

Did you look at the job step history to see if it showed any errors?

My first thought was permissions issue. Doe the user that SQL server runs under have...

DECLARE @varname varchar(255)

SELECT @varname = 'DBCC SHRINKFILE( ' + @FileNameWeGotSomewhereElse + ' ) '

EXEC ( @varname )

Comes to mind..

CEWII

I would think that could work.

If you go down that path sit down and desing out your replication before you start trying to implement it though. I...

You are very welcome..

CEWII

I have to admit, I don't know that without doing some research..

CEWII

I don't know if I agree with the source control and versioning aspect..

All of our packages are stored in TFS or VSS. Most of them capture the VersionBuild property...

If it is added to SQL as a SAFE SQLCLR then it won't be able to, but if it is EXTERNAL_ACCESS or UNSAFE then it can.

CEWII

When I wrote my packages the default configuration information was development servers. All packages are stored in a version control system, VSS or TFS, or maybe some other one...

I agree, I got a big grin on my face..

I too am wondering what a SSIS Basic Dump is..

CEWII

Is the process dropping the data into the same table for all sheets? Is that table empty at the beginning of the process? Is there an index on...

Keep in mind that even though SQL may have access to more memory it may not use it. The standard edition can access that much memory given AWE. ...