Sign In
Karthick PK 's Blog
Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security.
Options
Blog Home
Email Blog Author
Share this
RSS for posts
Atom
RSS for comments
Search Blogs
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Check statement aborted
Checkdb
Configuration error description: The registry key SYSTEM\CurrentControlSet\Services\RsFx0102\InstancesShares is missing
CryptUnprotectData() returned error -2146893813
database or table could not be locked
database snapshot
Deadlocked Schedulers
Delay starting SQLAgent
Editing DTS package in SQLserver2008
Engine
How to enable Constraint delegation for SQLServer2005
InstancesShares is missing
ISAlive failure
Kerberos authentication
'Key not valid for use in specified state -Any build greater than 9.00.3186
mssqlsystemresource
Non default port
Optimizer
SQLServer Agent missing
SQLServer Browser
SQLServer Cluster
SQLServer Resource not comming online
SQLServer Status
SQLServer2008 Setup
SSMS
Archive
Archives
April 2012
(1)
February 2012
(1)
September 2011
(1)
August 2011
(1)
March 2011
(1)
November 2010
(3)
October 2010
(1)
June 2010
(2)
March 2010
(1)
August 2009
(2)
May 2009
(1)
April 2009
(3)
March 2009
(4)
February 2009
(1)
January 2009
(7)
Visitors map
Visitors from 16th Jan 2012
Blog - Link List
My site
MSSQLWIKI
List of blogs
MSDN Blogs
>
Karthick PK 's Blog
>
List of blogs
List of blogs
Karthick P.K - karthick krishnamurthy
22 Sep 2011 9:08 PM
Comments
0
My “c:\” Drive gets full when I open the profiler trace
System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host Intrusion Prevention
Beyond XP_READERRORLOG (parameters of XP_readerrorlog)
A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_PowerShell_Engine_CNS,SQL_PowerShell_Tools_ANS]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed.
Script to free cache
How to find SQL Server and system CPU usage history :
The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run.Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive
Script to get current blocking tree with wait types
SQLServer2008: Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16
SQLServer 2008 Fails to come online on cluster after upgrade
I get error while I update a row in immediate updating subscription what is the cause?
Tasks and connection icons missing after importing DTS in SQL Server management studio
Runtime error: ActiveX component can’t create object: ‘SQLDMO.SQLServer’
I get Exception when i open SQL Server management studio
Using DMVs to find out the index usage history- SQL Server Index Usage
I cant not backup my database from SSMS….
We do not see the SQL server and SQL Agent status from management studio. When we right click the instance, start, stop and resume options is disabled.
How to Analyze “Deadlocked Schedulers” Dumps?
Configuring SSL for SQL Server using Microsoft Certificate Authority Server
“Value cannot be null” when i connect SQL Server from SSMS
How to find all the profiler traces running on my SQL Server
DBCC CheckDB fails with error “The database could not be checked as a database snapshot could not be created and the database or table could not be locked
How to get SQL Text and Query Plan for statements which are executing now
Script to clear stats
How to monitor the Session and query which Consumes Tempdb
Trivial Plan
How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running.
Different Status bits of sysdatabases in SQLServer
Installation of SQLServer2008 fails (The registry key SYSTEM\CurrentControlSet\Services\RsFx0102\InstancesShares is missing)
Installation of SQLserver2008 cluster fails on windows2008.(The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)
Installation of SQLServer2005/2008 Fails on Windows2008 Cluster.
Using DMVs to find out the index usage history- SQLServer Index Usage
Script to get all the Query and cached plans
How to find who altered my SQL Server Login
How to Browse (or) view objects and there code in mssqlsystemresource Database
Queries with table variables are slow in SQL2005 compared with SQL2000 (Table Variables (VS) Temp Tables)
Behavior of SQL Server default instance on a NON-Default port
Unable to start SQLServer agent resource on cluster after upgrading to 9.00.3186 or Higher
How to enable Constraint delegation for SQLServer2005
0 Comments
Comments
Leave a Comment
Name
Comment
Please add 5 and 7 and type the answer here:
Post