We are going through some legacy servers and taking some of the
databases offline. The issue with this is it causes the backups to
fail. How can you select the databases out of the system catalog which
are not offline?

I have a SQl2000 server, I would like to move the sql error log file to
another disk on that server, how can I accomplish this.
Thank
JW

I found a 32-bit version of SSE SP3 w/advanced services... but is
there a 64 bit version?
Thanks

We have an active system, where the .ldf file in one database grows to
over 2 TB.
(which is the max disk size of our SAN system).
Therefore we have added an additional .ldf file to the database, so

I'm not sure to be in the correct group, hope so!
Is it possible to ask a software to wait until a Table or a DataBase
is updated ?
Hope someone will be able to answer

I have a SQL Server 2005 databases which is simple recovery mode that would
like to complete full backup every other day. The days that I do not complete
a full database backup I would like to complete a differential backup.
Please help me with syntax that goes along with ...

Hello, i want to do a query in 2 tables, but i didnt find how to do
that.
I have 2 tables :
incident(incident_id,description,date_created)

I tried installing SQL Server 2005 Enterprise edition on my XP laptop.  It
didn't work.  I viewed the system requirements and it didn't list Vista in
the list of OS's (maybe it wasn't out at that time).  I'm looking to run SQL
Server 2005 Enterprise edition so that I can test ...

dbcc showcontig with fast on a very critical database shows that some
tables are fragmented, example below:
- Scan Density [Best Count:Actual Count].......: 39.70% [214:539]
- Extent Scan Fragmentation ...................: 94.43%

I have a table with about 150 columns and 15 million rows.. (SQL Server 2000)
20 or so of the columns are now redundant, so I am just not populating them.
My question is 'what effect does an empty coumn have on performance?' I.e.
am I likely to see a significant performance gain if ...

Anyone know why an UPDATE statement would generate messages like a
cursor, that is
(1 row affected)
(1 row affected)

I have a few tables that am starting to build up in SQL 2005 for a new
project.. a small amount of data sits on our data warehouse server (
sybase )
can anyone point me in the direction on how to connect to another database

So, we installed SP3 for SQL 2005 and now have 3 seperate progams can not
longer connect to the database.  When we launch the SQL Server Management
Studio it also errors out.  All services are running.  Here is the error from
the Management Studio.  Any help is appreciated.  ...

In short, when I run the exact same scenario on both the production
and test machines, the production machine is much slower by a factor
of 20!
- I copied the live database to the test machine.

I have a SQL 2005 database that does a Full backup every night and
transaction log backups every 15 minutes throughout the day.
When I want to make changes to the database with SQL scripts, I would like
to be able to backup the database just prior to making any changes to the