That makes sense.  Time to update my code.  Thanks

I took a nightly backup from disk on the production server and copied it to the new server.  For comparison I restored the backup on the production server to a...

I'll read about running SQLIO or SQLIOSim.  I've never run them before.

The data drive on the new server is RAID 10 with 10 15k 36GB SAS drives.  The old server's data...

That stinks.  We were trying to come up with a process for developers and consultants to maintain DTS packages.  The developers have SA on our development servers so their permissions...

I'm not concerned with changing the owner.  That part is simple.  I'm trying to determine why DTS is ignoring the login credentials established within Enterprise Manager and instead using the...

Joe,

Can you elaborate on your recompile comment?  I have one 64-bit server running SQL 2005 and we didn't do anything special during the installation.  That's not to say things won't...

Thanks everyone.  I'm not too concerned about the other applications that run on our database servers.  We try to keep the database servers dedicated to SQL Server, with the exception...

The vendor would like to use a DTS package that I believe executes a stored procedure using sp_OACreate, etc...  The DTS package is being executed from an SSIS package using...

The vendor needs to connect to another vendor's (SalesLogix) OLE DB provider to access data when a user creates Blackberry notes or activities.  The provider contains code/procedures that provide the data in...

Thanks.  I believe the primary benefit sited by Kalen was the difference in VAS between 32-bit and 64-bit.  I'll read around to see what problems people have encountered.

Dave

I've lost count of the problems we've encountered with SQL 2005.  I've opened around 9 or 10 tickets with Microsoft support regarding various issues and most are either the result of...

Hi Noel,

That's what I originally thought, but I found sp_altermessage only applies to user messages, which is anything > 50,000.

Thanks,   Dave

Thanks Carl.  Unfortunately sysmon doesn't have a Memory Usage Delta counter, but I will explore using Process Explorer.

Dave

Hi Steve,

We are running Windows Server 2003 SE with SQL Server 2000 EE.  Since the 3GB switch is being used that means user mode processes, such as SQL Server, are...

That's a feature they should have kept in 2005.  They should be working to simplify troubleshooting efforts rather then add complexity.

I'll recreate the error next week to document the problem. ...