just buy a sql 2008 license, you can use sql 2005 with it

with MS you always need a server license and CAL's so if you have 2005 CAL's, just buy...

how is it going to save $10,000? we run VMWare here but don't run exchange or SQL on it. we're about to order a new QA SQL server as well....

check out the BOL section on db mail

last year we had an issue where we had a full transaction log in a db with a table that has 300 million...

as a former exchange admin, you have to go to the email folks and trace the email from the smtp server to the mailbox server to see if it was...

what's the problem?

i'd say it depends on the queries. if the reporting code is a lot of data manipulation than you'll probably want the powerful CPU's there. most of our transactional stuff...

my condolences that you have to support ArcServe or anything made by CA

we used it 10 years ago, it never worked right and we switched to Netbackup. for all it's...

if you're uninstalling the old SQL, why not just reinstall the OS as well?

amd's drivers are already part of windows, been that way for years

and we're also running windows 2000 on x64 capable chips in some situations. we can go 64bit software at any time on x64 with a simple OS reinstall as well...

we have a clustered index on a column in a table where the data is not unique

reason is that we used to have it on another column but we run...

for some reason i've never got it to work via ODBC into a remote database

biggest problem with itanium is no backward compatibility

we just installed x64 windows and sql 2005 on a new server that will run the existing x86 app. when there is an...

do the logins have public permissions to all the databases? we always leave the public default and add the extra r/w permissions as needed

you can try views

we have a dev who wrote something similar except he loved using views and rarely used temp tables. write a view for every temp table insert. you...