Viewing 15 posts - 36,601 through 36,615 (of 39,903 total)
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
SQL Server doesn't support arrays. You could simulate this with a table datatype or temp table or perhaps a cursor.
For a tree, there are multiple ways. Is this a tree...
March 19, 2003 at 10:37 pm
There are some utilities, like checkident and set identity_insert, that are not designed to allow anyone to use them. The reason is likely that often the developer's have not thought...
March 19, 2003 at 8:44 pm
Tend to use what's installed only. EM, QA, Profiler, Perfmon.
recently moved to Litespeed for backups.
Steve Jones
March 19, 2003 at 8:40 pm
Viewing 15 posts - 36,601 through 36,615 (of 39,903 total)