Are you doing a lot of reindexing? If so, that will cause the log to grow.

-SQLBill

I saw this in one of the other forums.......

---------------quote--------------------

, I know, I know. That's bad.

We were trying out a new email system for our vendor mailing yesterday and the load...

Best place of all......use the SQL Server Books OnLine.

BOL=Books OnLine=Microsoft SQL Server's HELP

Installed as part of the Client Tools

Found at Start>Programs>Microsoft SQL Server>Books OnLine

or online at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

-SQLBill

It WAS funny though.......

-SQLBill

Normally this would work......

SELECT CONVERT(DATETIME, 1137699938)

But it's not working for your value. How do you 'manually' convert that to a date? And is it coming from some other application?...

I agree with alzdba, your TEMPDB needs to be larger...but how can you do this? Easy. Go to Enterprise Manager, expand until you see the TEMPDB database. Right Click on...

Okay, now you've narrowed it down to one specific step. Next steps......

1. what does that step do?

a. does it do anything that could cause the slow down?

2. when...

900 MB???? That's NOT huge. One of my databases is (as of today) 292 GB and it grows 2 GB every day. I only have one transaction log file...

What error messages are seen?

1. check the SQL Server Error Logs

(in Enterprise Manager, expand until you see Management, expand that to see SQL Server Logs, expand that...

Check to see if that file exists in that location. That's the number one thing to do.

I have been able to resolve suspect databases by detaching and re-attaching them....

The maintenance plan will still do full backups.

The main thing with using Simple vice Full is that you can't do transaction log backups, which in turn means you can't do...

Check the database...the issue might not be disk space. In Enterprise Manager, right click on the database, select Properties, go to the Options tab. Is the Recovery Mode Full or...

In SQL Server you need to have all the SELECT columns in the GROUP BY.

ie. GROUP BY CCISRC, CCITEM, CCPDCL, CCDESC

For DB2, you should post the question in a DB2...

B. I don't have anything like this, but without replication set up, your best bet might be.......backup the original DB, restore it to the Developement server. Stop services on...

According to the BOL, it means that your instance is not per-seat nor per-processor licensed.

What did you get when you ran the SERVERPROPERTY('LicenseType')?

-SQLBill