Browsing articles in "Sql Server 2000"
Oct
25
2012

Microsoft SQL Server Build chart and links – all versions from 7.0 to 2012

If you are a DBA and you need to track the current release of SQL Server build then this link will come handy, use it at your wish as it’s not official page but a blog community page, http://sqlserverbuilds.blogspot.ca/ Excerpt as of writing this article, Quick summary:   RTM (Gold, no SP) SP1 SP2 SP3 SP4 SQL Server 2012codename Denali 11.00.2100.60 CTP       SQL Server 2008 R2codename Kilimanjaro 10.50.1600.1 10.50.2500 10.50.4000     […]

Jul
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 […]

Jun
29
2012

Changing SQL Server Collation / Rebuilding system databases

You may find yourself in situation where you need to change Server level collation or need to rebuild system databases, then following article will be helpful, 1. First detach all user databases 2. Script any logins (if exists) using sp_help_revlogin (get one from MSDN for e.g. http://support.microsoft.com/kb/246133 , http://support.microsoft.com/kb/918992 3. Script Maintenance plans/Jobs (if can’t be created again) 4. Execute following on command line by going to the folder where appropriate setup of SQL Server […]

May
1
2012

sqlstate = HYT00; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Timeout expired

Error in windows event logs: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Timeout expired  —————————- Suggestions from MSDN forum link: Reference link: http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/e5b8d938-e529-40f5-bdaa-601a8f6d7aca/ From the error it looks like there was issue with your network. Make sure you have a dedicated Heartbeat Network configured and that it is designated as such in Cluster Administrator. The public facing network can be configured for both Public […]

Apr
8
2012

Replication failure: Unable to start a DCOM Server

Error: Unable to start a DCOM Server: {08B0B2D9-3FB3-11D3-A4DE-00C04F610189}. The error: “The system cannot find the path specified. ” Happened while starting this command: C:\PROGRA~1\MICROS~3\80\COM\snapshot.exe -Embedding

Apr
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 […]

Mar
22
2012

Event ID: 57860 Source: Backup Exec Type Error Description: SQL error number: “4818”. SQL error message: “Login failed for user ‘domain\userid service account’.

While check Windows errors logs, came across these errors, solution is already provided by Symantec; basically this error is recieved when any type of backup is run by Backup exec agent on a server having Microsoft SQL Server installed. Details of issue are as below, Solution provided by Symantec at following link: http://www.symantec.com/business/support/index?page=content&id=TECH29539 Problem Event ID: 57860 “An error occurred while attempting to log in to the following server…SQL error number: “4818”. SQL error message: […]

Mar
14
2012

Managing and Optimizing Tempdb in SQL Server

We often come across situations where there is contention in tempdb or tempdb is getting oversized, etc. better planning of tempdb may avoid performance issues if it is being used heavily and also reduce administration effort, below article is basically focussed on the planning stage of tempdb to reduce administration effort and avoid performance issues, Source: http://support.microsoft.com/kb/328551, http://www.sqllion.com/2009/05/optimizing-tempdb-in-sql-server-2005/ Tempdb is one of the system database in SQL Server, all user data is lost from tempdb […]

Mar
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 […]

Mar
2
2012

ACO0156E Could not load the Tivoli Storage Manager API

After installing TDPv5.5.1 on SQL Server 2000 as per following link , TDP GUI should work fine, but in case you uninstall and reisnatll TDP client then you may start facing below issue while opening up TDP GUI, In addition to above, you may see other error as below, After researching in IBM documentation, found following link which provides information on this error, ACN0156E: Could not load the Tivoli Storage Manager API. Explanation The Tivoli […]

Pages:12»

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 25 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2017
M T W T F S S
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

View Post by Categories

%d bloggers like this: