Viewing 15 posts - 36,421 through 36,435 (of 39,720 total)
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
The date is stored internally in SQL Server in its own format. The client display depends on what is set on the client system.
If you want to convert it you...
March 19, 2003 at 8:38 pm
Nothing. Permissions for this default to the object owner, dbowner, and sysadmin.
Steve Jones
March 19, 2003 at 8:35 pm
I thought th restricton was 4GB.
If you enable AWE, you should be able to go to 4GB
Steve Jones
March 19, 2003 at 8:33 pm
Viewing 15 posts - 36,421 through 36,435 (of 39,720 total)