Viewing 15 posts - 36,466 through 36,480 (of 39,771 total)
Nice suggestions and I'll tackle a few of them.
A. Emails - Good point. In fact, I tend to agree and this probably wouldn't be that hard. We use the free...
March 24, 2003 at 10:32 am
SQL 2000 or 7? Not that it matters for a user in the db. The db backups (full, diff, and log) are designed to run with users in the database.
Do...
March 24, 2003 at 8:32 am
Jon and David,
The reader review is a great idea, and something that quite honestly, I hadn't thought of. I know that I often read printed reviews in PCMag and like...
March 24, 2003 at 8:27 am
Couple things. Andy is right, changing your risk there, though that depends on your physical layout. If your data and log drives are both the same physical RAID array (you...
March 23, 2003 at 8:23 pm
are all the paths the same? I might be tempted to bring up the 7 install, get it patched, then down SQL, replace the master mdf and ldf, and come...
March 21, 2003 at 4:47 pm
don't really have any ideas Lee, but a couple things I wonder about.
Was the server running fine before the memory add? If so, can you remove it for a week?
Is...
March 21, 2003 at 4:45 pm
should be in your logs folder, near where your data folder is.
Steve Jones
March 21, 2003 at 2:38 pm
You can use DTS on some schedule to load the data. Not sure you can get any better "streaming" than this.
Steve Jones
March 21, 2003 at 1:46 pm
Are you repairing minor errors? Wouldn't, know bugs with this.
There is probably someone still connected nad the db can't be set to single user mode.
On error, run sp_who2
Steve Jones
March 21, 2003 at 11:10 am
I know we're getting off topic, but we are native mode, but still have some NT4 stuff around. We still have WINS running, though I suspect it's more because people...
March 21, 2003 at 10:11 am
Can you provide more information? Is this SQL Server to SQL Server? OR some other provider?
The provider hsa to support the inserts, which not all providers do.
Steve Jones
March 21, 2003 at 9:30 am
Not sure this is captured. Much of the information in the TDS stream that you know about a connection is sent by the user.
Running netmon on the server, catching 1433...
March 20, 2003 at 10:07 am
Ha, don't know about that.
SQL tends to work with a group of rows rather than a single row. None of the datatypes map well to an "array" structure.
Might change in...
March 20, 2003 at 10:04 am
Apologies, I forgot. Kept thinking 7 was the same as 2000 in this area.
suspect there may be a reg hack, but then you are in an unsupported and possible illegal...
March 20, 2003 at 9:50 am
This should be posted in the T-SQL forum. Suggestions are for suggestions for SQL Server Central.com. Please repost there.
I'd also include an example of what you have. There isn't a...
March 20, 2003 at 9:44 am
Viewing 15 posts - 36,466 through 36,480 (of 39,771 total)