Viewing 15 posts - 1,981 through 1,995 (of 9,720 total)
The obvious answer, which you indicated you might not be able to do because of size, would be to restore the entire database (not just the primary filegroup) down to...
March 14, 2016 at 4:25 am
Eirikur Eiriksson (3/12/2016)
Brandie Tarvin (3/11/2016)
What a wonderful day in the upgrade-hood...Sigh.
So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:
Baggages?
😎
😛
Still not sure if I like Data Tools or not....
March 14, 2016 at 4:22 am
Windows 10 or Windows 2010?
I don't know of any Windows 2010 release.
What version of Windows was the user upgraded from? And was SQL 2012 32bit also or 64bit?
March 14, 2016 at 4:14 am
As an added note, I worked for Iron Mountain Records Management when 9/11 happened. I remember well the tales of the New York office getting people up and running right...
March 11, 2016 at 6:56 am
Vyper426 (3/11/2016)
Just before this, MSDB had been corrupted. We took the backup from the backup system and replaced it. The backup system does not...
March 11, 2016 at 6:53 am
What a wonderful day in the upgrade-hood...
Sigh.
So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:
March 11, 2016 at 6:20 am
Honestly, the only time I've ever seen the error is if:
1) The login doesn't exist on the server
2) The login exists on the server but doesn't have database level permissions
3)...
March 11, 2016 at 6:16 am
franky.Piferoen (3/11/2016)
Hi,this returns
SomeUserSQL_LOGIN0
Are you sure, absolutely positive, that the user name is spelled exactly the same way on the server as it is in the linked server?
March 11, 2016 at 5:06 am
I think it would make an excellent presentation. Make sure to include the ability of people to reach that documentation during DR. After all, if the only copy is in...
March 11, 2016 at 4:17 am
Vyper426 (3/10/2016)
The log does not show any errors on MSDB but when I try to bring SQL Agent online, it fails with the error that MSDB is read_only.
What changed right...
March 11, 2016 at 4:12 am
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
Viewing 15 posts - 1,981 through 1,995 (of 9,720 total)