July 2007 - Posts
Interesting post in MSDN forums on the error: SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'mydomain\myusername', error code 0x54b. [SQLSTATE 42000]
Read More...
What to do when you get the error specified on the subject above? You might get this error message from a job which will send email to an operator when it is completed. First thing to check whether a valid email has been mentioned in the operator. Also
Read More...
Normally I wouldn't do much development using Reporting Services, but lately I was trying to play with it to get a flashy type of report for a monitoring information on set of SQL Servers we manage. In this scenario I have developed a report that works
Read More...
Say you have multiple instances of SQL Server and on mixed platforms such as 32 bit and X64 bit platforms, so how do you find which version of SQL you have installed. If you are well versed with the environment then by looking at the servernames you can
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...
Yes it does! Until yesterday even I was under impression that it will not use or cause any issues to the server. But think about performing the SHRINK operation of transaction log & database files on regular basis, say within a scheduled job or ongoing
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...
The Notification Services tutorial teaches you how to build a simple Notification Services application. The tutorial uses a SQL Server Management Studio solution to make it easy to edit tutorial files and then build the solution using SQL Server Management
Read More...
As you may be aware using SQL 2005 version you can set PASSWORD EXPIRY policy that can apply the same complexity and expiration policies used in Windows Server 2003 operating system to passwords used inside SQL Server. This functionality depends on the
Read More...
Can somebody tell me, it is possible to convert a database developed in sql2005 back to sql2000? A common question now a days in the forums and newsgroups, as you are aware UPGRADE process is available to enhance SQL 2000 database to SQL 2005 as per the
Read More...
I have been asked many of our developers and even got through few questions asking about how to understand SQL Server Integration Services which is a traditional extract methods with a transform, and load (or ETL) model of integrating data from standard
Read More...
Have you ever gave a thought about writing a code within your development environment, I'm talking about writing TSQL scripts and not going for programming languages such as C# or ASP.net. So what is your favourite in this case: Look at this SQLBlog discussion,
Read More...
I have received a question via email asking for a solution, though solution is simple thought I can blog it. We have a simple linked server connection to import data from a provider.When querying a comma delimited file, why does sql server try to interpret
Read More...
No straight answer to say yes you need so and so value to set on TEMPDB for such space requriement. By default i t is difficult to estimate the tempdb space requirement for an application. In general and one of the best practice is to allow 20% more space
Read More...
It is a controversial question to ask in newsgroup saying which is the best one, in my experience both MySQL & MS SQL Server has got individual advantages and flexibility to cater the DBMS needs. MySQL vs MS SQL Server is the good compilation of this
Read More...
The date has passed for those who are enjoying the supprot stay with SQL Server service pack 3a, Global Release Services (GRS) team has ended the mainstream and extended support for the installations that are lesser than SP3a. SQLReleaseServices announced
Read More...
See this VIdeo_blog by Linchi Shea in AskaSQLGuru website, very useful for the newbie DBAs.
Read More...
Can we change the location of SQL agent error log file after the SQL Server program is installed? Yes, i n terms of configuring a specified number of SQL Server Agent error logs, this is not possible. The default number of log files for SQLAGent is 9
Read More...
As I have blogged previously that SQL2005BPA is out from CTP now. The BPA for SQL 2005 release in July 2007 is complete package that gathers data from Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations
Read More...
Comparing data and/or schema within your SQL Server environment is a common task when you have to port the data from Development to Production environment. To compare the schema (tables) between the 2 SQL instances is very easy and you can accomplish
Read More...
YOu may be aware that when you deploy the Reporting Services it uses two SQL Server relational databases for internal storage. By default, the databases are named ReportServer and ReportServerTempdb. They are classed as system databases for Reporting
Read More...
Question> Is it possible to restore all the databses from Enterrise Edition to Standard Edition in SQL Server? Answer> Yes and No! Yes is you can restore user databases ( only ) from Standard Edition to Enterprise Edition and vice-versa for further
Read More...
Say you have a serious performance problem and few times you will have assertion issue with a dump files creation, in real world say this can be matched to a airplane crash. Where you will know the sequence of events from Black-box records in the flight
Read More...