Last week I dropped a database without removing it from my maintenance plans first.  Now the jobs are failing with an error message similar to the following:
Job 'Optimizations Job for DB Maintenance Plan 'Database Reindex (User)'' : Step 1, 'Database Reindex (User)' : Began ...

I'm not sure if this is a Windows issue or a SQL Server in a cluster issue,
but it's strange.
We have a Windows 2003 Server Enterprise w/SP2 Running in a cluster.  The
only thing on these servers is SQL Server.  It's behind a firewall with only

Hi Sql Server experts,
I'm going to set the option READ_COMMITTED_SNAPSHOT to ON.
I'd like to know what impact this will have to the database.
Thanks for your help.

Hi, can anyone suggest a good and free editor tools for script file? so it
would be eaiser to tell the begin... end...

I want to write a SQL query to find if a perticular database is backed up in
any Maintenance plan or not.
Is there any way to write this query.
I can surely open all the Plans and view it, but I need to find it out using

I have those errors Invalid object name 'msdb..sysJobs'.
=========================================================================
the error comes from the query
select count(*) from msdb..sysJobs j, msdb..sysjobschedules s where

We have SQL Server 2005 Enterprise x64 in a failover cluster configuration.  
We recently installed SQL Server 2005 Cum 6 for SP2, and now
xp_availablemedia hangs when call within SSMS.  Has anyone else experienced
this?

I'm writing a SP to automate the creation & maintenance of Partitions and
Filegroups. Every 1st of a month, I have to create a new partition to move
all the previous months data to a new partition and at the end of the year I
have to consoldiate all the years partition into just ...

I have a Job on SQL that fails to kick off, but when I run the task (an index
defragmentation) under Query Analyzer with the same user credentials, it runs
fine.  The Job wizard didn't ask for a password for the user login, and I
didn't see a place to enter it.  Is there some ...

Over the last week or so we have begun receiving this error in the event
viewer and until the system is rebooted and then the sql server service
restarted (HAS to be done after a reboot) our CRM system and any other sql
related services are unanavailable.

SQL server 2000 sp3
Hi
I have a sql server 2000 database. In one application initial database size
was 13 gb. We created primary data file for required size. Application later

We have a single production database server right now with a single database
on it.  The TempDB is on it's own drive and the the Transaction Logs are on
a separate drive.  We currently perform nightly backups but I'm conserned
about loosing the transaction logs drive and not ...

DBMS: Microsoft SQL Server 2005
Issue: I have a table with clientIds and statuses in it.  I need to
query from this table and return one row per clientId with columns for
each status holding the total number of records for that status for

 I am working on SqlServer 2000,
When row will be inserted/updated  in one table that data neds to be
inserted/updated into the another DataBase on the same machine. Both
table has different schema, what is the Better solution? I know we can

I need to compare two varchar columns containing date values. One
column contains the 'dd-mmm-yyyy' format in english, the other in
dutch. Problem is that in march,may and october the 'mmm' format is
different. So essentially, the question is: how can I compare '10-