Microsoft Blog Images
Browse by Tags
Data access tech blogs
Database Engine videos
Analysis services videos
Reporting services videos
Integration services videos
Data access tech Videos
Email Blog Author
RSS for posts
RSS for comments
Search this blog
Search all blogs
SQL query plan
SQL Server 2000
SQL Server 2005
sql Server 2008
SQL Server 2008 R2
Microsoft SQL Server Tips & Tricks
Browse by Tags
Virtual Address Space
Your SQL Server Setup may hang forever when it’s almost at the 99 %!
Consider this scenario, I rebooted several times, disabling my favourite antivirus and still unable to get a clue from all the logs possible. I start looking at my favourite blogs and here I am. Check out if your symptoms match the following. “ I am installing SQL Server including reporting services...
21 Oct 2011
SQL Server could not create a subscription for Subscriber 'Servername\InstanceName'.The value for the @sync_method parameter is not valid
Recently we worked on a support case where creation of a Subscription was failing with the following error:- TITLE: New Subscription Wizard ------------------------------ SQL Server could not create a subscription for Subscriber 'Servername\InstanceName'. ------------------------------ ADDITIONAL INFORMATION...
13 Oct 2011
Upgrade to SQL 2008 from 2005 (cluster) fails with The cluster group 'SQL GROUP' could not be moved from node 'NODENAME1' to node 'null' , 0x8007139F
Problem We try to upgrade to SQL 2008 from SQL 2005 in a cluster setup and it fails on the Active node with the following error: From the Summary.txt There was an error during the SQL Server upgrade operation. Setup failed to move the failover cluster resource group and bring it online. To...
16 Sep 2010
INF: SQL Security - Restricting access to public on server/database objects, its implications and ownership chains
INF: SQL Security - Restricting access to public on server/database objects, its implications and ownership chains There are times when you need to harden the security of your SQL Server and prevent the public/guest users from having access to certain information like server or database level management...
31 Aug 2010
Configuring Database Mail failing with error - @no_credential_change is not a parameter for procedure sysmail_update_account_sp. (Microsoft SQL Server, Error: 8145)
Recently we have encountered the following error message while configuring Database Mail in SQL server 2005. Create new account 'XXXX' for SMTP server 'XXXX' (Error) Messages Unable to update account XXXX for SMTP server Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer. ----...
23 Mar 2010
Database Mail failing with “The service queue "ExternalMailQueue" is currently disabled.” message
Some of you may experience problems while using Database Mail on SQL Server 2005 or SQL Server 2008 which will not be able to send emails to the database users. The SQL Server error logs will log following errors: The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue...
18 Mar 2010
How to find who is using / eating up the Virtual Address Space on your SQL Server
Well, this is often a tricky situation, where you are running into Virtual Address Fragmentation and getting OOM (out-of-memory) errors in your SQL Server. More often than not there is confusion between physical memory pressure vs. virtual memory pressure. Adding more RAM is definitely not a solution...
16 Feb 2010
SQL FTS IFilters, its security implications and troubleshooting PDF Filter issues
Today I am going to talk about FTS IFilters, its security considerations and some basics on troubleshooting issues with PDF Filters. Read on and be enlightened… What is a Word-Breaker? It is a component within the FTEngine that’s responsible to perform linguistic analysis of the data. In other...
11 Feb 2010
HOW TO TERMINATE SQL JOBS AFTER CUT-OFF PERIOD
NOTE: This method should not be attempted on the following jobs: Ø Reindex Ø Update Statistics Ø Replication Ø Backup How many times have we encountered a SQL job which runs for a long time (more than expected) only to error out or even worse hang! There is no automated...
3 Nov 2009
HOW TO DETECT SQL SERVER INSTANCES / FEATURES INSTALLED ON A MACHINE
Have you ever wondered if there is a programmatic way to detect all the SQL server instances and services installed on a machine. Well, worry no more as the code below will do exactly that. There are 2 ways to go about this : Method 1 – For the Programmer The code below is written in C#. 1) ...
7 Mar 2009
Page 1 of 1 (10 items)
© 2013 Microsoft Corporation.
Privacy & Cookies