While it might seem conventient, same as threaded discussions, I much prefer this "conversation" format. I know if I don't have time to read all the posts, then I tend...

Haven't seen this, but will forward to our SMS guys to see if they have.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Krispy Kreme is amazing, especially when hot! They melt in your mouth.

AFA the books, The Guru's Guide by Ken Henderon is agood read as is Ben-Gan's Advanced TSQL.

For admins,...

Thanks for the complements and notes. We couldn't have built this site without all of you!

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

35, about to add to that. Married with 3 kids (11,4,2) and enjoying life as much as I can. (http://www.dkranch.net/about/default.asp#members)

Of course, if I don't get something done quickly, it's probably...

I'd build a table and have them insert a value in there. You can then check this table with some job that will run backups.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp

I'll look at the search.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Will be there permanently.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Very interesting. Haven't seen this, but I'll take a look.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

You have the sum of all permissions with the note that DENY overrides everything,

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Profiler is really the only way out of the box. Lumigent has a product called Entegra that I believe can help as well.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

the default trace should get all SQL events sent to the server. Is this SQL 2000? Did you enter any filters on the last tab?

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Look at this

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15654&FORUM_ID=8&CAT_ID=1&Topic_Title=top+20+amounts+by+a+area&Forum_Title=T%2DSQL

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Pesonally I like storing them in the filesystem and then retrieving them with the path from the db. Not sure if Crystal can do this. Another alternative is to store...

Is this SQL 2000? I'm not sure if you can register the purchased one, but you can easily detach and attach your dbs once you uninstall and reinstall. I'd...