Viewing 15 posts - 4,246 through 4,260 (of 4,271 total)
Yes, you are very welcome..
I Love Clustering, once you get the concepts down and you actually get good hardware..
CEWII
June 30, 2009 at 9:17 pm
One of the things I have experienced is that a lot of stuff that I used dynamic properties tasks and ActiveX for can be taken care of with the provided...
June 30, 2009 at 9:09 pm
One of the things I have experienced is that a lot of stuff that I used dynamic properties tasks and ActiveX for can be taken care of with the provided...
June 30, 2009 at 9:07 pm
I get where you are going but I'm not suggesting config files, there is a SQL Server option at the same place.
I think you could accomplish it this way:
1. Use...
June 30, 2009 at 1:40 pm
It feels like a PIVOT operation..
See SQL 2005 BOL (November 2008)
ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/udb9/html/24ba54fc-98f7-4d35-8881-b5158aac1d66.htm
If that doesn't help ask for clarification..
CEWII
June 30, 2009 at 1:27 pm
I am 95% sure that when SQL is taken offline that it stops the service on whatever node has it..
CEWII
June 30, 2009 at 1:24 pm
I believe that the backup files are compatible that direction.. Meaning you can take a backup file from the 2000 box and do a restore directly on the 2005...
June 30, 2009 at 12:56 pm
You do it through Package Configurations. Enable package configurations in the *Child* package. Add a configuration and choose "Parent Package Variable" from the list and type in the...
June 30, 2009 at 12:49 pm
I think you will be fine, provided that the queries executed behave the same way against the database in that compatibility mode. I would probably upgrade the DTS to...
June 30, 2009 at 12:42 pm
Are you getting out a single row of data or multiples? If a single row then I think you can use OUTPUT parameters.
On the remote side you might hae...
June 30, 2009 at 12:35 pm
I think you are going about this the wrong way.. You don't need to do it that way..
Turn on Package Configurations by right clicking on the Control Flow and...
June 30, 2009 at 11:57 am
It aint pretty but you could seperate the process up some and move some of it to a 32-bit SQL box that could access Sybase.
Otherwise you are stuck using 64-bit...
June 30, 2009 at 10:52 am
The previous poster is right on.. In addition to what he has to say I would run the Upgrade Advisor that MS provides to give you an idea of...
June 30, 2009 at 10:48 am
First of all SQL 2008 does not support 6.5 compatibility, only 7, 2000, and 2005. I'm not surprised that a db with 6.5 compatibility failed, SQL doesn't know what...
June 30, 2009 at 10:45 am
This only works if the user logs in using Integrated Security, if the use a SQL login then SYSTEM_USER will show that name.
You may not be able to...
June 30, 2009 at 10:34 am
Viewing 15 posts - 4,246 through 4,260 (of 4,271 total)