Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - vbscritp Sql Impersonation

Reply
 
Old 02-13-2009   #1 (permalink)
Ok24


 
 

vbscritp Sql Impersonation

i have a vbscript to connect to the sqlServer
strDBServerName = "."
strDBName = "ScriptingGuysTestDB"

Set objSQLServer = CreateObject("SQLDMO.SQLServer")
objSQLServer.LoginSecure = True
objSQLServer.Connect strDBServerName

Set objDB = objSQLServer.Databases(strDBName)
WScript.Echo "Total Size of Data File + Transaction Log of DB " & strDBName
& ": " & objDB.Size & "(MB)"

How to i impersoante this to a specific user.
i tried
objSQLServer.LoginSecure = False
objSqlServer.Login = "UserName"
objSQLServer.Password = "Password"

but it didn;t work

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Impersonation Vs RunAs VB Script
Impersonation VB Script
How do IRead an Outlook Msg in vbScritp VB Script
Impersonation in Powershell PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46