did you have luck with ODBC on SSIS? I made an ODBC connection but i can't figure out where i can use it. even the wrox book was no...

just double checked, it's 90

i believe if you use a sp it's compiled on the sql server, where if you just passed on the query with a parameter it would need to be compiled...

but then the db is offline while you are backing it up

almost positive it's per physical CPU socket since if you use multi-core they only charge you per socket

there is also a DTS viewer as part of the feature pack you should download. it lets you view and modify the package in a DTS 2000 environment. I needed...

depends

i use veritas and like it, a lot of people here backup to disk and then to tape. where i work they don't want to spend the money for disk...

i had some trouble with Sybase and my solution was to use an Execute DTS 2000 task to use the ODBC connection. It seems SSIS doesn't want to use it...

if anyone is interested I just did the same thing. We have a Sybase server and need to copy the DB to SQL 2000 and SQL 2005 next year.

Currently...

we have this on one of our servers

there is a dev db and a prod db. developers only have access to the databases and not the server itself

The first thing I would do if possible is take the filegroups off RAID5 and put them on separate RAID1 volumes. The more the better. At least FilegroupA since it...

how are the drives assigned between virtual servers and is it A/A or P/A?

my guess is that another node owns it at the moment and you can't access it.

i would start by seeing if any drive letters changed and making sure all the files are where they are supposed to be

i set up mirroring a few weeks ago via the GUI and it went pretty smoothly. Had a problem earlier in the week and restarting SQL on the witness seemed...

you need to set up a test server, restore all your databases and check every sp, job, dts package and application you have against the new server to see what...