Using SQL script through vb.net code

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Using SQL script through vb.net code

Author

Topic

kfsehgal
Starting Member

6 Posts

Posted - 2012-02-15 : 13:04:43

Hi,
I am new to SQL Server. I often find scripts over internet to perform different functions with SQL Server but I donot know how to use them in vb.net.

For example I want to run the following code through my vb.net application, but donot know how to do so. Please advise

ALTER LOGIN sa ENABLE ; GO ALTER LOGIN sa WITH PASSWORD = '' ; GO

Thanks

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-15 : 13:20:45

Did you install SQL Server Client Tools?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-15 : 14:53:22

why do you want to do these admin related tasks through vb .net? you should be doing this through SQL servers client tool management studio

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources