SQL Server | Forum profile

Well, you can say:  UPDATE tbl  SET    last_updated = DEFAULT  WHERE  ... But if you don't list the column in the SET clause, nothing will happen. > Triggers would be a possibillity, but I would prefer a default which get > 'pasted' during the update and not use triggers.

Ben You can compare ROWVERSION  for the specific data like client applications connects to the database and returns some data , then it performs some operations (UPDATE) for example and when you are ready to commit the transaction, compare a row versuion of your old  (when you first returns the data) and new (SELECT from the table ) before commiting a transaction , so if they are different someone updated that row If you are...

There have been many examples of people who have wasted a LOT of time looking for help on forums for a production outage when getting MS support (or a qualified consultant) on board immediately was by far their best option.  I recommended that as your best option since you failed to mention that you were already in the queue with MS support. I could have also asked other questions but they would have all been related to what...

My only concern was you stating that you were 'stunned' at Kevin's assumptions, as if he/we should know what else you had been doing. Signature HTH Kalen ---------------------------------------- Kalen Delaney SQL Server MVP www.SQLServerInternals.com > Hi Kalen, > [quoted text clipped - 92 lines] >>>>> Thanks, >>>>> Rubens

Sigh, ... this is probably true, however, you are consistently refusing to acknowledge the maintainability portion of the equation. As has been in evidence in this discussion, pretty much everyone knows SSIS and pretty much everyone does not know LINQ. Therefore, when your staff changes you're either not going to have people who know LINQ, or you will have to use developers (who know C#) for DBA duties. ... >> Let me ask...

Your media must be different than the installed version. That can happen. Find a versoin of the media that is the same as your installed version. Signature Geoff N. Hiten Principal SQL Infrastructure Consultant Microsoft SQL Server MVP > Hi Geoff > [quoted text clipped - 54 lines] >>> >>> Charles

I figured this out.  I had to install Team Explorer which is a free download available online.  What confused me was the size of the install file, almost 400 MB. Thanks. > Please forgive me if I am posting this to the wrong group. > [quoted text clipped - 14 lines] > Thank-you, > Rubens

Kalen/Erland, Thank you both for your assistance.  Kalen, I actually did run the exact same initial SELECT query with the join, and it return no results at all (since there aren't any records with NULL approval dates). The EM doesn't really provide much in the way of options for the restore.  I feel pretty sure about which backup I was restoring based on the date and time of the backup as shown by EM.   I...

Hi Kevin. I'm not importing/exporting data, just transferring and transforming. You are generalizing, we're talking about experienced developers, Who are aware of scalability problems and don't just "slap code together". So why do you think that SSIS will be more efficient for us? >I am among other things a SQL Server performance tuning consultant and I >have a saying that I tell all of my...

If you are on SQL 2008, you'll have the Change Tracking function available. I haven't used it myself though, but it more or less sounds like something you can program yourself by means of triggers so there might be a little overhead when turning it on. Signature Regards Steen Schlüter Persson (DK) > Dear reader, > [quoted text clipped - 7 lines] > Thanks for your time and attention, > Ben Brugman