Browse by Tags
All Tags »
sql express (RSS)
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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 for
Read More...
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 install
Read More...
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
Read More...
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 suggests the
Read More...
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...
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...
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 Fast"
Read More...
See this VIdeo_blog by Linchi Shea in AskaSQLGuru website, very useful for the newbie DBAs.
Read More...
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
Read More...
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 are stored
Read More...
I have been pestered by the Developers asking about feature of Page Numbering in Reporting Services. So far there is not direct way to accomplish this, because reports are not physically paginated until you use print preview (or export to a physical page
Read More...