Viewing 15 posts - 37,456 through 37,470 (of 39,510 total)
When you use NT Auth, you do not specify a user for pwd. The user account of the logged in user, in this case the IIS Service user, is used....
June 10, 2002 at 10:56 am
osql .... > filename
is a new file.
osql ... >> filename
appends to the file. See my series on version control, part 3 for more info.
Steve Jones
June 7, 2002 at 10:01 am
I agree with Antrares and Andy. As a DBA who's been doing this for 9 years, I'd never give a develop access to the production box (except read only). It...
June 7, 2002 at 7:59 am
June 7, 2002 at 7:54 am
The passwords are in master, so unless you move that db, it won't help.
I think there is a kb article somewhere on this. You may be able to export the...
June 6, 2002 at 12:18 pm
If you can duplicate this, run profiler. If it happens regularly, then let profiler run and dig through it later.
As mentioned, these are hard to trace.
Steve Jones
June 3, 2002 at 5:58 pm
Had a similar issue. Had to rebuild packages. Never determined why, but could not get the password to change in the package.
Steve Jones
June 3, 2002 at 5:55 pm
I tend to agree with Antares. Having VB.NET support inheritence, real classes, etc. there is not a substantial difference from c#. Personally I prefer C#, but that's personal. No real...
June 3, 2002 at 5:55 pm
You could enforce them making an update to the field, though I think Andy has the best solution. Check in the trigger to see if they changed anything. If not,...
June 3, 2002 at 5:50 pm
Haven't tested, but I assume you could use Deleted and reset the value(s) you want. Not sure I'd recommend this. Why?
Steve Jones
June 3, 2002 at 4:49 pm
Painful. usually in this case, you will need another outage window to do a backup/restore to the primary site.
Steve Jones
June 3, 2002 at 8:52 am
Speaking for myself, keep the money and keep coming back. Also tell your friends.
Steve Jones
June 2, 2002 at 2:59 pm
check out my article on Charindex. I'm sure that will help you. Search for the ascii of the carriage return.
Steve Jones
June 2, 2002 at 1:34 pm
SQL Server can make it's own backups to disk, which any tape system can back up. This is the recommended method.
I'd avoid using 3rd party backup.
Steve Jones
June 2, 2002 at 1:17 pm
Find a way to justify the 20k machine. Better to be over the top than under.
15GB isn't that big, BTW.
Steve Jones
May 31, 2002 at 6:19 pm
Viewing 15 posts - 37,456 through 37,470 (of 39,510 total)