Viewing 15 posts - 5,416 through 5,430 (of 6,105 total)
The key is to convert the password to varbinary and then to use sp_addlogin and script encryption. Brian Moran, et. al., detail it here:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7777
K. Brian Kelley
June 6, 2002 at 1:54 pm
It can be done and there are programs which will decrypt for SQL 7 and 2000 available.
K. Brian Kelley
June 6, 2002 at 11:22 am
We scratched our heads over that one when we scripted our databases for change control and suddenly saw a fill factor. Turned out to be the maintenance plan.
K. Brian...
June 6, 2002 at 8:23 am
If the users are coming through TSE, it's the TSE server where the application runs and so the client is irrelevant.
One issue with SQL Server and Windows XP...
June 6, 2002 at 7:45 am
Do you have maintenance plans setup on the database(s) in question? If so, are you Reorganizing data and index pages and changing the free space to 10%?
K. Brian Kelley
June 6, 2002 at 7:34 am
The Microsoft Security Baseline Scanner will scan for blank or weak SQL Server passwords (it also handles IIS and the OS) in addition to checking for service packs and hot...
June 6, 2002 at 7:19 am
Keep in mind, though, that the majority of computer intrusion attacks are internal, at least with respect to a Department of the Treasury study (USA) on financial institutions. Ensure...
June 5, 2002 at 1:19 pm
The trigger has an implicit transaction with the original operation. If it fails, I believe a ROLLBACK TRAN is automatically issued, which would rollback the whole transaction. As...
June 5, 2002 at 9:21 am
This isn't possible with IIS 4.0 using NT authentication all the way through because of the double-hop issue (NTLM restriction by design). You'll have to toggle Basic Authentication (users...
June 5, 2002 at 9:09 am
These are likely created because you have autostats on for the given database. They are created by SQL Server when that is the case. Here's some more information...
June 3, 2002 at 12:04 pm
It's amazing we still have this issue given the November worm.
However, I believe the numbers that are posted for systems infected. I was surprised when I ran...
May 26, 2002 at 6:26 pm
In order for our QA department to be able to script databases and nothing more, we put their group in the db_datareader database role. The equivalent of giving...
May 26, 2002 at 6:19 pm
This is a silly question, but one that needs to be asked. Is SQLServerAgent running?
K. Brian Kelley
May 26, 2002 at 6:16 pm
This stood out:
quote:
Error source: Microsoft JET Database Engine
Does SQLJOBS have permissions to the directory...
May 26, 2002 at 6:14 pm
You can use an image field and choose any of the various methods to get it in (e.g. chunks or streams). However, what's generally done is the file is...
May 24, 2002 at 11:45 am
Viewing 15 posts - 5,416 through 5,430 (of 6,105 total)