Browse by Tags

KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues

Published 12 June 8 10:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New SQL Server 2005 installers...

Filed under: sql server, instance, kba, installation, 2000, 2005, msde

SQL Server High Number of User Connections found on PERFMON, how to resolve it?

Published 3 June 8 3:7 AM | SSQA.net

I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as...

Filed under: sql server, performance, sysmon, 2000, 2005, high cpu, perflib, activity, user connections, mars

SQL Server Locking

Published 18 May 8 2:30 AM | SSQA.net

Locking is a mechanism used by the Microsoft SQL Server Database Engine to synchronize access by multiple users to the same piece of data at the same time. Before a transaction acquires a dependency on the current state of a piece of data, such as by...

Filed under: sql server, 2000, 2005

SQL Server and Windows Memory

Published 15 May 8 9:2 AM | SSQA.net

SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve...

Filed under: sql server, memory, windows, 2000, 2005, 32-bit

A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000

Published 12 May 8 1:43 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications A query that references a nondeterministic...

Filed under: sql server, performance, query, kba, 2000, 2005, slow

End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?

Published 8 April 8 2:2 AM | SSQA.net

The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement...

Filed under: sql server, sp2, support, lifecycle, 2000, 2005, service pack, css, case, mainstream, extended

Error while executing DMV - Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.

Published 17 March 8 4:39 AM | SSQA.net

DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the...

Filed under: sql server, blocking, dmv, version, 2000, pack, 2005, tsql, errorr, tablels, incorrect syntax

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.

Published 7 March 8 4:54 AM | SSQA.net

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently...

Filed under: sql server, performance, memory, dmv, windows, 2000, 2005, awe, 64 bit, monitoring, worker threads, paging out, buffers, verison

The SQL server specified in SSIS service configuration is not present or is not available. This might occur where there is no default instance of SQL Server on the computer

Published 3 March 8 2:2 AM | SSQA.net

Multiple versions of SQL Server installation is quite common when your enterprise is looking forward to upgrade to latest versions of SQL Server, in this regard recently one of the Application user reported a problem with regard to SSIS & DTS services...

Filed under: sql server, ssis, ssms, blog, service, 2000, 2005, integration services, packages, disabled

SQL Server consolidation and virtualization - hot topic in the industry

Published 12 February 8 5:35 AM | SSQA.net

I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall...

Filed under: sql server, microsoft, security, environment, sa, 2000, 2005, virtual server, vmware, operating system, windows server, benefit, costing

SQL Server 2005 debug a stored procedure, how-to?

Published 11 February 8 3:38 AM | SSQA.net

If you are Developer then debugging your own code is an usual practice and when you got used to perform the same on SQL Server 2000 version, it is not an easy way in SQL Server 2005 version. As you may be aware that SQL Server 2000 engine includes a debugger...

Filed under: sql server, 2000, connect, 2005, stored procedure, visual studio, debug

Are you ready for SQL Server 2005 Service Pack 3?

Published 5 February 8 5:0 AM | SSQA.net

Postponement of SQL Server 2008 release has become old news now and within the SQL Server community (especially MVPs) there has been a state of commotion in demanding Service Pack3 for SQL Server 2005 version, true its the time isn't it! Coming to...

Filed under: sql server, release, 2008, support, lifecycle, 2000, 2005, cumulative update

SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

Published 16 January 8 1:40 AM | SSQA.net

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual...

Filed under: sql server, microsoft, error, kba, 2000, error log, 2005, stored procedure, linked server, aspfaq, issues

Heroes Happen Here - SQL Server 2008, Windows Server 2008 and Visual Studio 2008 launch events

Published 11 January 8 2:38 PM | SSQA.net

ITS Party time!!! Well I'm joking, its not a full-party time. 2008 entered already that kicks Microsoft gearing up for worldwide events, important ones. Release of Visual Studio 2008, Windows Server 2008 and SQL Server 2008!!! This brings most of...

Filed under: sql server, microsoft, download, 2008, 2000, 2005, public, visual studio, events, february, launch, windows server

Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

Published 16 November 7 4:53 AM | SSQA.net

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...

Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins

FIX: Some events are not logged correctly when you enable SQL Server event forwarding on a SQL Server Agent of SQL Server 2000 to forward events to SQL Server 2005

Published 1 November 7 10:13 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: Some events are not logged correctly when you enable SQL Server event forwarding...

Filed under: sql server, kba, 2000, 2005, events, sql server agent, forward

Using Management Studio unable to select "create one file per object"?

Published 17 October 7 4:6 AM | SSQA.net

One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects...

Filed under: sql server, ssms, script, 2000, service pack2, 2005, management studio, enterprise manager, generate

How to run Reporting Services 2000 and 2005 on the same server?

Published 8 October 7 3:45 PM | SSQA.net

When I was installing SQL Server 2005 last weekend, one of the first things I wanted to find out was whether I could run SSRS 2000 and SSRS 2005 on the same computer. Nothing was carved on the Books Online stone for SQL 2005 or 2000 versions, but I presume...

Filed under: sql server, report builder, sa, 2000, 2005, repoting services, configuration, setup, rsconfig

SQL Server Virtual Labs - fully featured virtual environment for testing!

Published 5 October 7 11:4 AM | SSQA.net

Virtual labs - in simple words its simple to use where a pre-installed environment is setup to try out /test SQL Server installation for your databses upgrade, that has full-featured labs. Not only this you have an option to download manual with a 90...

Filed under: sql server, microsoft, technet, database, download, upgrade, virtual labs, 2000, 2005

SQL Server 2000 and SQL Server 2005 support for mounted volumes

Published 5 October 7 7:30 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications SQL Server 2000 and SQL Server 2005 support...

Filed under: sql server, kba, standard, 2000, storage, clustering, 2005, mounted, volume