Here you go. Besure to destroy the object. It'll eat your DB's memory!

 

DECLARE 

@vPointerINT, 

@vResponseTextVARCHAR(8000),

@vStatusINT,

@vStatusTextVARCHAR(200)



EXEC sp_OACreate 'MSXML2.ServerXMLHTTP', @vPointer OUTPUT

EXEC sp_OAMethod @vPointer, 'open', NULL, 'GET', 'http://localhost/Fiber/clients/'

EXEC...

Please post example.

There is actually a very easy way. Provided your DB can see the net.

Useing sp_OACreate and it's "friends" you can use the XMLHTTP control.

There is a lot in BOL explaining...

Try using IDENT_CURRENT

Have a look in BOL. A few examples included.

Crispin

I did something a couple years ago similiar to what you are after. (I Think )

What I did was get a list of users (sp_who) and attempted...

Something else I found in BOL. Look at xp_cmdshell.

quote:

---

CREATE PROC shutdown10

AS

EXEC xp_cmdshell 'net send /domain:SQL_USERS ''SQL Server shutting down

...

As racosta said, killing connections could be dangerous.

Here is another solution.

If you pause SQL, it waits for all connections to close and denies new connections.

You could, using xp_cmdshell, pause it...

You should be able to use

@DBName + '.dbo.Table'

Crispin

Why don't you try practicing random acts of intelligence and senseless acts of self-control?

hmmm, Not sure then.

Possible to backup the db (one with one two tables) and email to me?

cproctor@idi.co.za

CP

Why don't you try practicing random acts of intelligence and senseless acts of self-control?

If you leave out the second part of your where, does it work then?

As far as I can see, that is what's causing the select to return the two rows.

Why...

quote:

---

A six pack of "Fat Tire" would do nicely

---

I take it that is come kind...

You can do a LEFT OUTER JOIN onto Persons.

SQL returns all matched on the left and any possibles or null on the right.

CP

Why don't you try practicing random acts of...

You're just trying to show off...

I have not used DMO, can it in someway be added to a job? DTS/ActiveX Script?

CP

Why don't you try practicing random...

LOL.

I was going to ask the same question.

I to wanted to do something like this.

I watched profiler while scripting and it does a huge amount of work.

Busy sifting through it....

quote:

---

I lived this nightmare for a while so I know your pain (inherited servers with odd collations).

---

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!