forget that

I have preference for keep deleted rows in a history table.(Triger on DELETED copy the rows) could be nice for "Audit Reason" I think.

use the same query with a exec sp_msforeachdb ' ... '

For This reason

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

I Thinks use should use this :...

Take a look on SSIS Stairways. Maybe is good a way to begin if you are new to ssis 😉

nice easy question for the end of the week 🙂

Thanks for the question

Maybe if you put the exemple of the line wasn't correct, it help to find the error. ANd with correct line for compare issue.

Carefull when you import. I guess you csv is delimited with "'," and you filed like name with value " james, bla bla" caused the overlap. When you convert specific...

Maybe you could check for the option "With recompile"

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

select right('Test OutPut',charindex(':','Test:123',2)-1)

go

select right('Test OutPut',charindex(':','Test123',2)-1)

go

The second query gave you an Error because don't find ':' and get -1

Look the return value of charindex. I Think you don't have a':' for the "detail" column. If is the case charindex return 0 -1 = -1 Invalid value.

I did this operation in the past, because somebody because the SysAdmin delete sql job by error. http://msdn.microsoft.com/fr-fr/library/ms190749.aspx

But you need to disabled the Sql Agent for do this...

About Certification. Any of use transcender or tool like that for practice ?

FYI : available in Datacenter edition

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

"Last line of the page"