Viewing 15 posts - 37,396 through 37,410 (of 39,941 total)
I was surprised by this one. I thought the SQL passwords were one way hashes, and unbreakable. Apparently not.
These should scare you and make you enforce strong passwords.
Steve Jones
August 19, 2002 at 9:41 am
Depends on the script. If you do a script the whole database, then no, it will not. the database itself doesn't know about what is changed and what is not.
I...
August 19, 2002 at 9:30 am
Probably can script the sp_Addlogin using the domain name (existing), then re-run with a search and replace for the newone.
Steve Jones
August 16, 2002 at 11:33 am
I keep the permission with the object create script. That way they are added when the object is created.
The first time you do this, it's tough, but once you get...
August 16, 2002 at 9:58 am
Not likely to be anyway to do this except permissions. Is this a big problem?
Steve Jones
August 16, 2002 at 9:52 am
yes, but it will take time to recreate them. Dropping them decreases the load time, not the total time to get the table back to it's state.
Steve Jones
August 16, 2002 at 9:48 am
The listeners do not start unless the server reboots. This might be your problem.
Steve Jones
August 14, 2002 at 12:20 pm
Are you doing this in one transaction? You can set the size of the batch to commit.
Steve Jones
August 14, 2002 at 10:51 am
Is the path for the log file in existence? It will not create it. Use the WITH MOVE option to move the log file to a valid path.
Steve Jones
August 14, 2002 at 10:48 am
A good point and worth considering. as with most things, it depends on the business rules.
There may be a transient environment, like an ISP for example. If I sign up...
August 14, 2002 at 10:46 am
select
b.brochures
, b.pid
, h.holidays
from m_brochures b
inner join m_holidays h
on b.pid = h.BrochuresXid
where h.pid in ( select top 5
h1.pid
from m_holidays h1
where h1.BrochuresXid = b.pid
)
order by b.brochures
Steve Jones
August 14, 2002 at 10:41 am
I built my own (/columnists/sjones/vcspart1.asp).
There are products from Embarkadero, CA, etc. that can help. Search the forums for version control.
Steve Jones
August 14, 2002 at 10:12 am
Looks like a permissions error. Someone must have messed with the permissions on the server, either Filesystem or registry. Can you start it under an adminsitrator account?
Steve Jones
August 14, 2002 at 10:10 am
Viewing 15 posts - 37,396 through 37,410 (of 39,941 total)