We resolved this issue with a SQL product from Red Gate. It does everything we need it to when moving objects from dev to prod.

Depending on the object you want to execute (jobs), there are many different ways to do this.

One is the manipulate the msdb..sysjob****** tables as needed to relaunch a job. We...

We had a similar issue. We ended up creating a control table to track the results. A process then can update, insert or delete rows as needed in this control table based...

I've seen similar errors in applications ad DTS packages, though not in any of our backup processes.

The general network errors I've seen has been pointed to a network bottleneck...

Do a search in your SQL help for "Transform Phase" and then read the entry "ActiveX Script Transformation Properties"

"Never give them a fish, never teach them to fish, but always...

Try this query.

select distinct o.name

from syscomments c , sysobjects o

where c.text like '%base%' and

c.id = o.id and

o.xtype = 'p'

Of course, the use of the data will decide the code you need to write. I put together some web pages to give this type of data to some of...

Let's see, this is from the hip, so to speak. Any you probably thought of this already too.

1) create a log table of object ids and object names and load...

select max(colName) from table

where colName not in ( select max(colName) from table)

The subquery gets the max value and then the main query get the next value.

Here is the code I use to solve this. I use this on the hundreds of .asp pages I have written and it works everytime. Of course, you need to...

We used Arcserve for a while.

We got around this issue by backing up the databases to a file at a specific time. Then, when we were sure that all...

We address the issue by comments in the stored procedure. Then we wrote a web application to parse the comments and display them on our intranet. We included search engines...

Hi kwbonin,

I had a similar issue. I load about 90 source files nightly. However, instead of checking the tables after their are loaded, I check for the existance of the...

I have increased both timeouts in the ADO script. Sometimes it works and sometimes it does not. However, I start putting the following code in the top of page that...

I had the same problem a few months back. I could not find anything anywhere that I could use to fix the issue.

I did not want to 'hack' the...