Viewing 15 posts - 886 through 900 (of 984 total)
Brian,
Thanks!
I have just been trying to generate random data, and wondering why rand() doesn't behave as expected. I thought I would wrap it up in a single function, but...
Thomas Rushton
blog: https://thelonedba.wordpress.com
November 6, 2003 at 5:00 am
quote:
For info - my copy ordered on 19 Sept arrived in the post this morning. Just over 4 weeks to United Kingdom.
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 21, 2003 at 6:09 am
take a look at sp_msforeachtable -- this takes a command and runs it against every table...
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 9, 2003 at 1:31 am
Do you mean the MMC snap-in?
I like it, mostly. I think the management tools for SQL Server have improved with each revision -- anyone remember the pain that was...
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 9, 2003 at 1:29 am
AFAICR, it's something like
mount /dev/fd0
then copy your file(s) across to /dev/fd0
then umount /dev/fd0.
It's been a very long time since I was a unix admin, so things may have changed!
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 9, 2003 at 1:24 am
Using a method like this to create a temporary table of zero rows has the added benefit of not locking up the source table while creating the temporary table. ...
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 7, 2003 at 6:33 am
quote:
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL ServerWe are on Win2K Advance Server SP2. No errors reported in Windows or SQL....
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 7, 2003 at 6:26 am
quote:
If you just want to go directly to help, right click on the assistant (I prefer Rocky the dog for occasional amusement),...
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 7, 2003 at 6:15 am
If it's something that would happen in slack time, there's plenty of that around at that ungodly hour of the morning! We have a few scheduled jobs that take...
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 3, 2003 at 2:46 am
All ours are set up to use a single domain account, which is granted local admin rights on each server.
It's not the safest way, but I've not yet got round...
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 3, 2003 at 2:27 am
quote:
To confirm your observations, found this on TechNet
I saw that too, before I posted here....
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 2, 2003 at 6:34 am
quote:
So much for that theory.
Sorry. Nice try, though!
quote:
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 2, 2003 at 2:42 am
quote:
Is the database set for autoshrink?
No. I've just checked.
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 2, 2003 at 2:23 am
Thanks for your help.
I shall do some evaluations of my own in a couple of weeks' time. The problem itself has been relieved slightly by clearing out a few...
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 1, 2003 at 7:02 am
The main roles the service IDs need include (so far as I understand it):
I could be wrong. We...
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 1, 2003 at 6:55 am
Viewing 15 posts - 886 through 900 (of 984 total)