Viewing 15 posts - 1,891 through 1,905 (of 9,707 total)
Sean Lange (3/30/2016)
Brandie Tarvin (3/30/2016)
Sean Lange (3/29/2016)
We have a stringent list of requirements:•Have a pulse.
•Be reasonably competent as a developer.
So basically you're discriminating against vampires and zombies.
Good to know. I'll...
March 30, 2016 at 7:45 am
Sean Lange (3/29/2016)
We have a stringent list of requirements:•Have a pulse.
•Be reasonably competent as a developer.
So basically you're discriminating against vampires and zombies.
Good to know. I'll warn my cousin not...
March 30, 2016 at 5:31 am
jasona.work (3/29/2016)
Of course, if he sent me out looking for brake light fluid, I'd run down to the little shop and grab a Mountain Dew...:hehe:
And now we know why you...
March 29, 2016 at 11:33 am
happycat59 (3/28/2016)
You said that the new environment is a SQL failover cluster. If this is correct, there is no need to worry about SQL Agent Jobs.
That's not true....
March 29, 2016 at 3:48 am
TheAccidentalDBA (3/28/2016)
March 29, 2016 at 3:45 am
TheAccidentalDBA (3/28/2016)
March 28, 2016 at 9:59 am
jasona.work (3/28/2016)
Brandie Tarvin (3/28/2016)
<headdesk>IMPERSONATE.
That's the stupid hangup. IMPERSONATE.
GAH.
Could be worse...
You could've not found anything...
😀
Rather annoying though, how difficult it can be to track down things like this, in the UI.
Finding...
March 28, 2016 at 9:21 am
<headdesk>
IMPERSONATE.
That's the stupid hangup. IMPERSONATE.
GAH.
March 28, 2016 at 8:46 am
jasona.work (3/28/2016)
The database principal has granted or denied permissions to objects in the database
and cannot be dropped. (Microsoft SQL Server, Error: 15284)
The part above...
March 28, 2016 at 7:59 am
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
Viewing 15 posts - 1,891 through 1,905 (of 9,707 total)