You could, but the host server would still need sql installed and running. I suppose you could script a startup, but you'd still need the registry entries. SQL, however, can...

You can add a field and set a default of "getdate()" for inserts, but for updates you'd have to set a trigger.

Lumigent's Log Explorer or any of the log reader...

longer than your arm :D.

Actually I'm not sure at this point. we all three get so many things.

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

Not a bad suggestion, we just went with what came from the Snitz code. I'd guess it goes to the number of posts somehow correlating to contributions to the community.

We're...

Interesting idea. I hadn't considered that.

Thanks for the info.

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

Honestly Robert, I'm not sure what happened, but I wouldn't mess with this. Call PSS.

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'd script from EM.

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

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