When you change modes the sa password is still disabled. Here read this article:http://technet.microsoft.com/en-us/library/ms188670.aspx

If Windows Authentication mode is selected during installation, the sa login is disabled and a password is...

igloo21 (1/10/2014)

---

Hello-

I’m having a minor issue and I’m having trouble figuring out why. So basically all I want to do is update one column using the UPDATE and SELECT below....

Can you join Productss (is it really spelled with two S's :hehe:) to the select statement i.e.: UPDATE pdt

SET pdt.HotLeadParticipant=0

FROM

dbo.ValidProducts...

Please also provide the table DDL and some sample data along with the expected outcome. Please review the article in my signature and post the necessary items. Thanks

As Lynn said there isn't enough information I got rid of the splits variable and guessed at the others and it works fine for me:Declare @backupcommand varchar(2000)

,@subdir varchar(200) = 'c:\'

,@databasename...

Dennis Post (1/10/2014)

---

Because of the time it takes to review the rows another process may come in and start grabbing those same rows while you are in the middle of...

Partitioning would work great for your case, the only issue I see is the administration of having to prepare all of those partitions for every day. What your developer is...

Keith Tate (1/9/2014)

---

The select statement that Chris gives is for you to see the data before updating once you are comfortable with the query you can remove the select statement...

Again have you tired searching on the topic? There are a lot of good resources and a lot of the same principles apply regardless of which version you are moving...

The problem I see here is that you getting rows that have not been processed and then checking for bad data or other stuff and then processing them. Because of...

The select statement that Chris gives is for you to see the data before updating once you are comfortable with the query you can remove the select statement as it...

I'm not sure what you really want for you result set. Can you give us the actual results you want with real values and numbers?

Have you tired running a search on "sql server 2005 to 2008 upgrade checklist" there a lot of good hits using that. Here is one from SSC http://www.sqlservercentral.com/blogs/pearlknows/2010/12/13/upgrading-to-sql-server-2008-a-comprehensive-checklist/

Please edit your post to include consumable DDL and sample data scripts. This will make answering you question a lot easier.

Looks better than what I came up with:

update @TheOriginalDates

set DateWithNewTime = dateadd(ss,-1,dateadd(dd,1,cast(cast(CurrentDate as date)as datetime)))🙂