Browse by Tags

All Tags » sql express (RSS)
Installation gotchas and guidelines - SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1
Published 1 September 8 3:2 AM | SSQA.net
You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage. No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present...
Filed under: , , , , , , , ,
SQL Server Express - get sample kits in express way
Published 30 June 8 3:30 AM | SSQA.net
For every new user in SQL Server world and experienced users to get used to newer version of SQL Server, having sample kit will definetly help out. In this scenario I often get emails asking about any samples or documentation (procedures) to get more...
Filed under: , , , , ,
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: , , , , ,
Vote now: Index defragmentation best practices for SQL Server 2005 documentation - feedback received from Microsoft
Published 4 January 8 5:35 PM | SSQA.net
May 25 2007- From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation...
Filed under: , , , , , , , ,
SQL Server 2005 Reporting Services best resource for beginners
Published 28 December 7 6:0 AM | SSQA.net
What I like within the SQL Server Reporting Services is using RDL for own formatted reports, as this gives you the complete freedom to build your own reporting designer tool, if you are not experienced in using Visual Studio based report designer or crystal...
Filed under: , , , , , , ,
SQL Server is waiting for an internal operation to complete, message on SQL Server Management Studio
Published 17 December 7 2:49 AM | SSQA.net
Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message " Microsoft SQL Server Management Studio is waiting...
Filed under: , , , , , , , ,
Unable to install SQL Server Express - Error SQL Server service failed to start?
Published 7 November 7 1:33 PM | SSQA.net
Imagine a simple installation of SQL Server Express 2005 edition fails with an error "SQL Server service failed to start?" Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default...
Filed under: , , , , , , , , ,
How to suppress SQLSTATE messages when executing scripts using SQLCMD?
Published 6 November 7 11:48 AM | SSQA.net
Say you are executing a scheduled job using a batch file and output is stored to a file, then in that output file you will see Warning messages such as SQLSTATE. So how to suppress these messages on the output file. Simply using -i option in SQLCMD as...
Filed under: , , , , , ,
SQL Server Express installation error: System Configuration Checker Fails with "Performance Monitor Counter Check Failed" Message
Published 13 September 7 10:31 AM | SSQA.net
While installing SQL Server Express 2005 you might have come across the error: System Configuration Checker Fails with "Performance Monitor Counter Check Failed" Message As you have seen that one of the README file for SQL 2005 installation...
Filed under: , , , , , , ,
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 ....)
Published 26 July 7 7:49 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
Full Text Search is installed, but not enabled to see at table-level
Published 26 July 7 4:38 AM | SSQA.net
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...
Filed under: , , , , ,
"Allow Indexing Service to index this disk for fast file searching"
Published 25 July 7 3:3 AM | SSQA.net
I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to "Find...
Filed under: , , , , , , , ,
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: , , , , , , , ,
Move SQL Server 2005 error log from its default location
Published 17 June 7 1:48 PM | SSQA.net
You might get this doubt "How do I move the default log files placed in: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG to a different location?" This may not be required all the times but say on the partition where these log files...
Filed under: , , , ,
SQL Server 2005 Books online May 2007 updates are available now
Published 11 June 7 3:22 AM | SSQA.net
Yet another update to SQL Server 2005 Books Online, though it states May 2007 update that was released on June 06th 2007! During February 2007 with the release of Service pack 2 Microsoft has updated the BOL content to reflect the changes with SP2. For...
Filed under: , , , , ,