If someone is not doing the backups manually, there is a job to do them. If it's from a maintenance plan, it should have a name for a job that...

So I'm confused. Where is the data stored and where is it being moved to? Where does the conversion need to take place?

Just a quick check, as you are checking on issues, are you sure you are checking tempdb? Typically tempdb isn't being backed up, and operates in Simple mode. Is that...

Happy Birthday, Grant, from SQLServerCentral!

Use this:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

That's a basic, standard one for .NET connections with a user/pwd. If you can use trusted connection, that's great, but this should work. The DSN...

Let us know if it helps. I'm sure Grant would love feedback, especially as he prepares to update it for the next version of SQL Server.

the MERGE command suggested by GSquared works well.

However slowness depends on how you do things. If you have a way to just pull across the changes from your source system,...

Voted and added this comment

"I like the idea of somehow adding details about a change. This would be great for an audit log. If there were a parameter per...

I like my iPhone, and I have to say that after almost a year, the typing works pretty good on the virtual keyboard. I don't miss the real one at...

Not sure how the monetary rewards would change things, but as Gus mentioned, it would introduce issues.

I like the idea of somehow mining knowledge and putting it together in new...

There's no best practice here. If the truncate works, and it doesn't impact your system, then that is simpler to me. However this might reset things or cause issues, so...

Do you have an error?

I would suggest you grab a template from ConnectionStrings.com, as noted above, and use that.

Whoops, the article is here: http://www.computerworld.com/s/article/9160118/Tap_the_wisdom_of_employees_and_boost_the_bottom_line_

GSquared, I like the idea of the parameter. That would be very handy to know during the creation of modification of some DDL statement. That could then be exposed later...

Good luck, Barry. Hope it all goes well