I was trying to verify that one cannot directly upgrade from MSDE to SQL 2005
Standard.  Is this correct?  If so what would the proper path be?
Thanks,
Brian

I'm trying to build a select statement using the CASE expression. All
I want is to build the WHERE piece of the select statement based on a
parameter value.
I want to somehow CASE the WHERE clause based on a parameter of let's

Ok, this is dumb. How do I get the total number of records in an SQL table.
I know I've done this before, but the mind is mush.
Thanks.

How can I determine when the status of a mirrored database on a server
changes from Principal to Mirrored?
Also, can I determine who or what caused the status to change?

sql server 2000 sp4
Hi
I have a database that was initially created for 70MB. It has a application
associated with it and can not be deleted. I need to increase size of the

I want to implement clustered indexes on some tables and have a couple of
questions.  I read that a clustered index has its columns shared with
non-clustered indexes by default.  Does that mean I can remove the columns
found in the clustered index from the non-clustered indexes?

I'm trying to give my users the ability to run sp_who2 on SQL 2005 and
see all sessions, without granting them additional permissions.  I
thought I could do something like this:
CREATE PROCEDURE [dbo].[sp_who2_all]

Good Day,
We have a SQL 2000 and we are planning on upgrading to SQL 2005.  Our
current copy of SQL is installed on the C drive of the server but do to size
restraints on the C drive and other issues  I am looking at doing a side by

SQL server 2000
Hi
How can i find
1. Information about all/current  backup files, size of backup file on

I am working with Access frontends and a SQL Server 2000 backend.
One user gets the following error when trying to insert directly into
a table through access or through a form into that same table: "String
or binary data would be truncated". It doesn't matter into which type

I have a stored procedure1 calling stored procedure 2. Stored
procedure 2 when it is finished returns a single row with 2 columns.
Is there a way to grab the return of column 1 from stored procedure 2
inside stored procedure 1?

I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?

i have added a linked server (Linkser)having sybase db in mssql server.i
added a
procedure for getting data from Linkser
SET ANSI_NULLS ON

I need to restore a backup of a db in SQL 2005 with 80-compatibility level
into SQL Server 2000. I have tried to do it but I have an error. Is it
possible to do it?
Does exist another fast method to bring a SQL Server 2005 db into 2000?

I want to retrive the licensing information such as Licensing count, which
licensing is currently in use, whats its type (per processer or per user),
licensing code etc. From where i can retrive the information? I want to do it
for Sql Server 2005 and 2000. I read the blog ...