Sign In
Karthick PK 's Blog
Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security.
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
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
January, 2009
MSDN Blogs
>
Karthick PK 's Blog
>
January, 2009
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Karthick PK 's Blog
Kerberos Authentication in SQLServer
Posted
over 3 years ago
by
Karthick P.K - karthick krishnamurthy
1
Comments
There are two authentication scheme which can be used by SQLserver when connecting to SQLserver using TCP/IP Protocol and windows authentication. 1. NTLM 2. Kerberos When we use Kerberos we get ability to delegate a principal's identity and it...
Karthick PK 's Blog
Behavior of SQL Server default instance on a NON-Default port
Posted
over 3 years ago
by
Karthick P.K - karthick krishnamurthy
1
Comments
Unable to connect to SQLServer listening on Non-Default Port? If you connect to SQLServer using the "hostname" it connects to the instance which is listening on 1433. If you make named instance listen on 1433 and connect using "hostname" it connects...
Karthick PK 's Blog
Queries with table variables are slow in SQL2005 compared with SQL2000 (Table Variables (VS) Temp Tables)
Posted
over 3 years ago
by
Karthick P.K - karthick krishnamurthy
2
Comments
Table Variables (VS) Temp Tables SQLServer2005 caches temp tables and temp variables only under some conditions. Scenarios where temp table/variable are not cached (see below) may cause performance degradation as compared to SQLServer2000. Following...
Karthick PK 's Blog
How to Browse (or) view objects and there code in mssqlsystemresource Database
Posted
over 3 years ago
by
Karthick P.K - karthick krishnamurthy
2
Comments
How to Browse (or) view mssqlsystemresource Database. 1. Stop the SQL Server service Copy the mssqlsystemresource.MDF and mssqlsystemresource.LDF to a new path (This two files will be in same path where master databse is located). Start the SQL Server...
Karthick PK 's Blog
How to enable Constraint delegation for SQLServer2005
Posted
over 3 years ago
by
Karthick P.K - karthick krishnamurthy
0
Comments
Constraint delegation for SQLServer2005 Follow the below steps to set the constraint delegation for SQLServer2005 1. In active directory users and computers for the startup account of SQLServer a.Select "Trust this user for delegation to specified...
Karthick PK 's Blog
Unable to start SQLServer agent resource on cluster after upgrading to 9.00.3186 or Higher
Posted
over 3 years ago
by
Karthick P.K - karthick krishnamurthy
5
Comments
Error === 2008-03-19 23:06:23 - ? [100] Microsoft SQLServerAgent version 9.00.3186.00 (x86 unicode retail build) : Process ID 2428 2008-03-19 23:06:23 - ? [101] SQL Server SNETNAME version 9.00.3186 (0 connection limit) 2008-03-19 23:06:23 - ? [102...
Karthick PK 's Blog
Unable to open SQL2000 DTS packages in SQLserver2008 SSMS/BIDS 2008
Posted
over 3 years ago
by
Karthick P.K - karthick krishnamurthy
7
Comments
Problem ======= When we open a SQL2000 DTS package in SQL2008 SSMS/BIDS It fails with below error. Error: -------- SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer...
Page 1 of 1 (7 items)