Viewing 15 posts - 37,246 through 37,260 (of 39,818 total)
I do not believe this is correct. (above post).
In SQL 2000 you can specify whether text data is stored in the row, up to some size.
From Inside SQL Server:
Prior to...
August 22, 2002 at 2:04 pm
Be sure you have test servers that you can afford to have down while you reinstall first.
Then follow Andy's advice. Read about it, and install it. You will probably have...
August 22, 2002 at 1:30 pm
Also, be sure you are storing this data from the SQL server not the ASP server. Will prevent time issues when comparing things.
Steve Jones
August 22, 2002 at 1:28 pm
I think the service account for SQL Server needs to be an account other than Local System.
Steve Jones
August 22, 2002 at 1:23 pm
Embarkadero was pretty good until 2000. Now with templates, color coding, I think QA works great. RapidSQL sorta had VSS integration, but didn't work well for me. Haven't looked...
August 22, 2002 at 1:21 pm
One other nice thing. RapidSQL used to work offline, no SQL needed. However with the personal edition in 2000, not sure this is a big selling point.
Steve Jones
August 22, 2002 at 1:21 pm
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
Viewing 15 posts - 37,246 through 37,260 (of 39,818 total)