Hi, I posted a week ago in another group but can't find it now.
Since mid Feb, I've been asked almost daily to install the service pack
upgrade for all Microsoft SQL Server 2005 Express Edition instances and
components to Service Pack 3 (SP3).

I have a SQL Server Agent Operating system Job Step.
I am looking at the logging possibilities. It is possible to define an
Output file and also append the output to that file.
However I would like to have a new file for each execution with date and

We have an instance of SQL Server 2000 SP4 running on Windows Server 2003
SP2. We have been getting an error about Exception access violation. the
error reads:
Severity:  Critical Error

I'm trying to create  Crosstab query . Can you provide a starting point with
the syntax to ?
I have a table name Gasper2
The cols are 4

We were never requested anything to do with SQL Server reporting services
tool before but now we have a client that request some kind of reporting out
of SQL Server database using SQL Server 2008 Reporting services. We have
never even installed this tool since its pre-req was the ...

Trying to install the AdventureWorks sample database, I get this error
message:
------------
PrepInstance() failed for MSSQL$SQLEXPRESS.

I have several SQL2000/Win2003 and SQL2008/Win2008 boxes with MSDTC full
open (KB 329332), and everything works relatively well with one exception.
All the boxes are in the same domain except one, which is not in any domain.
I cannot get this non-domain SQL2000/Win2003 system to ...

I am doing an SQL database backup in server management express. When I right
click on the database
i go to tasks > backup. when i try to add a backup destination I don't see my
complete C: drive directory.

I am new to sql server and have to do an install on a new server running
server 2008. My question is what roles/features need to be installed on the
2008 server as part of the install.
Are there any other reqirments I should know about before I begin my installl.

In profiler 2005 when I use a filter I can check the check box to say that
blank values should not return. How do I do in in profiler 2000 (the filter
is on the text vaule)

Hi NG,
I have the script below to backup all databases except for tempdb, pubs and
northwind on my SQL Server 2005 machine but unfortunately it will not backup
all the database in the query. In the command line I use "start /w sqlcmd -S

I am installing sql 2008 on Windows server 2008. We plan to use it as the
dbserver for a new MOSS 2007 server installation which will be on a seperate
server. We want to also move some dbs from a sql 2005 server on to it.
Should I install a named instance for the MOSS server ...

Is there any way to extract the data ("Insert Into...") of the DB tables?
I'm using SQL2k8 and Management Studio... Thanks very much!

I have approximately 20 databases on a SQL Server 2000 enterprise edition on
a windows 2003 server.
I would like to install SQL Server 2005 management studio on the same server
and keep my 20 SQL Server 2000 databases.  I will slowly upgrade the

We had out database crash.  We were lucky enough to have a recovery place
salvage the actual data.
For what ever reason...none of the index definitions or data got recovered.
We have an two month old backup that has all of the indexed.