Kevin

This sort of string manipulation is best performed by your application rather than SQL Server. If you really need to do it, you should be able to use the...

The fact that the device type is a virtual device suggests that your database is being backed up with a third-party utility such as DPM or NetBackup. If your...

If you don't already have this property set up as part of a package configuration, or taking its value from a variable, then I don't think you can do what...

Jerry

As Steve said, you don't need to assign any permissions. As long as you specify the account as the service account during installation or using SQL Server Configuration Manager,...

A warning message? I don't think SSIS is designed to do that: it runs as a service and doesn't depend on anybody being logged on interactively. If you...

David

I think you can get that message when you have ant-virus software trying to access your database file. If you do have anti-virus software installed, please check that it...

David

Databases in Simple recovery mode do have a log file, but you can't back it up since it is automatically truncated by SQL Server on a regular basis. Therefore...

Try building in a small delay between iterations - two or three seconds, maybe. This may allow time for the transaction log to clear before the next iteration. ...

SSIS (Integration Services) and bcp are designed for this very purpose. You should use one of those.

John

OK, here's what I've just tried (Windows XP SP2, SQL Server 2008 SP1 CU4).

- In Computer Properties, add a system environment variable called Test, value Test

- xp_cmdshell 'set' Result...

I've thought about this a little more and I think what is required is a restart of SQL Server, not the whole computer. This is because the service account...

We can't really help you without table and index DDL, sample data and the query for the report.

John

Brandie

Is this the first time that setting the rate to zero has been invoked? What happens if you set it to a decimal rather than an integer, like this?

...

Gail

The first ORDER BY in the original post matches the clustered index, albeit with the unnecessary addition of a second column.

I think you're right - a sort would be necessary....

I seem to remember that when I tried using an environment variable in a package configuration, I had to restart the computer before SSIS would pick it up.

John