from within query analyzer and not an appliction, i created an excel file with the three columns exactly as david suggested and ran this code:

INSERT INTO

OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\Book1.xls', [sheet1$])...

connect via instance name and run the script below. this will identify what port your instance is listening to.

if it is anything other than 1433, you will need to...

connect via instance name and run the script below. this will identify what port your instance is listening to.

if it is anything other than 1433, you will need to include...

Shelling out an html file does not return any text.

if your objective is to use sql server to call and parse a web page, you will need to write an...

are you trying to connect to a named instance of SQl server, rather than a default instance?

for example, my machine has a SQL7 instance and a SQL2000 instance.

connecting to the...

I believe statistics are gathered when a table is queried, so that subsequent queries can be tuned to follow the path of previous queries;

could it be that the tables with...

I hope this helps: if you take an html file and change it's extension to .xls, Excel translates the file beautifully, keeping all your table atrributes TR and TD and everything...

there is a fascinating read here at SCC where the SOX auditors tried to say that the DBA must not have access to the production servers:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=161&messageid=116604

which is patently ridiculous,...

this is probably better for you than the long crap i posted:

create table #tuser (type int, oname varchar(517), owner varchar(517), seq int)

insert #tuser exec sp_msdependencies null, 3, null, null, 1

select...

below is a procedure which returns all tables in the foreign key hiearachy order; it's copied and slightly adapted from scripts here at SSC;

i would suggest the following:

use this...

i think you missed the point that each insert statement is an atomic transaction;

the begin tran is just a marker so that a group of atomic transactions can be rolled...

I thought the issue might be because you are running it in Query Analyzer; by default, text is limited to 256 chanracters until you change it to allow up to...

if it's web enabled, it'd be a piece fo cake to make a mobile web page that allows you to do whatever functions you feel can be done by remote...

two issues here. first, you forgot to quote the url, so if you tested the vbs file from a command prompt to see if it works, you'd see it errors...

what happens to countries that have two part names, ie "United Kingdom", "United States", or "Federated States of Micronesia"?

woudn't you compact them and turn them to wrong values?