SqlServer-QA.net

While I was scrolling through the logins for a permission task, I found the login name such as  ##MS_PolicyEventProcessingLogin## & ##MS_PolicySigningCertificate##, I was bit confused and perplexed to see what it is for? As usual searching in Books Online (2008) and on web doesn't get much information on this login properties, also this ...

Do you want to lockdown your SQL Server environment? Hope you dont'! Though it is not a good practice or recommendation to perform, but will atleast prove how far your SQL Server environment has securit compliance as per the industry best practices. Before we go to know how you can lockdown or know the steps, I would like to visit few leads on ...

I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall IT costs which is the priority for any Enterprise, but at the same time one ...

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled, the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL Server 2005, obviously SQLAgent is important part of SQL Server tasks that you need to schedule on ...

Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code.  In this regard we have blogged previously such as UpgradeTags posts. Here in this post I would like to go with few FAQs that are related to Upgrade process & procedure: Say you need to ...

Got a question via email asking to configure Transactional Replication between two servers with in SQL Server 2005. By all means I would like to refer this KBA http://support.microsoft.com/kb/321822 for replication between HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted Domains or Across the Internet. Also the ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications How to make unwanted access to SQL Server 2005 by an operating system administrator more ...

When I was installing SQL Server 2005 last weekend, one of the first things I wanted to find out was whether I could run SSRS 2000 and SSRS 2005 on the same computer. Nothing was carved on the Books Online stone for SQL 2005 or 2000 versions, but I presume it is possible to install/manage Reporting Services as a windows services. Further ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete FIX: The status of the shared schedule appears as Paused after you click Resume when you use Report Manager in SQL Server 2005 Reporting Services ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications How to use Kerberos authentication in SQL Serverhttp://support.microsoft.com/kb/319723/en-US