Viewing 15 posts - 37,486 through 37,500 (of 39,818 total)
SQL Server will be windows license + $5k per processor to run on the Internet. Unless you have all authenticated users, then you can use CALs, but that probably won't...
July 11, 2002 at 2:08 pm
Sounds like a few scripts:
For phones,
select phone, count(*)
from vendor
group by phone
having count(*) > 1
Steve Jones
July 11, 2002 at 11:10 am
If you can connect with NT, you can snag the passwords and get them. See the "cracking thread" in this forum.
Steve Jones
July 11, 2002 at 11:08 am
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
July 11, 2002 at 11:06 am
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
July 11, 2002 at 10:49 am
The FileSystemObject has a "fileexists" property you can check.
Steve Jones
July 11, 2002 at 10:44 am
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...
July 10, 2002 at 10:55 am
That's possible. Apologies, but I'm not an Access person. Hopefully Andy or someone else will chime in.
Steve Jones
July 10, 2002 at 10:43 am
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....
July 10, 2002 at 10:40 am
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,...
July 10, 2002 at 10:36 am
Is the user calling this as dbo.function?
Steve Jones
July 10, 2002 at 10:29 am
Or someone stole your server last night and EM can't find it.
Just kidding ![]()
Steve Jones
July 10, 2002 at 10:28 am
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...
July 10, 2002 at 10:04 am
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
July 10, 2002 at 10:00 am
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...
July 10, 2002 at 9:59 am
Viewing 15 posts - 37,486 through 37,500 (of 39,818 total)