Viewing 15 posts - 37,261 through 37,275 (of 39,818 total)
I don't think there's a limit set in Standard. Performance is your limiting factor and likely the problem.
You can up the ODBC timeouts on the clients, but would need to...
August 21, 2002 at 3:13 pm
I think you should go with what works. Personally I find the indentations easier to read, but that's me.
Steve Jones
August 21, 2002 at 3:12 pm
Good points and thanks.
To sum up, create strong passwords and change them often!
Steve Jones
August 21, 2002 at 3:11 pm
Don't forget you write to these files at different time, therefore, I would expect that there would be a difference.
Steve Jones
August 21, 2002 at 3:10 pm
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
Viewing 15 posts - 37,261 through 37,275 (of 39,818 total)