If you can connect with NT, you can snag the passwords and get them. See the "cracking thread" in this forum.

Steve Jones

sjones@sqlservercentral.com

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

Just a note here. If you don't encrypt at the client, then the DBA can snag it with Profiler anyway. Sort of defeats the purpose.

Steve Jones

sjones@sqlservercentral.com

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

No way I know of. I wrote a script that would check the last batch time and use exec() to kill the spid.

Steve Jones

sjones@sqlservercentral.com

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

The FileSystemObject has a "fileexists" property you can check.

Steve Jones

sjones@sqlservercentral.com

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

And typical. People laugh at me, but I never leave a consultant alone. Some junior admins have gotten annoyed because I've had them babysit someone while I had to do...

That's possible. Apologies, but I'm not an Access person. Hopefully Andy or someone else will chime in.

Steve Jones

sjones@sqlservercentral.com

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

Good point Brian,

Unless you leave your machine unlocked.

Keep in mind that the people you are concerned about in this situation are consultants or others who may wander in your office....

What version of SQL? Backup was substantially enhanced in 2000. Also, what type of backup?

It is possible with a large query or transaction that a backup could cause a timeout,...

Is the user calling this as dbo.function?

Steve Jones

sjones@sqlservercentral.com

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

Or someone stole your server last night and EM can't find it.

Just kidding

Steve Jones

sjones@sqlservercentral.com

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

I use:

dfZero - 0

dfOne - 1

others as needed (I have neede dfThree)

dfBlank - space(1)

dfGetDate - getdate()

dfGUID - newid()

Sequential - use identity or UDF

Random - use a UDF, will get better...

I think Brian has the best suggestions.

Though I would leave the BuiltIn/Adminstrators in there. Nice to have a second way in, just in case.

Steve Jones

sjones@sqlservercentral.com

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

DBCC is your only real check. It sounds like you have data integrity issues, which are different than corruption. Can you search all the tables affected to be sure there...

You are welcome. Glad I could help.

Steve Jones

sjones@sqlservercentral.com

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

I agree with brian, but if you ahve access to sniff. With today's switches being deployed in so many places, it can be difficult for someone in your org or...