Windows Server 2003 Enterprise x64.

Number of disks is unknown. I would guess somewhere around five or more.

Try to get a hold of the DB2 client / gui CD and install that.

I have select * From a DB2 db working on 2005 64 bit export to an...

The free edition gets people interested in the product. Once they see what it can do, they hopefully get hooked and want more.

I just went through changing ip on dns to new 64 bit SQL 2005 box. The only problem we had was Windows authentication to a share. There was...

Check out RESTORE VERIFYONLY in Books Online.

Perhaps as a preventative measure, how often should I run check db?

On SQL 2000 I ran it once a week.

This is on a server configured with RAID 5, SQL 2005...

I hate hibernate, well, if cursor mode is used. But we tried direct and started getting some locking issues (developers didn't code for it), so went back to cursor...

Thanks. I ended up running the Upgrade Advisor. It did find several stored procs that need to be changed to OUTER JOINs.

ok thanks, most of our code are in the applications so Upgrade Advisor probably won't help.

ok, I tried putting my original code in syswow64 directory and ran it as cscript comp2.vbs and it worked. The key was to run cscript in that directory, otherwise...

There's is msjet40.dll in c:\windows\syswow64. version is 4.0.9505.0

ok I try to install Jet 4.0 SP 8 and get a message that it's for a different hardware platform. Must...

Gift Peddie (2/4/2009)

---

I don't understand what you mean by Access in SQL Server but you need to look for the WOW64 directory in Windows 2003 because Access comes only in...

Greg Charles (1/29/2009)

---

Sailor (1/29/2009)

---

I saved a package in BIDS onto a server database. In BIDS, when I try to open the package, I get msdb does not exist. ...

ok, in BIDS, how do I connect to SSIS?

Yes msdb is not part of the name. Thank you that did it.