Either upgrade to windows 2003 Enterprise 32 bit or windows 2003 Stndard 64 bit 😉

It does indeed but...

Standard 32 bit will only support a max of 4 GB RAM

EdVassie (5/18/2011)

---

My approach would be to do a standard side by side build and test of the new server.

When it comes time to put the new server live,...

wrong

king_emperor_in (5/19/2011)

---

Well I can only move TEMPDB database...

bounceaball (5/19/2011)

---

Our IT guy recently change the server name on my request from CSIADOLP1 to CSIADRPT01. I did use sp_dropserver and sp_addserver.

I am seeing different results.

I have attached the screenshot...

have you checked the sql server logs

bill 36362 (5/19/2011)

---

I have a Windows 2003 standard with SQL 2008 Stnadard. The server does double duty as a terminal server also.

I am upgrading RAM from 4GB...

they're just warnings and can be ignored providing you do not intend to install SSRS

the ghost cleanup is designed to only delete small amounts of records at a time to avoid swamping the DE performance. With lots of rows you may not see an...

Chrissy321 (5/18/2011)

---

Can anyone provide specifics on using BCP through SQL Agent?

I have a 'Operating system (CmdExec)' step set up with the following command.

bcp master.dbo.sp_help_revlogin out c:\test.txt -n -SMYSERVER\MYINSTANCE -T

I am...

that's bad advice then

rely on DNS that what it is...

No it's an external SQL server executable. I use a SQL server agent job to...

sounds like it could be NTFS\share permissions on the file path. The NTFS permissions may be correct but if setting up a new share and not modifying the share permissions...

I personally think this is a small price to pay and...