Viewing 15 posts - 1,921 through 1,935 (of 9,725 total)
Well we do use MSDTC quite regularly so it's good to hear that there is a solution. Thank you for posting the details.
March 28, 2016 at 7:38 am
Last question then. Are you using Bulk Insert tasks that are failing or is it the whole package with other tasks that are failing on connection?
March 28, 2016 at 6:30 am
webrunner (3/25/2016)
...
1. Each morning, a script places 3 files in a share on a db server:
File_Name1_MM-DD-YYYY-NN
File_Name2_MM-DD-YYYY-NN
File_Name3_MM-DD-YYYY-NN
2. Additionally, at some point during the day, someone will request for one or...
March 28, 2016 at 5:26 am
Another thought. Have you verified that the server accepts remote connections?
That's my suspicion if the only time it works is when you are on the server itself. On your desktop,...
March 28, 2016 at 5:13 am
Jon.Morisi (3/25/2016)
It is a db_owner in the database
are you trying to delete the actual owner of the database?
No. The databases are owned by my user name. I'm trying to drop...
March 28, 2016 at 4:18 am
Lynn Pettis (3/25/2016)
Brandie Tarvin (3/10/2016)
This login does NOT have sysadmin and can't create endpoints. In fact, when I run all the code, I...
March 28, 2016 at 4:16 am
TheRedneckDBA (3/27/2016)
March 28, 2016 at 4:00 am
When SQL is installed, it generally asks for the accounts of the local sysadmin. If SQL was installed on the machine before you got it, then it is likely no...
March 25, 2016 at 5:46 am
mw112009 (3/24/2016)
March 25, 2016 at 5:39 am
The cluster MUST be a Windows cluster, but you don't have to have SQL clustered in order to use AG. You can have a SQL cluster use AG, but ......
March 25, 2016 at 5:37 am
Yikes! Are you a Verizon customer? You may have had your data hacked.
March 25, 2016 at 5:30 am
All,
I've been having some login trouble on our new SQL 2012 servers. Old logins that I'm trying to delete from databases are not deleting and I don't know why....
March 25, 2016 at 4:40 am
Pete Softown (3/24/2016)
I've asked to change the scope of the DOMAIN_B\GROUP_1.According to this article, its supposed to be possible
https://technet.microsoft.com/en-us/library/cc755692(v=ws.10).aspx.
Thanks all 🙂
You're welcome and thank you for adding...
March 25, 2016 at 4:18 am
To those who celebrate: Happy Good Friday.
Of course, you won't see this until next week probably (given how many people are off), but still. @=)
EDIT: I suppose I should put...
March 25, 2016 at 4:17 am
GAH! Of all the freakin' stupid M$ crap...
I'm looking in the wrong toolbox. http://www.jamesserra.com/archive/2013/01/ssis-2012-empty-toolbox/%5B/url%5D
March 24, 2016 at 12:10 pm
Viewing 15 posts - 1,921 through 1,935 (of 9,725 total)