Viewing 15 posts - 4,801 through 4,815 (of 11,676 total)
Does the person who created the package still work there? If he/she still does, have him/her open the package on his/her computer and save the package under a different protection...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 22, 2013 at 1:17 pm
Very nice question for a Friday, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2013 at 3:38 am
laird mcbride (9/19/2013)
Wow. . good call . .. Yes we can do that .. . .but .. why cannot we use the dropdowns??
I don't know 🙂
I cannot see your...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2013 at 3:36 am
daniel.carreira (9/20/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2013 at 3:28 am
Can't you select them all at once and change the properties directly?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 10:47 am
daniel.carreira (9/19/2013)
Hi Michal,So i have to add the user (databasename)/System to the sharedrive permissions, is it correct?
Best regards,
Daniel
Yes, it must have read/write access to the shared directory.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 7:16 am
I was going to suggest SQL Server Data Tools, which is Visual Studio of course...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 7:06 am
No, it was introduced in SQL Server 2012.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 6:45 am
SELECT TOP 1
empname
,noofhighprtjobs = COUNT(highprtjobs)
FROM testemp
GROUP BY empname
ORDER BY noofhighprtjobs
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 6:37 am
enriquezreyjoseph (9/19/2013)
Thank you my friend:-)yeah you are right that is also my question why the sex and status table should be normalize..
what do you think is the reason??...
Normalization is very...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 2:42 am
Is the ODBC 32 or 64-bit?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 2:18 am
michal.lisinski (9/18/2013)
HiDid you set Run64BitRuntime as false?
Br.
Mike
This is a design time setting only and doesn't affect the execution of a package on the server.
However, you might be on the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 1:32 am
That's a bit out of my expertise.
You better start a new question for that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 12:42 am
Can you change these properties in the properties window?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 12:40 am
You can add CHECK constraints to the table.
On a sidenote: is it really necessary to normalize the sex table? You can easily store 'M' and 'F' in the bio...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 19, 2013 at 12:38 am
Viewing 15 posts - 4,801 through 4,815 (of 11,676 total)