Hi,

this approach is better because you don't have a static reference to SQLDmo. So there is no problem with the interfaces. It's true that you lose intellisense but just one...

Thanks Andy

I'm glad to help you!

Antonio

hi,

i'm typist, but what's the meaning of wpm?

Antonio

Hi guys

i had the same problem and the solution is this!

Set m_Server = CreateObject("SQLDMO.SQLServer")

m_Server.Name = "SERVERNAME"

...

Hello,

try this

CREATE PROCEDURE SELNEXTCOUNT @countername CHAR(5) AS

DECLARE @retval AS INTEGER

BEGIN

SET NOCOUNT ON

IF NOT EXISTS (SELECT VALORE FROM TB_COUNTERS (NOLOCK) WHERE COD_COUNTERS = @countername)

...

HI,

I have found the solution!!!!!

SELECT TOP 1 * FROM PRODUCTS WHERE ID_REC > (SELECT MAX(ID_REC) * RAND() AS ID_REC FROM PRODUCTS) ORDER BY ID_REC

No they have not.

I need this information programmatically!

quote:

---

Do the clients have Query Analyzer?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

---

February 8, 2002 at 9:13 am