Viewing 15 posts - 37,336 through 37,350 (of 39,902 total)
In that case, the index build would fail and would essentially be rolled back. At least that's what happened in v6.5 (no autorgrow).
You should have a fair amount of free...
August 22, 2002 at 1:15 pm
Not sure about 7. In 2000, there is sp_settriggerorder.
It also mentions that AFTER triggers are fired in random order.
Steve Jones
August 22, 2002 at 10:08 am
multiprotocol is the easiest. Could use IPSec, PPTP, or others if you want.
Steve Jones
August 22, 2002 at 10:04 am
Scrubbing has to occur. Personally I'd import using varchar, but then clean and move to a datetime to be sure I had valid dates. Those that didn't move could be...
August 22, 2002 at 9:51 am
You'd have to check the execution plan, but the Query Processor should reduce these two to roughly the same thing. The intent in SQL Server is to get the same...
August 22, 2002 at 9:36 am
Chris is right if that's what you mean. If you are changing a user's access password, you don't do anything in SQL.
BTW, this is why I use separate accounts for...
August 22, 2002 at 9:01 am
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
Viewing 15 posts - 37,336 through 37,350 (of 39,902 total)