it might not be dts.dll, it could be a dependancy that it happens to use.

i went to my server and my sql 2005 express instance on my dev machine, but...

error loading DLL is a typical .NET error. it's pretty much one of 3 things:

1. if you are running this on the server, the DLL is not in the folder,...

just guessing at this point without more information as to what the step was actually doing, but...

could it be the login that is being used has had it's password changed?

or...

you can only do that with dynamic sql.

dynamic sql has some advantages, but you loose the speed advantage of compiled execution plans.

here's the example i always use:

--for users who are...

i can think of two important issues right now, aside from all the others raised.... how could you do a partial recovery? supposed you need to restore a backup from...

oops don't crosspost. they handy recent posts option allows everyone to monitor all the forums, no need to place the same question in multiple places.

follow the posts here:

http://www.sqlservercentral.com/Forums/Topic408910-338-1.aspx

I don't know if this will help, but the big_int data type is 8 bytes in size, si it should be bign enough to hold the value; you probably already...

if you could post the DDL for the table, and change the sample records to insert statements, we could help better; there's just no way to sort thru that copy...

in this case, you need to join the main table on itself.

in order to do that, you need to use at least one alias; here's an example based on your...

i don't envy you on the backup retore side of your job, but at the same time i do envy the extra large db features;

I'd love the opportunity to learn...

Bad...

Steve Jones - Editor (10/8/2007)

---

I'd use something like Lowell has to generate a script. Be sure it's hitting the tables that you really need. Last thing you want to do...

you could loop thru syscolumns and find all the varchars and such, and build a sql statement to run:

select 'UPDATE ' + object_name(id) + ' SET ' + name +...

depends on what you mean by empty...chances are , it already is null, but it depends on the data.

does empty mean an empty string?

SELECT * from sometable WHERE somecol=''

in...

you are correct, simply run the installation, but there is a caveat: Standard and Enterprise versions can only be installed on Server Version of operating systems...Win 2000 Server, Windows 2003.

If...