Browse by Tags

• access
• analysis
• binary
• computing
• cpu
• data
• database
• disks
• dmv
• enhancement
• enterprise manager
• error
• field
• full-text
• Hardware
• high availability
• Integration
• kba
• login
• Maintenance
• management
• memory
• named pipes
• not found
• password
• performance
• plan
• property
• query tunning
• question
• reading execution plan
• remote
• replication
• security
• services
• sql express
• SQL Tools
• sqlsmo
• ssas
• ssis
• ssma
• ssrs
• string
• surface
• table
• tcp
• transactional
• truncated
• tsql
• tuning
• users
• webcast
• x64

• 2008: Error List in 2008

  Ok, so I was looking around for a blurb about plan guides for my anti ad hoc SQL section of my book (ok, maybe not completely anti- but that isn't the point,) when I found this blog: http://geekswithblogs.net/Sreeblog/articles/117576.aspx that basically Read More... Posted Thursday, March 06, 2008 1:40 PM from Louis Davidson | (Comments Off) Filed under: SQL Server, SSMS, SQL Tools

• 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"

  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: Read More... Posted Friday, August 24, 2007 6:17 AM from SSQA.net | (Comments Off) Filed under: SQL Server, SSMS, table, kba, data, binary, truncated, string

• 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

  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 Read More... Posted Friday, August 24, 2007 6:15 AM from SSQA.net | (Comments Off) Filed under: SQL Server, Maintenance, Integration, SSMS, services, ssis, kba, plan

• 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)

  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. ------------------------------ Read More... Posted Wednesday, August 22, 2007 11:56 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, SSMS, error, login, property, ssma

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

  --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' Read More... Posted Wednesday, August 22, 2007 12:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Integration, SSMS, error, high availability, surface, not found

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

  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 Read More... Posted Friday, August 17, 2007 11:04 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, SSMS, memory, cpu, dmv, analysis, disks

• August - Webcast on Reading Execution Plan & Query Tunning

  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 Read More... Posted Thursday, August 16, 2007 8:43 PM from SSQA.net | (Comments Off) Filed under: SQL Server, SSMS, webcast, ssas, query tunning, reading execution plan, question

• Dust out few tasks to gain transactional replication performance in SQL 2005

  Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at Read More... Posted Thursday, August 16, 2007 7:20 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, Integration, SSMS, ssas, replication, transactional, tuning

• Error: Property MustChangePassword is not available for login

  If you have stumbled with the error "Error: Property MustChangePassword is not available for login.." or same as the picture show below: To solve the issue either you have to take out the "enforce password policy" using SA privileges or if you are the Read More... Posted Wednesday, August 08, 2007 12:50 AM from SSQA.net | (Comments Off) Filed under: SQL Server, SSMS, password, login, property, users, sqlsmo

• Whats with 64 bit computing on SQL Server

  What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage Read More... Posted Sunday, August 05, 2007 12:41 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, SSMS, x64, management, computing, ssis, ssrs, ssas

• An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

  Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could Read More... Posted Thursday, July 26, 2007 10:49 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, SSMS, tcp, sql express, error, access, named pipes, remote, management

• Full Text Search is installed, but not enabled to see at table-level

  It was long time ago I have used FULL-TEXT within our environment, recently I have been given a task to manage a full text SQL instance. Well to refresh my tasks I have installed Full Text Search component on Windows 2003 Server for SQL server 2000 instance. Read More... Posted Thursday, July 26, 2007 7:38 PM from SSQA.net | (Comments Off) Filed under: SQL Server, SSMS, sql express, database, enterprise manager, full-text

• TSQL to get FieldName & FieldDescription within a SQL Server database

  When you are documenting a database including the table-column information you need to have a description that can specify that so and so column is used for such a purpose. Think about accessing such information using Enterprise Manager or SS Management Read More... Posted Thursday, July 26, 2007 12:52 AM from SSQA.net | (Comments Off) Filed under: SQL Server, SSMS, tsql, enterprise manager, field, enhancement