5
2012
T-SQL to find Physical and Logical Processors (CPU)
Today while searching for t-sql scripts to collect Physical and Logical CPU count for around 100+ SQL servers (all version SQL 2000, 2005 and 2008 R2) came across following articles and the useful scripts, read below for more details, The basic limitation behing finding physical CPU count is you can’t find directly using t-sql in SQL Server 2000, from SQL 2005 onwards you can easily find it using DMV sys.dm_os_sys_info Script provided at following links, […]
25
2012
Working with bit locker in Windows Vista/7
Today my hard drive went corrupt, when I tried to attach it via external HD case then it asked for bit locker key, so after search I found that starting with Windows Vista MS has built-in drive encryption feature called bitlocker, now to identify key I did following, Source: BitLocker Drives Unlocker [AddictiveTips Apps] If you use BitLocker Drive Encryption to encrypt and secure multiple local drives in Windows 7, you will be frustrated by […]
25
2011
[241] Startup error: Unable to initialize error reporting system (reason: Access is denied)
In SQL Server 2000, while updating SQL agent account to run under Domain account, recieved following error, (SQL services started successfully but agent gave error), 2011-12-xx 19:17:15 – ! [241] Startup error: Unable to initialize error reporting system (reason: Access is denied) 2011-12-xx 19:17:15 – ? [098] SQLServerAgent terminated (normally) On search found following useful article link which helped in fixing the issue, I followed following steps to resolve it, As per article, this issue […]
23
2011
Msg 911, Level 16, State 1, Line 3 – Could not locate entry in sysdatabases for database ‘MASTER’
While creating SQL login on SQL Server 2005 via following t-sql script, SET NOCOUNT ON USE MASTER CREATE LOGIN [test] WITH PASSWORD=N’test@123′, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE MASTER CREATE USER [test] WITH DEFAULT_SCHEMA = dbo exec sp_addrolemember N’db_datareader’, N’test’ GO SET NOCOUNT OFF faced below error, Msg 911, Level 16, State 1, Line 3 Could not locate entry in sysdatabases for database ‘MASTER’. No entry found with that name. Make sure that the name […]
23
2011
Script to create SQL login and assign read privileges on master and msdb database for automation purpose
Today got a task to create a common account across all SQL servers which have read privileges on master and msdb database, so to carry out this activity, wrote a small script as follows for SQL 2000 and SQL 2005/2008, Note: Replace test with your account name and password as your desired password Script for SQL 2005/2008, SET NOCOUNT ON USE MASTER CREATE LOGIN [test] WITH PASSWORD=N’test@123′, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE MASTER CREATE […]
20
2011
SQL Server 2005 is inaccessible remotely – error:26-Error locating server
Today while working with one Veritas cluster server, faced following error (one of the common error – error:26), There are few basic troubleshooting steps a normal DBA follow, 1. Under ‘SQL Server Surface Area configuration manager’, go to ‘Surface Area configuration for services and connections’, go to ‘Server instance’ > ‘Database Engine’ > ‘Remote connections’ 2. In remote connections, first and foremost, your ‘local and remote connections’ should be enabled in case you would like […]
15
2011
How do I check SQL replication status via T-SQL?
While searching for t-sql script which can check replication agent status came across a good script which works well for all versions of SQL Server i.e. 2000/2005/2008/2008R2 and above…
30
2011
T-SQL Script to check SQL Server up time and SQL agent status
While searching for a script which can help in checking SQL server up time and SQL server agent status, came across following good article by Vidhya Sagar…
18
2011
Installing tdp v5.5.1 on SQL Server 2000
Today after installing TDP for SQL server v5.5.1 on one server, we found TDP GUI is not opening up, also there are no clear instructions for SQL server 2000, after initial troubleshooting we figured out additional configuring that needs to be done for configuring TDP on SQL server 2000, Analysis: After installing TDP, TDP GUI will not open and if you execute batch script for backups then you will receive following error, It reflects that […]
16
2011
Issues with SQL Server Login Failures having dependency on Windows Password Policy Check!
Today users reported unique accessibility issues where all SQL logins are found locked out in all SQL servers (2005, 2008) where Windows enforce password policy is enabled, on further investigation it was found for each SQL login there are more than 20 failed attempts in SQL server error log. It took lot of effort in finding a root cause as on first attept it looked like a SQl server virus injection, but later found that […]
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5