Viewing 15 posts - 37,201 through 37,215 (of 39,764 total)
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
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
Viewing 15 posts - 37,201 through 37,215 (of 39,764 total)