You create a Job in SQL Agent, then Create a new Job Step.

Under the "Step Type" dropdown, select "ActiveX script".

There you will find options for running your VBS.

Personally, I would do it the way that Garadin is doing it. Just be sure to include an ELSE clause to reassign any uncovered cases:

UPDATE large_table

SET Field1 = ...

Well the most direct (and general) way is :

SELECT * from t1

EXCEPT

SELECT * from t2

Though it...

Since you cross-posted this to the 2005 Forums also, perhaps you should tell us what version of SQL Server you are running?

This is a duplicate post. Please do not cross-post, it just annoys us and gets in our way.

Please direct all replies to http://www.sqlservercentral.com/Forums/FindPost586437.aspx

Please do not delete posts. It just annoys everyone else.

Oh, and "how" random? Linear congruential differentiator random? Cryptographically strong random? More? Or less? Or in-between?

What range and what datatype?

jcrawf02 (10/15/2008)

---

Heisenberg is driving in his car and gets pulled over for speeding. The cop walks up to his window and asks "Sir, do you know how fast you...

Something like this. Test it first!

Update YourTable

Set FileName = Left(FileName, Len(FileName)-4)

Where FileName LIKE '%.TXT'

That depends on your goals, what you intend to use the collected data for, and what form of applications are running on your SQL Server now.

Here's a start:SELECT * FROM StagingTable S

Where Not Exists( Select * From TargetTable T

Where T.PK1 = Cast(S.PK1 as int)

And T.PK2 = Cast(S.PK2 as datetime)

)

jpowers (10/15/2008)This is what I find unconscionable. It ought to be a legal requirement that the consumer is advised if they qualify for special loan terms if they have...

Sorry, don't know.

Use "sp_changedbowner". for eample, to change the owner of the current database to "Albert":

EXEC sp_changedbowner 'Albert'(from BOL)