Viewing 15 posts - 1,996 through 2,010 (of 9,725 total)
franky.Piferoen (3/10/2016)
The remote user is a sql login which has then necessary rights on the database.
I can login with that user on the server and query the tables.
I use...
March 10, 2016 at 12:50 pm
Jon.Morisi (3/10/2016)
Are the linked server and the login/user security both setup for the same database?
Linked Servers don't require a database level definition. Only a server-level definition.
But if the OP has...
March 10, 2016 at 11:27 am
Grr. Having this issue with another login.
This login does NOT have sysadmin and can't create endpoints. In fact, when I run all the code, I can't find anything that...
March 10, 2016 at 11:21 am
John Mitchell-245523 (3/10/2016)
I'm guessing you've set up mirroring on the server?
SELECT
l.name AS LoginName
,e.name AS EndpointName
FROM sys.server_permissions p
JOIN sys.server_principals l ON p.grantor_principal_id = l.principal_id
JOIN sys.endpoints e ON p.major_id = e.endpoint_id
WHERE p.class_desc...
March 10, 2016 at 8:30 am
Allow me to say, actually, sort of. Depending on how hard you want to work.
You can use Linked Servers to run the query against multiple server connections, but you'll have...
March 10, 2016 at 6:40 am
The login is defined and set up with permissions on both servers (local and remote)?
And it uses the same password on both servers?
EDIT: On the General tab, what is the...
March 10, 2016 at 6:31 am
What changed recently? Around the time that MSDB went Read Only or right before.
March 10, 2016 at 6:31 am
While you might be able to upgrade the packages directly to 2012, I wouldn't recommend it. Enough changed with SSIS between 2005 and 2008 that your incremental step approach is...
March 10, 2016 at 6:28 am
Thanks, all, for the reviews of the presentation.
While my class is now officially over, I'm debating on the possibility of redoing the presentation for a more real-world push of the...
March 2, 2016 at 6:03 am
As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you mind.
March 1, 2016 at 5:59 am
Steve Jones - SSC Editor (2/29/2016)
Alan.B (2/29/2016)
It's not a bad thing for a recruiter to work with the candidate to modify the resume for a position provided everyone is being...
February 29, 2016 at 11:57 am
Grumpy DBA (2/26/2016)
Brandie Tarvin (2/26/2016)
Grumpy DBA (2/26/2016)
Sean Lange (2/26/2016)
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
Well, that's...
February 26, 2016 at 12:06 pm
Grumpy DBA (2/26/2016)
Sean Lange (2/26/2016)
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
Well, that's a good thing because...
February 26, 2016 at 11:52 am
Orlando Colamatteo (2/25/2016)
Brandie Tarvin (2/25/2016)
...some OLTP databases reference tables in the Reporting databases.
How many tables? I am thinking a simple Transactional Replication Publication on Server B subscribed to by Server...
February 26, 2016 at 5:33 am
Viewing 15 posts - 1,996 through 2,010 (of 9,725 total)