Dear,
How can I make a SQL Server able to send me an email alert if its SQL Server
Service and/or SQL Server Agent Service is down automatically ?
SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they can

full text indexing
Hi,
In SQL Server 2005, if I set full text indexing enables in column MyDesc and
1. use “Select * from MyTable where MyDesc LIKE ‘%abc%’” would this be using

I am using Microsoft SQL server 2005. I want to move a large set of
data with a specific condition to other database in the same machine.
for example after a period of time I want to archive data by the
condtion of time ( in a specific year ) to other database. that

i have a MDF sql server express database used by an asp.net application.
I would like to integrate it into Sql Server express.
In Studio Management, i rightclicked on Databases and i took 'Attach'. Now i
can see and manage that database from Studio Management, but it still refers

When i look at the properties of the Clustered Index Scan Operator in
execution plan, it states that ordered = False..What does that mean ? I
thought a clustered index is always ordered.
On a side note, where can i learn more about the other properties and also

I have a new database that was created by importing data from a flat
file.  It was successfully created and reviewed in the SQL 2005
Database Manager utility.  But I cannot seem to access the Tables it
from Microsoft Access.  Does Microsoft Access not support SQL

Anyone know where SSIS is?  I installed the SQL Server 2005 evaluation
and found several app folders, and SSBID, but no SSID.
It took a bit of research to find and install DTS and I finally
imported a flat file of 500+ fields to begin normalizing, but I don't

A program that i am trying to install requires MS SQL Server 2005 to be
installed in order for it to run and automatically runs the MS SQL
installation process during software install, whilst it attempts to install
MS SQL i get an error message saying:

We are getting the following error while opening a database.
Msg 946, Level 14, State 1, Line 1
Cannot open database 'ESPune' version 539. Upgrade the database to the
latest version.

Which service pack do I install for sql 2000 client tool
Thanks

Are there any compatability issues with SQL Server 2000 Enterprise edition
and Server 2003 standard with SP2?

On either SQL 2000 or SQL 2005, do you have to reinstall a service pack
whenever you create a new database?  Or, does the new database "contain" the
service pack already upon the database's creation?
Thanks!

I have an **urgent** need to pass chinese characters into an SQL Server
Express table using a stored procedure. The MSDN documentation informs me
that everything will work 'automatically' if I use NVARCHAR parameters but
all I am getting is question marks. I've found old threads ...

I have just recently experienced a very strange problem when trying to
use the SQL Server Management Studio on SQL Server 2005.
I had installed (some months ago) a copy of SQL Server 2005 Developer
Edition on a Windows Vista Home Premium OS, and also installed the

Question on what SQL Versions are available: We don't need a full SQL server
or need all the tools that come with a full version.
What economical (light weight) or free alternatives, if any, are available?