There are some other ways to get to record level, such as adding a field with a default value of GETDATE(), and/or adding an AFTER INSERT, or AFTER UPDATE trigger...

SQL Agent jobs run under a service account on the server, and if it uses the saved password together with that service account as credentials to DB2, then yes, it...

While a MERGE is not the only way to accomplish the task, we have no information from you to tell us what other things we'd need to take into consideration...

How about TRUNCATE TABLE or DELETE * FROM TABLE ?

And now you've added "maximum average sales amount" to the mix, which you have not defined. My problem is that I don't really know what the average sales...

I've heard nothing but bad things about Entity Framework, but that aside, have you tried (and will EF support?) putting that query iinside of a stored procedure and have the...

Only two thoughts...

1.) Why does it matter? For any given stored procedure, there's an objective that it needs to accomplish. You only need input in the...

I wouldn't worry about the format right away. I need a better explanation of what you actually mean by "distribute". It's often best when posting problems...

As painful as it might seem, have you considered scripting ALL the database objects, then backing up the database, then detaching it, moving the MDF and LDF files somewhere safe,...

Not everyone has the ability to open a .rar compressed file. You may want to put the files in a .zip file instead.

Glad I could help. You may want to do some quick analysis on the files in the network share and compute average filesize, as the recommendation at that...

Installation of SQL and of service packs leaves a log file behind, so as long as those still exist, you have a shot by looking for them and seeing which...

A couple of possibilities come to mind.

1.) Somehow, a critical file installed by SQL Server is no longer present,

2.) Somehow, NTFS security on at least one...

Take a look at the following:

http://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx

It does a better job of explaining FILESTREAM than I can. There are a number of things that could be problems -...

You should certainly check error logs, as well as job logs, and just to be sure, check that the date hasn't been accidentally changed on the server...