vpn can be a bit flaky with a home computer and having the right DNS settings

if he's going under windows authentication than it probably means he can't contact a domain controller to authenticate. have him use a sql login

you can try to use logparser to dump the smtp log files into a database and query it. this will depend on the smtp server the email people use. We...

try SSIS

i've had this as well

first check to make sure the default database path is the same as what it was when you first installed SQL. there is a bug with...

R2 is still in beta and won't come out until next year. i wouldn't upgrade to it until SP1 or SP2.

SQL 2005 was buggy even after SP2

i've read for...

our dev servers for SQL are still 32bit and behind on updates. QA is 64 bit and is always ahead in builds compared to production. Most production is on 64...

i think you're safe with msdb, master i'm not 100% sure.

we went from 32 bit SQL 2005 to 64 bit a few years ago. all databases are on a SAN....

you can restore 32 bit databases to 64 bit servers. every day we have a process to copy data on our SAN to volumes that are used by a 32bit...

agree with the above and to add you can try this

restore it as files to the sql 2008 server but don't attach it. detach the current MSDB and attach the...

i've seen similar queries that hit multiple servers with the same or more rows take days to execute. you are better off working on smaller chunks of data at a...

is there any reason for the crazy MS system to get these updates where they send you an email with passwords and download links? any reason why they don't just...

we're still on 2005 but usually push the latest CU to QA and development as well as a few production servers that aren't critical. and once a year or so...

i run SQL 2008 management tools on my PC's and 2005 in production. the client tools work great and offer more functionality than the 2005 Management studio. only thing is...

if you want to do it locally then you can try writing a powershell script and run it on a schedule