Viewing 15 posts - 37,351 through 37,365 (of 39,902 total)
Locks are an itegral part of the server. There are some that will always be honored.
If you have contention, then perhaps you have design or hardware issues.
Steve Jones
August 20, 2002 at 11:11 am
I would completely discourage this.
Script out the changes instead.
Steve Jones
August 20, 2002 at 9:02 am
depends on the client. Could have a query timeout.
Steve Jones
August 19, 2002 at 4:40 pm
When the import fails, the transaction rolls back, and thus there is space left.
I'd increase the log to 100MB or so and see what happens. You can always shrink it....
August 19, 2002 at 4:39 pm
Great point. I wrote an article on Templates in Query Analyzer and how they use them, but had to release copyright to SQL Server Magazine. The link is here and...
August 19, 2002 at 9:48 am
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
Viewing 15 posts - 37,351 through 37,365 (of 39,902 total)