Find the job or job step (probably in the full backup) that disables the transaction log backups. On SQL Server 2000 - you can't run both a transaction log...

In SSMS - right click on the Error Log folder and select configure. You can configure the number of SQL Server error logs that will be kept.

That was where I was heading - but needed to see the error message.

The problem usually does not show up with a connection (login) problem. Usually it shows up...

Grant Fritchey (4/14/2009)

---

I don't know anything about iBase either. I went and read through their literature. I suspect you would have a great deal of trouble using the iBase database...

Are you getting an error?

If you are seeing processes block themselves, you need to review what type of waits you are encountering. My guess would be that they are CXPACKET waits - which...

How are you determining that the error logs are not rotating? Issue that command does not create new files, it rotates the files so that errorlog.1 is renamed to...

I have another question - how do you connect to the client's server? Do you connect using an IP address or the name? If you use IP address,...

I believe the GUI tools require a higher privilege than just ddl_admin. Basically, this privilege allows the user to issue the DDL statements, but does not allow usage of...

Are you using Windows Authentication to connect to SQL Server? When you connect to the server, are you using a client specific domain account?

If so, then you will not...

Yes - it is Activity Monitor that is generating that statement. The question really would be why is this showing up in the logs? Generally, things like this...

You are welcome - I remembered the conversation and then it was just a matter of searching for a question that was posted by Jeff Moden. Since that particular...

The problem is going to be which row do you want to use to order the columns? And then what happens when you add a region, or additional funds?

If...

Here is a previous discussion that shows how to do multiple aggregations in a single pivot. We went back and forth on the various forms of pivot/cross-tab and which...

Great - it sounds like you now have things under control and should be able to shrink the transaction log.