No announcements
Forums [ view all ]
-
Select allSQL Server Data WarehousingSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server SearchSQL Server SpatialDatabase DesignSQL Server Master Data ServicesSQL Server ManageabilitySQL Server PowerPivot for SharePointSQL Server PowerPivot for ExcelSQL Server Application and Multi-Server ManagementSQL Server Samples and Community ProjectsMicrosoft StreamInsightSQL Server MigrationSQL Server Data Quality ServicesSQL Server Distributed Replay
-
Select allAnnouncements for all ForumsForums Redesign - Q&A / DiscussionsSuggestions and Feedback for the ForumsWhere is the Forum For…?Forums Issues (not product support)Off-Topic Posts (Do Not Post Here)MSDN and TechNet Profile and Recognition System Discussions
-
Select allSystem Center Mobile Device Manager
-
Select allBizTalk Server GeneralBizTalk Server Adapters and Adapter PackBizTalk Server EDI and AS2BizTalk Server RFIDBizTalk Server Host Integration Server
-
Select allExchange Server 2013 - General DiscussionExchange Server 2013 - Administration, Monitoring, and PerformanceExchange Server 2013 - High Availability and Disaster RecoveryExchange Server 2013 - Outlook, OWA, POP, and IMAP ClientsExchange Server 2013 - Mobility and ActiveSyncExchange Server 2013 - Setup, Deployment, Updates, and MigrationExchange Server 2013 - Extended Components, Tools, and UtilitiesExchange Server 2013 - Mail Flow and Secure MessagingExchange Server 2013 - Unified MessagingExchange Server 2013 - Sharing and Collaboration: Site Mailboxes and Public FoldersExchange Server DevelopmentExchange Server 2013 Preview (locked)
-
Select allTechNet Website FeedbackMSDN and TechNet Search FeedbackTechNet Wiki Discussion
-
Select allForefront Identity Manager 2010
-
Select allMicrosoft Operations Framework -- MOF 4.0
-
Select allIT Management Planning and Technology
-
Select allTraining and Certification
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0VotesSQL server 2008 Client inactivity log out
Hi, I am looking at implementing some security when user connects to a SQL server 2008 database (residing on a different server machine) using a Management Studio ...1 Replies | 102 Views | Vipin Nyati - Wednesday, July 03, 2013 11:06 AM | Last Reply Pradeep Adiga - Friday, July 05, 2013 6:37 PM
-
Answered2Votes
Members of "db_datareader" Can Script Tables but not Views
Does anyone know why members of the "db_datareader" group can script tables (via SSMS) but not views? When one of my user attempts to script a view, she receives the ...6 Replies | 87 Views | Crazy Adam - Friday, July 05, 2013 3:34 PM | Last Reply Crazy Adam - Friday, July 05, 2013 4:56 PM -
Unanswered0Votes
SSRS opens a blank page
Hi, I just installed SSRS on my SQL Server 2008 but when I type the link to this in Internet Explorer I get a blank page. What could be causing ...5 Replies | 103 Views | runnerpaul - Thursday, July 04, 2013 3:21 PM | Last Reply runnerpaul - Friday, July 05, 2013 2:02 PM -
Unanswered0Votes
Resetting sa password
Hi, What are the consequences of changing the sa password? Regards Paul4 Replies | 93 Views | runnerpaul - Wednesday, July 03, 2013 11:15 AM | Last Reply Uri Dimant - Thursday, July 04, 2013 5:46 AM -
Unanswered0Votes
Query runs in MGMT studio but not in .Net code
Greetings, I am facing a problem with one of my query, I'm able to run that query in management studio after connecting through application userid and password, ...3 Replies | 74 Views | S.M.Gopinath - Wednesday, July 03, 2013 12:08 PM | Last Reply Vishal Gajjar - Wednesday, July 03, 2013 2:43 PM -
Answered0Votes
SQL Server 2012 User Permission
Hi Currently we are trying SQL Server as future development if possible. I have question about what is the best approach to provide permissions to user. We ...4 Replies | 106 Views | drew_p - Tuesday, July 02, 2013 1:17 PM | Last Reply drew_p - Wednesday, July 03, 2013 2:28 PM -
Proposed1Votes
Need to prevent changing the Default Database for a SQL Server Login
A user showed up on our audit reports for changing the default database for a login that happens to be an active directory security group. It's pretty harmless, but we want to prevent ...11 Replies | 180 Views | jb6238 - Monday, July 01, 2013 6:11 PM | Last Reply davidbaxterbrowne - Wednesday, July 03, 2013 1:52 PM -
Answered0Votes
Create 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 ...14 Replies | 425 Views | Access Capital - Thursday, June 06, 2013 7:11 AM | Last Reply Erland Sommarskog - Wednesday, July 03, 2013 8:32 AM -
Unanswered0Votes
Looking for workaround to install SQL Server 2008 R2 when "Debug Programs" policy is disabled
We've been experiencing problems installing SQL Server 2008 R2 on several test machines. I'm not sure as to why yet, but it appears most of the test machines we've tested thus far had ...1 Replies | 122 Views | SPECTRUMWIZARD - Monday, July 01, 2013 6:23 PM | Last Reply Sofiya Li - Wednesday, July 03, 2013 8:04 AM -
Unanswered1Votes
Roles in SQL Server
I want to create a role which has select and execute access on a database. Should I create a application role or use the existing database roles? Which one is ...5 Replies | 144 Views | kccrga - Tuesday, July 02, 2013 3:09 AM | Last Reply Rick Byham, Microsoft - Tuesday, July 02, 2013 3:35 PM -
Unanswered0Votes
revoking all permissions from public role in user database throws error when trying to access from vba front end
Hi, As per audit requirement we were asked to remove all permissions from public role and assign these permissions to new user role. Hence we revoked all permissions from PUBLIC and ...5 Replies | 129 Views | shaila_Ac - Tuesday, July 02, 2013 8:20 AM | Last Reply Rick Byham, Microsoft - Tuesday, July 02, 2013 3:32 PM -
Proposed0Votes
Creating loginswith passwords
CREATE To > New Query Editor Window. It's then possible to copy and paste the script to the new SQL Server instance and run it. If there is a password it is encrypted. ...6 Replies | 138 Views | runnerpaul - Monday, July 01, 2013 3:54 PM | Last Reply TiborK - Tuesday, July 02, 2013 10:50 AM -
Unanswered0Votes
MSSQL Database archiving and purging
Hi All, We have a Production Database size of 53GB, and as per user requirment we need to do archiving and purging for the DB. I will be going to do first time ...5 Replies | 132 Views | Nikhilsharma01 - Monday, July 01, 2013 7:56 AM | Last Reply Uri Dimant - Monday, July 01, 2013 9:19 AM -
Unanswered0Votes
Share Search DB not working after server move
Hi, I just moved my search database to a new server but now when I try to perform a search in SharePoint it doesn't work. I have noticed that ...2 Replies | 149 Views | runnerpaul - Saturday, June 29, 2013 9:36 AM | Last Reply Uri Dimant - Sunday, June 30, 2013 6:33 AM -
Unanswered0Votes
Login failed for user
In one of my vb.net application i am getting error as "Login failed for user 'user'." But the user has full permission(sysadmin). Also this error does not come always.(So ...6 Replies | 220 Views | IT researcher - Friday, June 28, 2013 1:50 PM | Last Reply Shanky_621 - Saturday, June 29, 2013 6:28 AM -
Answered1Votes
what processing is causing this message in my log file?
My sql server 2005 log file is report the following message every 5 minutes: "Sql Server blocked access to procedure 'sys.xp_cmdshell' of component ...7 Replies | 178 Views | tarbell - Friday, June 28, 2013 4:36 PM | Last Reply Shanky_621 - Saturday, June 29, 2013 4:12 AM -
Unanswered0Votes
Setting up SQL Server Endpoint
Hi all, I've a named instance configured to listen on static TCP ports: 5001, 5002. I've created an endpoint in order to identify and monitor access to ...7 Replies | 210 Views | guestMS - Thursday, June 27, 2013 3:50 PM | Last Reply Erland Sommarskog - Friday, June 28, 2013 9:10 PM -
Proposed0Votes
SSL 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 ...3 Replies | 415 Views | donsjones - Thursday, May 30, 2013 5:36 PM | Last Reply donsjones - Friday, June 28, 2013 6:38 PM -
Answered1Votes
'Enforce password policy' does not check for password complexity when editing the properties of a login
I tried creating a login called 'test' and password 'test', with option 'enforce password policy' checked. The login creation fails because the password does not meet complexity which is ...1 Replies | 146 Views | Satya Krishna - Friday, June 28, 2013 6:14 PM | Last Reply Tom Phillips - Friday, June 28, 2013 6:32 PM -
Proposed0Votes
Identify 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 ...13 Replies | 398 Views | Stephanie Lv - Monday, June 17, 2013 8:26 AM | Last Reply SQLWork - Friday, June 28, 2013 12:22 PM - Items 1 to 20 of 6264 Next ›
.png)
