Hi group
hope that you can help me...
Created a backup of a database from our Production server (x64 bit) and
moved the backup file to our develop (32 bit) server and restored it as the

Currently piloting SQL 2005 in Windows 2003 R2 which comes locked down. The
SCW (security configuration wizard) has to be used to open things up.
Quick question - does the SCW "know" about SQL 2005? Does the SCW cover the
typically surface area lock down that any SQL 2005 ...

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