Bryan i think you can simply add a step to your job that would do the notification, and then change the On Failure to call that notification step instead, right?

you cannot.

without an order by, there is no first and last.

SELECT TOP 5 * FROM SOMETABLE will give...

i see there is a connect item for two other ODBC drivers with the same issue here....

http://connect.microsoft.com/SQLServer/feedback/details/126972/mssql2005-returned-data-that-does-not-match-expected-data-length-for-column

one poster say if he checks this in the settings he gets the error...which...

it's a nice tool, migrates schema and data, but leaves you with the list of items that will need to be converted manually...packages, procedures and functions.

glad to hear you are...

IF is typically used for logic flow, where CASE is used to return data values;

your example is bending an IF into a situation similar to a CASE, but an...

,

yes, but that 10 second pause in the...

well, i would consider creating a view that pulls all 18 tables together...

then the proc can select directly from the view and contine from there.

depedning on what you are doing...

how many values are in dbo.tbl_CDE_MultiMonth, which is where you were gettting the tablenames from?

my issue with it is that no matter how long you wait between the clicks to "add 30 seconds", 30 seconds + 30 seconds = 60 seconds....

if you watch the first video, it does a quick demo showing how the schema is migrated, and then how data requires a seperate click/call, so you'll get your...

duplicate thread:

follow it all here where the detailed answers exist:

http://www.sqlservercentral.com/Forums/Topic1205779-146-1.aspx

duplicate thread:

follow it all here where the detailed answers exist:

http://www.sqlservercentral.com/Forums/Topic1205779-146-1.aspx

looks like there is a series of videos here...

the code you posted points to two different folders; 'C:\SQLServerFiles\serviceMasterKey'

and 'C:\SQLServerFiles\TDE\serviceMasterKey'

could that have been the issue? the extra folder?

something like this?

select [Years] = datediff(year,0,ET-ST)-1,

[Months] =...