I don't think you can connect to an ip address, by instance name, if you are not on the same subnet. if your instance is on a public IP, you...

the text for an sp , if not encrypted, can be searched in syscomments.

select sysobjects.name from sysobjects

inner join syscomments on sysobjects.id = syscomments.id

where sysobjects.xtype='P'

and  text like '%view%'

the ordsys is an extension for image manipulation from within the oracle environment;

the nearest equivilent would be creating a dll in .NET for example, which uses the functions in System.Drawing, and...

i think this can be handled two ways;

your instance is listing for SQL Server connections on a different port than the default instance of 1433;

you can either change the listing...

someone who posts here has a tagline that says:

XML is like violence...if it doesn't solve your problem your not using enough of it.

dang i knew that too Remi; just didn't include it in my attempt for a sample; i get to do mostly .net winforms and pages now, so my vb is...

assuming you are using asp and not .net, because you were referencing Request.Form, i think you could use something like this to get your recordset of values.

you still have to...

for those of you who are too cheap to buy and register winzip(command line winzip is not free, i beleive)

you can use PKZIP25.exe, which is the last free command line...

I've done something very similar; the difference in mine is that it assumes  specific paths, which you would have to change or paramiterize (sp?);

it is adapted from a backup...

I think i see where the question resides.

the interface for RS IS web pages....there is no .exe program like sqlserver.exe to call. There is no client side application to install.

i...

you could also use the SPLIT function off of this web site; it returns a @table of data,; for example

select * from dbo.split('x10\210\63\1\10\J-type\4/...','\')

returns:

strval                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           ------

x10

210

63

1

10

J-type

4/...

i would imagine from there you...

Reporting Services requires IIS, because all access to the reports are web based;  any of the drill down reports are web pages that link to the detail views, so with...

Can i ask what was your source for the ZIP+4 database? I've only found ZIP databases, or items like the PLACENAME database with zipcodes from the census, but cannot seem...

all error messages are in master.dbo.sysmessages i believe;

so you'd select @err=@@error in your proc, then

select description from master.dbo.sysmessages where error=@err

if the severity was such that a run time...

Sara thanks for the input;

your suggestions showed me that in my real world sample database, your script found ten more tables, and their table counts, than mine did;

i just...