You probably don't need to keep this, run a backup transaction with no_log to clear it out and then a dbcc shrinkfile () with the filename to reduce the size.

Steve...

backup/restore will work.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Tend to agree with the last post. SQL Server DBAs in general, could learn a few things from more mature DBA techniques practised on Oracle/DB2/etc. That being said, I'd put...

Ditto here as well. Happy Holidays to everyone!

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Likely the information comes from two different places and is calculated differently.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

We know. We're sorry. The search is one of our weak areas and we've tried a few things, but honestly we need to get someone devoted...

Probably not. I'll remind Andy.

Don't be too excited, we're all slammed between work, the site and the magazine. Actually Frank, maybe you want to build one?

Steve...

We'll add it to the list. 😀

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I spoke with NGSSoftware about this also and we never could conclusively figure it completely out.

sorry

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

We tend to only test on IE, hey, we're a Microsoft site!! :D.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

If cost is really a factor, you might look at MySQL. Especially for non-mission critical functions, it runs on many platforms and provides basic functions.

I'd advocate SQL Server because it...

you can connect. When you add the login, you can add them from a different domain.

The recommended procedure, however, is to create a local group on the machine, add...

CPU is a tough one. Profiler is a good start. Also, you might try checking to see if the app changed.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I've tried different products (Embarkadero, FMS, Visio, etc.) none worked well. IF you come up with a way,let us know!!!

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Hell if you can configure SQL to use < 2MB, I'd hire you!!!!

I agree with most of the comments above. I'd like to see the certs matter,...