Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-10 : 09:26:58
|
| CW Fok writes "I get a member list from Domain by Visual Basic Script in the SQL server agent as follows code. But How can I put those records into a table.Set Group = GetObject("WinNT://dmnclp/domain users")For Each Member in Group.Members If Member.Class = "User" Then end if next" |
|
|
fisherman_jake
Slave to the Almighty Yak
159 Posts |
Posted - 2001-12-10 : 18:26:59
|
| CW Fok, why don't you write an INSERT/UPDATE stored proc for the table you want to insert the data in.. Basically when you loop through the members you exec usp_IU_Tablename @field1, @field2, .. etc..Good luck..now the elusive drinking one... [guzzle], [drink beer], [drinkbeer], [skull], [down], [polish]==================================================World War III is imminent, you know what that means... No Bag limits!!!Master Fisherman |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-10 : 18:55:16
|
quote:
now the elusive drinking one... [guzzle], [drink beer], [drinkbeer], [skull], [down], [polish]
You're on the right track there Jake...  is even faster than those...-------------------It's a SQL thing... |
|
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2001-12-10 : 19:12:33
|
| Finally!!! Thanks for the tip Mark |
|
|
|
|
|
|
|
|
How to insert record into a table in SQL server agent with