Nope, everything I have seen and been told in MS Classes is that it grows by 10% of it's CURRENT size.

-SQLBill

Joe,

I run DBCC SHOWCONTIG. That will show how fragmented your indexes are. Check it out in the BOL.

-SQLBill

Setting a percent will cause exponent growth. It's always growing 10% of the current size. So as the db gets larger it needs to expand even more.

Let's say...

I do not recommend ever setting the growth to a percent. Set it to 100MB, see if that resolves the issue. If not, increase it to 200 or more.

There are...

Open Enterprise Manager. Expand to Security. Find the login, double click on it. Give it permissions to the database including db_owner.

Open Query Analyzer: Run:

USE dbname

exec sp_changedbowner 'new_owner_login'

For example:

USE MyDatabase

EXEC...

I believe so. I don't use maintenace plans...I write my own jobs to do what needs done.

-SQLBill

A log reader, such as Lumigent's Log Explorer, can show you what commands were run. But I don't believe it will show WHO ran the command.

Like Greg said, there's no...

Remember, Differential backups are not the same as TransLog backups. Each differential backup is a backup of ALL the changes since the last full backup.

So, Tuesday's diff is all the...

Is your maintenance plan doing reindexing? If so, note that reindexing can cause the log file to grow to 2.5 times the size of the database.

-SQLBill

That's normal. I run that on a 300GB database and the log file increases quite a bit. The thing is, it doesn't increase as much as running DBCC REINDEX...

It's a legal requirement to encrypt information such as credit card numbers, social security numbers, and other personal information. If the law requires it, your company has to do...

BTW- please don't cross post.

-SQLBill

Please don't cross post. You also have this in the 2000/2005 TSQL forum. And I posted a response there.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=312785

-SQLBill

Does it have to be ordered in this way:

ORDER BY Last_Name, First_Name, Task_Number, Detail_Action_Date desc

If you can ORDER BY Detail_Action_Date,

Then just add TOP 3 to the script.

-SQLBill

What happens if they try to register using the IP address vice the server name? Also, have you tried reinstalling MDAC on their system?

-SQLBill