Okay, after I cleaned the soda out of my nose, I had to ask - was this intentional (the only reason I think it was is that...

BOL search for sysjobhistory will tell you this as well:

http://msdn.microsoft.com/en-us/library/ms174997.aspx

in your script you had

listed as a limitation - have you progressed with this at all?

Bravo - Very good article. It is bookmarked and printed.

As long as the DB is in full recovery mode, the log file will stay that size (and more) until a full backup has completed...

You could also change the recovery...

declare

@cmd nvarchar(2000),

@StoreProcedureName varchar(30),

@theDDL varchar(10),

@ParameterName varchar(30),

@tablename varchar(50),

@therows varchar(160),

@thesource varchar(30),

@filename varchar(30)

set @StoreProcedureName = 'spExecute_ADODB_SQL '

set @theDDL = '@DDL'

set @ParameterName = '''Create Table '

set @tablename = CONVERT(VARCHAR(8),GetDate(),112)

set @therows = '(dbid Text, id...

You may need to create the SQL Statement and the execute it with EXEC sp_executesql

My bad - I guess I did not read it all - however, the same idea should work:

CREATE PROCEDURE spExecute_ADODB_SQL

@DDL VARCHAR(2000),

@DataSource VARCHAR(100),

@Worksheet VARCHAR(100)=NULL,

@ConnectionString VARCHAR(255)

...

this is untested but:

CREATE PROCEDURE spExecute_ADODB_SQL

@DDL VARCHAR(2000),

@DataSource VARCHAR(100),

@Worksheet VARCHAR(100)=NULL,

@ConnectionString VARCHAR(255)

= 'Provider=Microsoft.Jet.OLEDB.4.0;

Data Source=%DataSource;

Extended Properties=Excel 8.0'

AS

DECLARE

@objExcel INT,

...

@filename varchar(100)

...

set @filename...

Thanks! I thought that was the case - that was how...

another option, however I think I read that coalese is the preferred way...Can anyone confirm that?

SELECT RTRIM(LTRIM(ISNULL(Last_Name, '') + ' ' + ISNULL(FIRST_Name, '') + ' ' + ISNULL(Middle_Name,...

I have not actually done it, but it sounds to me that this may be more a job for Replication...?

are you asking how to join two tables? Lookup Join in BOL

I had tried that, and when I do, I...

individual Table restores are not possible yet. An option is to restore the DB to a new name or server, and then copy the table(s) needed back to the...