Viewing 15 posts - 37,381 through 37,395 (of 39,941 total)
You'll need to be able to connect to run MSSQLCrack.
Add yourself to the local administrators group. Right click MyComputer, slect Manage. choose Local Users and Groups, then Groups. Dbl...
August 22, 2002 at 8:55 am
Aha!
If you are restoring the database, pehaps the source database was changed. Where does the job fail? On the restore? On the add users?
Steve Jones
August 21, 2002 at 5:01 pm
run profiler and see what is being run by the job.
Are you sure the job hasn't changed? what does the job do?
Steve Jones
August 21, 2002 at 4:48 pm
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
Viewing 15 posts - 37,381 through 37,395 (of 39,941 total)