LM
I am thinking of doing it in MS SQL Server , Please advice .
Printable View
LM
I am thinking of doing it in MS SQL Server , Please advice .
Go ahead and do it. It certainly gives you an advantage w.r.t interviews. If you go up to MCDBA, it would be much better.
hmm Thanks LM :)
Hi
i bought dell inspiron 15R i want to install Win xp along with win7 . But blue screen error occurs.. saying CHCKDSK F.. i want to use dual OS give some suggestions.. i'm installing win xp for mech design software Pro-e usage.
Found this link.
http://en.kioskea.net/forum/affich-1...-to-install-xp
Check if the above solution works :D.Quote:
If you are trying to install the Windows XP from scratch on the laptop, please BE SURE that you put the Hard Drive on "Compatibility" mode in BIOS, which was defaulted to "AHCI" (Compatibility is also known as IDE).
Otherwise, you will experience the "blue screen" issue.
To change that setting, you need to do the following:
1. Press F2 when booting up the computer
2. Select 'Config', then 'Serial ATA (SATA)'
3. Change controller option to 'Compatibility' / 'IDE'
Adding to Puli's suggestion, check if your Win XP installation CD has SP2 as well. Most probably Puli's tip would work.
Has anyone worked with variables within SSIS?
I have created a variable called SQL within SSIS and it has some SQL code as the expression.
I now have a Data Flow task, and OLE DB Source editor withing the DFT. When I call this variable from OLE DB source editor, I get an error saying
"Command text was not set for the command Object"
Any idea as to what the problem is ??
Params,
As a general principle, it's not preferable to use 'SQL' as a variable :-)
It's possible some tools use it as a key word / command directive etc, though not explicitly stating to avoid using as a variable.
Just a suggestion. Not to imply that it has any bearing on this specific situation of yours but in general :-)
App na
I know about 'SQL' being the reserverd word, but in SSIS when you declare a variable you do not do this
Declare @variable varchar(255)
it is done differently, not through T - SQL
Has any one worked with
1) Active/Active clustered SQL Servers?
2) Active/Passive clustered SQL servers using DMware ?