It looks like I need to have some kind of ID column on each table. I might have to adjust some of the other code since right now the tables...

I am unfamiliar with using join. Is it not possible to modify the code above to just copy all rows?

Yeah CASE was the wrong term to use. Looks like I want something like this:

IF ((SELECT DATEPART(MONTH, GetDate())) = 04)

UPDATE

db1

SET

...

I think I mean to use CURRENT_TIMESTAMP as I want to compare to today's date/time. I don't really have a sample since this is just theoretical right now.

Msg 156, Level 15, State 1, Line 65

Incorrect syntax near the keyword 'FROM'.

Msg 156, Level 15, State 1, Line 95

Incorrect syntax near the keyword 'FROM'.

GilaMonster (4/15/2014)

---

mlwiller2 (4/15/2014)

---

I'm still getting that error but when doing select @@version it says I'm at 0.0.5000 (sp4). Tried the exec xp_readerrorlog command and still didn't get the "locked memory...

I tried the permissions fix as well as a few others I found searching. This was just a test VM and after seeing no differences after upgrading (and that it...

I think I found my own answer:

http://blogs.msdn.com/b/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx

Since I was always able to see the "Address Windowing Extension enabled" message before upgradeing SQL, it looks like the whole thing...

I'm still getting that error but when doing select @@version it says I'm at 0.0.5000 (sp4). Tried the exec xp_readerrorlog command and still didn't get the "locked memory in pages"...

Lots of good info here. Unfortunately, I'm still working on getting the output of that statement on page 1 to say "locked pages in buffer pool" correctly (still 0 rows...

I got "0 rows effected." I'm going to upgrade to SP4 on my test VM to see if that could be the issue. If I'm running SQL using the system...

Forgot to mention that I had planned on adding an additional 16gb for a total of 20gb to take advantage of AWE. So is LPIM not a requirement for AWE...

4Gb memory total on the sever. I have several databases over 20Gb that I can see SQL can't hold in RAM since the page life expediency time drops to near...

It's on a closed network so direct copy and paste is kind of a pain unless its a full log or something. But yeah its x86. Both SQL (standard) and...

Microsoft SQL Server 2005 9.00.3042.00