Viewing 15 posts - 1,831 through 1,845 (of 7,168 total)
I highly recommend this book.
Learn Windows PowerShell 3 in a Month of Lunches
It goes through the Execution Policy choice, as well as Remote Management. You'll be scripting in no...
February 27, 2013 at 5:11 pm
No real risks as long as you choose the correct Execution Policy for your environment.
February 27, 2013 at 12:54 pm
dlangschied (2/27/2013)
February 27, 2013 at 12:51 pm
What method are you trying? Please post the code and a sample Excel file so we can recreate the problem on our side.
February 27, 2013 at 11:55 am
So even if SQL is installed as non clustered, DTC can still become involved somehow
Yep.
If that's the case, why when dealing with Clustered instances of SQL Server do we have...
February 27, 2013 at 9:05 am
Excellent! That is how the GAC is supposed to work. Happy to know you got it sorted. Thanks for posting back.
February 27, 2013 at 9:02 am
SQL also will the DTC if you try using explicit transactions with Linked Servers. I also use it with SSIS transactions, not technically the database engine but another use of...
February 26, 2013 at 9:03 pm
If you had a large CPU workload in the first place the worker threads used by the additional mirroring sessions (not negotiable) could have pushed you beyond a tipping point...
February 26, 2013 at 9:00 pm
When the package runs on the server it does not have access to your drives. Does D:\MyFiles exist on the server?
If you want more help zip your SSIS package and...
February 26, 2013 at 8:40 pm
It sounds related to a mismatched SID between the Server Login and Database User. By any chance was the database in question restored to this server from a backup taken...
February 26, 2013 at 8:14 pm
What changed? Your last post said error code 9, but this post says exit code 1. Looks like you're calling a different exe now.
What mainframe? Is that just a job...
February 25, 2013 at 9:13 am
You'll need to use an Expression. In the Variables window, click on the Variable in question and hit F4 to bring up the Properties for that Variable. Set EvaluateAsExpression to...
February 22, 2013 at 1:06 pm
The query will scan every row in the table unless the column happens to be the leading column in an index. Scanning large tables can impact performance. You may want...
February 22, 2013 at 7:08 am
hiren-411325 (2/22/2013)
Install virus guard. there is a virus like activity in your system.
Can you please explain your reasoning a bit as to why you think a virus huard might help...
February 22, 2013 at 7:03 am
hsmanandhar 33101 (2/21/2013)
Steps I made for Job run successful :
Create a Credential in SQL Server with the windows User Name.
Create Proxy with this Credential.
Run SSIS with Proxy.
This...
February 22, 2013 at 7:01 am
Viewing 15 posts - 1,831 through 1,845 (of 7,168 total)