Browse by Tags

SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

Published 14 May 8 3:23 AM | SSQA.net

I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...

Filed under: sql server, performance, blogs, ssms, dba, dmf, best practice, new features, resource governor, policy based framework

SSWUG.ORG - SQL Server Virtual Conference II

Published 13 May 8 2:31 AM | SSQA.net

What are the Top 16 things to know about SQL Server? Here are a couple MORE from our series of 16 specific tips ( you can even still watch the previous release of tips too! )... Do you keep getting advanced level SQL Server information when you could...

Filed under: sql server, ssms, chat, conference, experts, virtual event, problems

The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005

Published 6 May 8 10:7 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, ssms, kba, import, management studio, export, identity key

Query Execution Plans security and new feature within SQL Server 2008 Management Studio

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

If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by...

Filed under: sql server, performance, ssms, query, users, execution plan, monitoring, new features, .xml, plan cache, document, .sqlplan

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 2008: Administer multiple servers by designating configuration servers

Published 27 February 8 3:0 AM | SSQA.net

Ok, they give you new tool and in next release it has been taken away! This is similar to Surface Area Configuration tool from SQL Server 2005 and after 3 years you don't see from next release which is SQL Server 2008. How do you manage or can administer...

Filed under: sql server, management, ssms, 2008, multiple, object explorer, configuration server

SQL Server Management Studio snap-in - get alerted when executing a TSQL code!

Published 15 February 8 4:26 AM | SSQA.net

Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...

Filed under: sql server, management, ssms, download, demo, alert, sample, tsql, code, toolkit, management studio, snap-in

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

SQL Server 2005 how to copy database maintenance plans between the servers?

Published 15 October 7 8:54 AM | SSQA.net

How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version. Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed...

Filed under: sql server, backup, ssis, ssms, maintenance plan, service pack2, management studio

Export SQL Servers registration using Management Studio?

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

If you are managing hundreds of SQL Server and you might have organised your Management Studio screen with relevant server groups under Server registration. In this case if a new starter has joined and required to assist you in monitoring all of the SQL...

Filed under: sql server, ssms, best practices, password, 2005, management studio, servers, export, registered

How to set the Animation Speed and make best use of SQL Server Management Studio tool?

Published 1 October 7 8:12 AM | SSQA.net

SQL Server Management Studio (SSMS) is a powerful tool in SQL 2005 that is re-written from previous of SQL Server, that also reduces the flaky features from Enterprise Manager. How to set the Animation Speed and make best use of SQL Server Management...

Filed under: sql server, performance, ssms, management studio, automation, loading, ie

How to read Database transaction log in SQL Server?

Published 27 September 7 7:13 PM | SSQA.net

Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,...

Filed under: sql server, ssms, tools, transaction log, dba, read, access, audit, log file, third party, resolution

OLAP Connectivity from Pivot Table in Excel - security permissions

Published 25 September 7 4:14 AM | SSQA.net

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database...

Filed under: sql server, security, ssas, ssms, olap, excel, pivot, execute, credentials

Whats the best way to setup memory on a four-node cluster?

Published 6 September 7 4:42 AM | SSQA.net

Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...

Filed under: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources

FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated"

Published 23 August 7 3:17 PM | SSQA.net

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

Filed under: sql server, data, ssms, kba, table, string, binary, truncated

On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

Published 23 August 7 3:15 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, integration, ssis, ssms, services, plan, kba, maintenance

Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Published 22 August 7 8:56 AM | SSQA.net

One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. --...

Filed under: sql server, security, ssms, error, login, property, ssma

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

Published 21 August 7 9:6 AM | SSQA.net

--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState...

Filed under: sql server, high availability, integration, security, ssms, error, surface, not found

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

Published 17 August 7 8:4 AM | SSQA.net

The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any...

Filed under: sql server, performance, memory, analysis, ssms, dmv, cpu, disks

August - Webcast on Reading Execution Plan & Query Tunning

Published 16 August 7 5:43 AM | SSQA.net

http://www.microsoft.com/india/webcasts/default.aspx Aug - 28th ; 14:00 - 15:30 IST SQL Server 2005: Reading Execution Plans The toughest part of analysis of any query is reading the execution plans. Many see this as the most difficult part, but this...

Filed under: sql server, webcast, ssas, ssms, question, query tunning, reading execution plan