|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Registering by massive way sql servershi everyone,
Imagine you have 20 workstations and for each of them you've got to register by MMC around 30 sql servers. It's stupid to imagine do a registered one by one if you know that all of them have the same password and overall, you have a list containing the IP's file: 10.0.12.1 user tr1 10.0.12.2 user tr1 .... Sql25k is coming but not yet.... Thanks in advance, -- Please post DDL, DCL and DML statements as well as any error message in order to understand better your request. It''''s hard to provide information without seeing the code. location: Alicante (ES) why do you need to register all the workstations on all the servers? if
you're doing things on all workstations from all servers I would have thought you'd be scripting out changes anyway. Found this on the web; use VBScript and SQLDMO:
http://www.wardyit.com/blog/blog/archive/2006/02/18/85.aspx HTH, Stu thanks to both
-- Show quoteHide quotePlease post DDL, DCL and DML statements as well as any error message in order to understand better your request. It''''s hard to provide information without seeing the code. location: Alicante (ES) "Stu" wrote: > Found this on the web; use VBScript and SQLDMO: > > http://www.wardyit.com/blog/blog/archive/2006/02/18/85.aspx > > HTH, > > Stu > >  
Other interesting topics
assign a table to a path and filename?
CREATE ASSEMBLY failed because it could not open the physical file Help with a SQL Join statement can't seem to get my GROUP BY ordering right query timeout expired sequential file and Parent ID's nested queries Storing text files in a column xp_sendmail error query? |
|||||||||||||||||||||||
