Has any body tried the sql up program by incepto

using replication i had a rollover to backup site the other day only to find out that all the text fields were empty seems that if text fields are updated...

there is an extended stored procedure that is available on this sight that will let you update text files

I just had an issue with blobs and replication. If writetext is used to update the blob then replication will not work and will not copy the blob. And...

I would get an execution plan on this and make sure that all the fields are indexed properly

not in will cause alot of the time issues.

Use a left outer join on an indexed field will work better.

you cant give truncate table rights but you can delete from the table and then reset the identity column in a sp. Which will accomplish the same thing, except for...

both sides of linked servers have security.

In this situation i would create a special user to use that has execute rights to the sp.

if this case i would use dts send the data over. I think the maintenance of the dts packet, if you change servers or want it to be on...

if you are want it done every time put it in the model database. I have used that for many defaults

I have had that problem when my database recovery mode gets set to simple from full.

you can also use the execute command to create a global cursor that you can then run locally.

You can see a simialar result with the backup command. The time it takes in a maintenance plan is much less than the time it takes in QA. ...

My vote is to put them on another server, where they can be backed up. blob fields can and do affect performance if the table is used alot, Also...

I have created a cursor looking for each database on each server. This then allows you to do somethings like check to see if the backup exists, whether the...