Thanks for the sample data and expected results, but one thing I would advise is to post them in a consumable format, the second link in my signature block details...

How up to date does the data in tableA need to be for querying?

You could use something like SSIS to copy data from server1 to server2, replication is also an...

Yes, if you have Enterprise licenses and impliment a scaled out deployment of SSRS servers.

You will need to uninstall SP4 and then install SP2. Make sure you backup all databases inc system databases before doing this and have a very large downtime window...

L' Eomot Inversé (6/8/2012)

---

Stefan Krzywicki (6/8/2012)

---

Ugh, just found out we're switching to security that requires you to change your password every 90 days. Nice that we're switching to that now...

everything is written to the transaction log you cannot stop that, it all depends...

What account is your SQL server running as? Network Service? Local System? Domain account?

If possible, change the service account to a domain account as thats best practise solution, and...

Stefan Krzywicki (6/8/2012)

---

anthony.green (6/8/2012)

---

90 days thats a luxury, the company group policies here are typical user accounts get 45 days, and if your a domain admin your password expires...

90 days thats a luxury, the company group policies here are typical user accounts get 45 days, and if your a domain admin your password expires every 14 days.

Daniel Bowlin (6/8/2012)

---

Ray K (6/8/2012)

---

anthony.green (6/8/2012)

---

Revenant (6/7/2012)

---

"This must be a Thursday," said Arthur to himself, sinking low over his beer. "I never could get the hang of Thursdays."

-- The Hitchhiker's...

well if you want to upgrade everything and if you cannot get a hold of media which is built on SP4 then you will need to uninstall and reinstall everything....

Logshipping is an option. Set it up, then when your ready to migrate, simply backup Server1's database logs with norecovery, and then restore that log on Server2 with recovery....

One option is dynamic sql, much like the below

declare @sql nvarchar(max), @age int, @id int

set @sql = '

select

*

from

test a

inner join

test1 b

on

a.id=b.module_id

where

a.id=@id

and...

You cannot compare a value to a null value, NULL is NULL and only ever NULL

What is NULL is it 0,1,2,3,4,5,'IDontKnowWhatIAm','ShouldIBeThisValueOf60834abc', so as there is no value it is excluded...

the N specifies that the following string is a NVARCHAR string

N'\\XXXXXXXX\W$\LOG_BACKUP\XXXXXXXX_tlog_201206072000.TRN'

Your actually backing up to \\XXXXXXXX\W$\LOG_BACKUP\, not the N drive

Edit

Mike beat me to it again