Tyffany,

Are you using Maintenance Plans to do your backups? We have found that sometimes Maint plans get 'corrupted' and need to be recreated.

-SQLBill

Create table tRunningJob

(

HostName VARCHAR(25),

Step INT,

Job VARCHAR(17),

JobDuration int,

Status VARCHAR(10),

LastBatch VARCHAR(25)

)

CREATE TABLE tStuckJob

(

ServerName VARCHAR(30),

JobName VARCHAR(100),

StepNumber INT,

Duration VARCHAR(20)

)

Your Job should have these steps

1. --empty the tables of old data

DELETE tRunningJob

DELETE tStuckJob

2. --gather data...

Kevin,

We might not have the whole picture....but it sounds to me like someone:

1. posted a script

2. 'thought' that Red Gate claims copyright ownership of scripts on this site

3. pulled their...

in boot.ini set the /PAE switch.

Then open Query Analyzer, run sp_configure.

Look for the values for AWE. It should be 0,1,1,1 or 0,1,1,0

If it is not one of those, run this:

sp_configure...

Reindexing requires the log file to grow (I believe) 2.5 times the size of the database (it might be 1.5, but I think it's 2.5). It needs that amount of...

Glad we could help you.

-SQLBill

1. Make sure all systems have the same version of MDAC.

2. Are the users using SQL Server authentication logins? Or Windows Authentication logins?

3. If Windows Authentication logins, are the two...

I was trying to do some work and found the same issue. Then after testing, I found that if you CANCEL a running job the connection is not dropped. ...

A search of this site would have most likely found this:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=339222#bm339460

among other threads on this issue.

-SQLBill

Yes, it would have no effect. Some people add all of that code...just in case.

It doesn't hurt anything.

BTW- you can find out more about the syntax from the BOL (Books...

Darth,

Back to your basic question....the reason the NULLs aren't showing with the WHERE is the way SQL Server 'reads' the script. It does NOT start with the SELECT. It starts...

Check out this link:

Energy Policy Act of 2005 Implications on SQL Server

http://www.mssqltips.com/tip.asp?tip1163

-SQLBill

Here's how we do it.

1. Pick a server that will be your 'reporting' server.

2. Created linked servers from the reporting server to all the other servers.

3. Create a table called...

It sounds like your database is in FULL recovery mode. (Enterprise Manager, right click on the database and select Properties. Go to Options Tab. That's where you will see the...

Here are some things to consider when putting a database into single user mode.

1. It's not REALLY users. It's connections. One user with two or more connections is not single...