Viewing 15 posts - 271 through 285 (of 966 total)
Hard to say without more information. Can you post more of the SQL Server Error Log? You do not have any AV software running against the SQL Server directories, do...
June 9, 2015 at 3:44 pm
That's not quite the right idea. You're trying to INSERT into an OPENROWSET, which isn't designed to handle an insert. Is this a one-time thing or something that needs to...
June 9, 2015 at 3:34 pm
Well is a complicated issue. There is no formal "server administrator" here. Just someone that install the service. Actually the server has serious security issues like all users belong to...
June 9, 2015 at 1:22 pm
Sorry for the simple questions, just trying to understand the environment a little.
Is this the only instance of SQL Server on that machine? It seems a little weird that it...
June 9, 2015 at 11:35 am
Thank you for getting back with me on this.
Another question, you say that you only have two logs available. If you look at the C:\Archivos de programa\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log directory...
June 9, 2015 at 11:22 am
I think you said you are on a physical machine, not a virtual but I never found out where is your storage coming from? DAS or SAN? If SAN have...
June 9, 2015 at 10:59 am
As far as negatives of TDE on performance, note that it is incompatible with a couple of settings. Namely if you have TDE then you lose any space benefits you...
June 9, 2015 at 10:56 am
USE MASTER
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Encrypt01!@'
CREATE CERTIFICATE CERT05 WITH SUBJECT = 'Cert4u12!@'
USE Adventureworks2012
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256 -- Error
ENCRYPTION BY SERVER CERTIFICATE TDECert
USE MASTER
ALTER Database...
June 8, 2015 at 2:33 pm
First time I've heard of this. Can you try and replicate this with SP2 + CU6?
June 8, 2015 at 2:26 pm
The summary log file should have a line in there with the full path of the detail log of the last install. If you can post/upload that file it will...
June 8, 2015 at 2:18 pm
When you say the copy option is failing are you talking about copying the mdf/ldf files or using a BACKUP DATABASE command with the COPY_ONLY option? I use the latter...
June 8, 2015 at 2:14 pm
Is the storage for the server where the databases are hosted direct-attached storage or LUNs from a SAN? I have seen it where SAN failovers occurred but SAN replication failed...
June 8, 2015 at 2:10 pm
User i gave permission to view my report, She does not get any error. She can view the dropdown list but when she selects view report it comes as blank...
June 5, 2015 at 12:58 am
As far as I know SSDT-BI (you do want the version with SSIS templates, yes?) is managed somewhat separately from mainstream SQL Server now. It is probably best to do...
June 3, 2015 at 3:18 pm
Lowell's logic is spot on. Not sure what your search criteria were, but if you search google for "access sql server administrators locked out" you get Microsoft's own Books Online...
June 3, 2015 at 3:00 pm
Viewing 15 posts - 271 through 285 (of 966 total)