Browse by Tags

SQL Server Heroes Unite Contest!

Published 7 August 8 6:5 PM | SSQA.net

PASS community connector email that I would like to share! Prove that you've got what it takes! Build the next generation of community applications on SQL Server 2008 in CodePlex: websites, enterprise suites, samples, gadget, tools, guidance, etc...

Filed under: sql server, pass, community, enterprise, applications, prize, code-plex

TechNet Webcast: SQL Server 2008 Performance and Scalability Technologies (Level 300)

Published 3 August 8 8:37 AM | SSQA.net

Event: SQL Server 2008 Performance and Scalability Technologies Level: 300 SQL Server 2008 supports very large databases, enterprise-scale reporting systems, and data warehouses. It provides growing database systems with tools and features to optimize...

Filed under: sql server, performance, webcast, enterprise, support, events, scalability

SQL Server 2008 - What's new for IT Pro community [UK Usergroup conference]

Published 9 April 8 10:28 AM | SSQA.net

In continuaton to UK User Group conference (2 day) in Microsoft Campus, Thames Valley Park Reading here is my presentation to download that was delivered on 09th April 2008. Appreciate your feedback....( read more ) Read More...

Filed under: sql server, community, 2008, enterprise, best practice, whatsnew, conference, usergroup, itpro

Snap-in failed to initialize, Name Microsoft SQL Enterprise Manager: CLSID : {00100100-1816-11D0-8EF5-00AA0062C58F}

Published 8 January 8 11:1 AM | SSQA.net

Few times I get such error Snap-in failed with a long CLSID string mentioned in the subject above. On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error: Snap-in failed to initialize Name...

Filed under: sql server, tools, enterprise, sql express, error log, management studio

You may receive an error message when a SQL Server 2005 client requests encryption and connects to 127.0.0.1 on a Windows XP-based computer

Published 20 November 7 3:9 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 and Major Modifications...

Filed under: sql server, kba, enterprise, encryption, client, x64, xp, 127.0.0.1

FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"

Published 23 August 7 6:25 AM | 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 and Major Modifications...

Filed under: sql server, kba, transaction, enterprise, x64, stored procedure, tsql

The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server 2000 or SQL Server 2005 database instance that hosts the BizTalk Server 2004 or BizTalk Server 2006 BizTalkMsgBoxDB database

Published 23 August 7 6:24 AM | SSQA.net

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

Filed under: sql server, database, kba, enterprise, x64, statistics, parallelism, biztalk, auto

More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.

Published 23 August 7 4:33 AM | SSQA.net

Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise...

Filed under: sql server, performance, memory, security, windows, edition, enterprise, instances, awe, pae, 3gb

Can't find linked server in management studio?

Published 28 June 7 9:41 AM | SSQA.net

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under...

Filed under: sql server, management, security, server, ssms, enterprise, sql express, oracle, linked

KBA: A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1

Published 27 June 7 11:48 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Reporting Services & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications A list of the bugs that have been fixed in SQL...

Filed under: sql server, kba, standard, enterprise, x64, sp1

FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005

Published 27 June 7 11:46 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: You may receive error 1203 when you run...

Filed under: sql server, kba, standard, edition, enterprise, x64, insert

Recently modified Knowledge Base Articles for SQL Server Enterprise Edition (32 & 64 bit)

Published 21 June 7 4:33 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released http://support.microsoft.com/kb/937137/en-US FIX: Error messages when you run...

Filed under: sql server, kba, standard, enterprise, x64

Performance and Scalability: SQL Server 2005 Enterprise Edition Benchmarks

Published 20 June 7 3:42 PM | SSQA.net

SQL Server 2005 achieved the #1 price/performance result for 3TB TPC-H non-clustered benchmark. This is a record breaking TPC-H three terabyte benchmark for a database running on Microsoft Windows and an HP Integrity rx8640 Server. The recent TPC-H benchmark...

Filed under: sql server, performance, microsoft, enterprise, tpc, market, study

Best way to generate DDL and data insert scripts

Published 11 June 7 8:53 AM | SSQA.net

There is no easy or best way, but few options are available such as DMO or SMO or even using Enterprise Manager for SQL 2000 or SS Management Studio for SQL 2005. Look for DBPublish wizard tool in this case that will help quite a bit and a lso you can...

Filed under: sql server, ssms, enterprise, smo, script, manager, dmo

FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections

Published 4 June 7 7:23 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections http://support.microsoft.com/kb...

Filed under: sql server, kba, enterprise, concurrent, connections