No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0Votesexecute permission on a procedure allows selects without specific read permission
Does this behavior seem correct or am I not seeing some hidden security setting? I have a brand new login that I just mapped to a database. All that this user has is an execute ... -
Unanswered0VotesIdentify Windows database user created without login
Hi guys, I'm running into an issue when try to sweep out orphaned database users. Basically, it's about the way how to identify orphaned Windows database users from Windows database ... -
Unanswered0VotesConfiguring Sql Server 2008R2 for encrypted connections
I have followed the recommended steps at http://technet.microsoft.com/en-us/library/ms191192.aspx in order to configure my certificate and for Sql Server to accept encrypted ... -
Discussion0VotesTEMPDB doesn't show it's encrypted when other databases are encrypted for sql 2008 R2.
when I encrypt a database in sql server 2008 R2 the documentation states then once a database is encrypted tempdb becomes encrypted. but when I look up properties in SSMS for tempdb it doesn't show ... -
Discussion0Votesallow sysadmin role temporarily, is it possible to do in a secure way.
Hi everyone I'm in a environment where a number of systems do not hava a test/acceptance environment. For example telephony, or systems thats integrated with *IX systems, or squid ... -
Proposed0VotesMinimum permissions
SQL2000 What are the minimum privileges / permissions / database roles needed to grant a user (besides granting sysadmin) to: 1) Create and ... -
Unanswered0VotesThe server principal 'username' already exists (Microsoft SQL Server, error: 15025)
SQL Management Studio SQL 2008 R2 Create database Restor from backup Now I am trying to ... -
Unanswered0VotesDatabse shrink status
Hi All, I have started the databse shrink using GUI, It's keep on running since 1 hour. The DB size is 53GB. ANy idea how much time it will going to take to ... -
Unanswered0Votesproblem Encrypting Database from master key
Hello All, I need a help.. I use tempdb for createing master key, becuase masterkey was already created by someone in the master database of system ... -
Answered10VotesMicrosoft SQL Server Error 18456 Severity 14 State 1
I can't seem to connect to our local instance of Microsoft SQL Server. I obtained the followinf infrotmation from the error log and I can't find anything in regards to Severity 14 and state 1. If ... -
Proposed0VotesAlter index or table
I have SQL2008 and I'm sys.admin on that server. But I can't create alter table or alter index script, it is disabled(grey). If I click on some index, I can't add columns or change ... -
Answered0VotesSQL 2012 - Backup to remote device
Hi I need tips in resolving "access denied" errors on a network share. Using the agent account i can manually copy the local BAK to the remote ... -
Unanswered0VotesSp_xp_cmdshell_proxy_account not changing xp_cmdshell context?
Hi, I've reset the proxy account using: EXEC sp_xp_cmdshell_proxy_account NULL; Then I created a new proxy account: EXEC ... -
Answered2VotesThe security database on the server does not have a computer account for this workstation trust relationship
Hi I have a job and I use a proxy account while running an ssis package. And I got an error massage like below for a few ... -
Unanswered0Votesattach database in sqlserver 2000
i am trying to attach an .mdf file located in the data file inside of the sqlserver folder inside of the program files folder. however its not working because sqlserver is unable to ... -
Proposed0VotesSSL Encryption using Certificate with SHA-256
Even though SQL Server 2005 Enterprise database doesn't support SHA-256, will the SSL Encryption be able to use a certificate with SHA-256? We are developing a migration plan to move to Windows ... -
Answered0VotesCreate table, but not update data in tables
I'm a SysAdmin who's inherited some DBA duties. I did a DBA course back in the MSSQL 7.0 days, but al lot has changed since then. Right now I'm trying to get my head around ... -
Proposed0VotesUnable to create Audit in SQL Server 2008
Whenever I try to create new Audit in SQL Sever I get the following error: Unable to cast COM object of type 'System.__ComObject' to interface type ... -
Answered0VotesEncrypt and Decryt the database
I have an web application,It is in ready stage.Now we need to encrypt the whole database for security purpose. My concern is to encrypt the whole data of tables in ... - Items 1 to 20 of 6233 Next ›


