Doubt on SQL serverv 2012 installation - social.msdn.microsoft.com
Oct 12, 2021 · Reporting Services – Native, SQL Server Data Tools and Client Tools Connectivity. If you configure the SharePoint mode in SSRS Server, then you need to install Reporting Services – …
Can we create index on msdb database for backupset objects
Oct 24, 2013 · I am using sql server 2008 with sp3. I want to confirm whether we can create index on msdb database for backupset objects or not. what is the purpose of this ???
Permissions within SQL Server Agent jobs - social.msdn.microsoft.com
Oct 24, 2011 · For SQL Server Agent Service account, it is recommended to give it the least amount of privileges. You cannot create a SQL Server Agent proxy to execute the job because for T-SQL job …
Data Structures in SQL Server - social.msdn.microsoft.com
Dec 31, 2014 · I am giving a session on "Data structures and SQL Server" for one of the SQL Server communities in India.
SSMS permissions vs Db permissions - social.msdn.microsoft.com
Sep 23, 2009 · Btw, I am using SSMS 2008 on a SS2008 Db. Interestinly, when I access FinanceDev Db, via VS2008 using FinDevUser SQL Server login, I can create a data connection AND it shows …
SQL Server service stopped, cannot restart
Nov 14, 2017 · 2008-12-27 11:28:22.23 Server Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated …
.NET SQL CE Core - Not enough storage is available to complete this ...
Jul 4, 2011 · As the question is related to the use of SQL Server CE, i am wandering about a move of this thread towards the SQL Server Compact forum , especially after the Jeff remark about " …
Login is valid, but server access failed. Windows App can't login ...
Oct 27, 2010 · So, the Windows Group gets a "login" in SQL Server. The Windows Group "login" gets access to each necessary database as a database "user". Permissions in the database are normally …
Transactional Replication with Queued updating..
May 13, 2013 · I have setup the transitional replication Push with Immediate update mode , and now it failed because subscriber rebooted and now data was out of sync . Snapshot was not available so to …
Plz Help - Day to day tasks of a mssql DBA
Sep 22, 2009 · I've been doing SQL Server DBA work for quite a number of years. All the posts so far have very valid points regarding maintaining a SQL Server environment. I suppose the key would be …