2
2012
Configure SQL Mail on SQL Server 2000 with Outlook 2007 client
Scenario is, we have SQL 2000 as database engine and outlook 2007 as mail client, now as we know SQL 2000 requires MAPI client for SQL mail configuration and from records we need minimum Outlook 2000 client, in this case we have outlook 2007 client present. I was skeptical initially that whether SQL mail will at all work with outlook 2007 or not, by going through several articles and forums, I found it to be […]
4
2012
SQL Server 2000 – The subscription(s) have been marked inactive and must be reinitialized
Error: The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. Environment: SQL Server 2000 SP4 (valid for other SP versions as well) Replication Type: Transactional Replication with Publisher and Distributor on one server and Subscriber on another Scenario: You have created subscription to non-expire subscription as below, #img1# And still from time to time you see the subscriber marked inactive error and your […]
12
2012
Troubleshooting transactional replication timeout error in SQL Server 2000
Timeout error is mostly encountered in merge or transactional replication scenarios where data needs to be synced at regular time intervals, now sometimes due to network issue or bad data replication start failing with timeout errors, now to troubleshoot them follow below steps, Source: http://www.mssqlcity.com/Articles/Replic/troubleshooting_replication.htm and http://support.microsoft.com/kb/312292 First, when you encounter timeout error, go to distribution agent SQL job (in case of push subscription, agent job will be present on distributor server and in case […]
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 […]
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…
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 […]
27
2011
SQL Server Compatibility List (SCL) for Veritas Cluster Server 5.1 Service Pack 2 (SP2) for Windows
I was trying to find out which version of SQL Servers are supported by Veritas Cluster Services in order to prepare an upgrade plan, I got a useful link from Symantec site, it was last updated on 07-Feb-2011. Link: http://www.symantec.com/business/support/index?page=content&id=TECH142798 SQL Server Compatibilty in short, Software Compatibility List (SCL)Veritas Cluster Server 5.1 Service Pack 2 for Windows Microsoft Microsoft SQL Server 2000 SP4 S x86 Microsoft Microsoft SQL Server 2000 SP4 C IA64, x64 Microsoft […]
24
2011
Cluster resource ‘SQL Server ()’ in Resource Group ‘‘ failed!
While investigating a cluster resource offline issue, came across following three errors in windows system event log, cluster log and SQL error log respectively, Error message 1 Source: ClusSvc Category: Failover Mgr Type: Error Event ID: 1069 User: N/A Computer: < Computer Name > Description: Cluster resource ‘SQL Server ()’ in Resource Group ‘‘ failed. Error message 2 Error in the Cluster log file, SQL Server < SQLServer >: [sqsrvres] Unable to read the ‘VirtualServerName’ […]
6
2011
Identify which DTS package is being called by scheduled job!
I was struggling to identify the DTS package name from the job syntax which looks like, DTSRun /~Z0x5B431B25562BD74…2AE391DF759D0B3B09EEAB94B687E05E66CE7307C6304204 this can be simulated by right clicking the DTS Package (SQL 2000) and schedule a job. If you schedule a package to run that way, the SQL Job it creates will have an encrypted name for DTS package in SQL job step – similar to what you see above. Found a solution to this at following link […]
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 |
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