What browser are you using? I have viewed the article in IE 7, Firefox...

It does the restore (4+hours). That's the only way to do a differential restore is to base it on a Full that was run without Recovery.

If you need to...

I just want to mention that I agree with MackamMagic, that you need to be very careful when doing something like this in a trigger, in fact I recommend against...

I think you basically have the idea. As Lian said, make sure you know what Service Packs and Patches have been applied to your SQL Server, both OS and...

Sagar,

I'm not sure what you are asking. Do you want to know when an insert or update in your SSIS package causes a data integrity error and be able...

Drew,

Here is a query I use to get this data in a .NET app:

[font="Courier New"]SELECT

     COLUMN_NAME AS Name,

     COLUMN_TEXT AS Description,

     DATA_TYPE AS TYPE,

     LENGTH AS...

I don't think that there is a specific Best Practices document on this because so much of it depends on what the stored procedure is intended to do.

Things I would...

By all means attach the file. With that we may be able to determine the issue. If you could attach your SSIS package as well it would help....

As usual G² is right. Split into 3 cases and you have a nice neat return of 3 columns.

You can used the Derived Column Transform with nested IF conditionals something like this:

DETAIL == "Primary" ? 2 : DETAIL == "Secondary" ? 1 : DETAIL == "Territory" ? 0.5...

In your case your script should do this:

1. Sunday after the full backup a Full Restore with Recovery

2. Monday - Saturday

1. ...

You cannot just restore from differential backup. You need to do a full restore with norecovery first then restore the differential with recovery.

The only ways I can find that a user can update a column when Update on that column has been explicitly denied, is if they have execute rights on a...

In the Flat File Source Editor you have areas you can select on the left: Connection Manager, Columns, Error Output. Select Error Output and then in the error column...

I don't think, based on BOL, that xp_cmdshell will ever return an @@ERROR code. If the command being executed by xp_cmdshell fails then the return value of xp_cmdshell will...