Viewing 15 posts - 37,471 through 37,485 (of 39,510 total)
In SQL 2000, there is an execute package task that does this.
In SQL 7, you can do it with ActiveX
Steve Jones
May 31, 2002 at 6:17 pm
May 31, 2002 at 6:12 pm
I would look to put the common information (name, auth code, etc.) in the main table. For other info, you have three choices.
1. Use a single table and a "type"...
May 31, 2002 at 6:08 pm
If you do it in EM, it will generate a script for you. You have to drop the table and rebuild, but you can rename the table as a temp...
May 31, 2002 at 9:17 am
Not that I know of. We have started something here (in alpha) that will allow people to post models and others to comment on them. We hope to build up...
May 31, 2002 at 9:15 am
DTS will not export an XML query. You can use isqlw and pipe to a file or query with ADO (ActiveX Task) and then save as XML if you are...
May 31, 2002 at 9:12 am
Interesting choice of words. Hopefully EM doesn't have any habits it can learn or unlearn. 🙂
I would suspect this is a bug, however it should work based on the precendence...
May 31, 2002 at 9:09 am
Sounds like an unreliable network connection. Can you make a larger file transfer (>1MB) and see what happens?
Steve Jones
May 31, 2002 at 8:52 am
I can't see the attachment, but I thought the red line was "disconnected".
Can you run sp_who2 with this login?
Steve Jones
May 30, 2002 at 10:12 am
Sylvan-Faust makes one. Also SQL 2000 has one built into query analyzer.
Steve Jones
May 30, 2002 at 10:10 am
run sp_configure and up the number of connections. Also, check sp_who for an accurate count of users.
Steve Jones
May 29, 2002 at 9:18 pm
Not sure. I've started it, but can't find time to finish it. I hope to have it by end of June.
Steve Jones
May 29, 2002 at 3:48 pm
May 29, 2002 at 3:41 pm
Increase your timeout as well. If the network or server are busy, the defaults don't cut it.
Steve Jones
May 28, 2002 at 9:44 pm
You can do this, but you need a domain account at the remote facility. If it's a standalone server, then you need a local account on the machine.
Steve Jones
May 28, 2002 at 9:42 pm
Viewing 15 posts - 37,471 through 37,485 (of 39,510 total)