What works? Common courtesy is to post the solution that worked for you so others that encounter the same issue and find this thread...

Basically what it means is that since the query in...

Unfortunately, no.

Can you help us understand the setup a...

Sounds like you might be calling the SQL 2005 version of bcp. What version of SQL is your database on?

What is the log_reuse_wait_desc in sys.databases?

I may be making it too simple and missing some nuance of what you are after, but I think you just want a LEFT JOIN.

SELECT t1.Field1,

...

This?

http://www.sqlservercentral.com/Forums/FindPost1398567.aspx

The stored procedure will execute indefinitely, but every 4 seconds it will deliver a...

I would recommend against running a job every 4 seconds. Instead it would be better for you to make a stored procedure and use the WAITFOR DELAY command inside a...

I have used the SSL feature in Database Mail with success. Have you tried it out?

With limited insight into the overall process this may sound like I am asking a silly question so forgive me please, but why not push all the necessary data changes...

Another option:

IF OBJECT_ID(N'Dev1_PHIL_App.dbo.extgen_ki_TestLoop1') IS NOT NULL

From a T-SQL perspective WAITFOR DELAY will not actively use any server resources other than the overhead of having it keep an open thread using a little memory for the...

In this case SSIS is a good choice regardless of the complexity of the tranformation because the source and destination databases are going to be on different instances.

If you want...

It looks like you are fully-qulaifying the call to the proc, but not the existence check. In your sample code try replacing this:

IF OBJECT_ID(N'dbo.extgen_ki_TestLoop1') IS NOT NULL

with this:

if exists (select...