Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by puthran
-
Receiving @@Error in VB
Hi, Please help me with this. I want to access the @@Error variable of SQL Server in Visual Basic. How can i do this ? My Stored Procedure is as follows : Create procedure stp_Test @Link int, @ErrorNo int Output AS Select * from datSurvey where Link = @Link If @@Eorr <> 0 Set @ErrorNo =...- puthran
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
Starting SQL Server through SQLDMO
Hi Zemp, Thanks for the reply. I have posted my code for your reference. Private Sub subStartServer(ByVal strServer As String, ByVal strDBOName as String, _ ByVal strDBOPWD As String) Dim objSQLDMO As New SQLDMO.SQLServer On Error GoTo ErrorHandler If...- puthran
- Post #3
- Forum: Visual Basic (Classic)
-
Starting SQL Server through SQLDMO
Hi, I have SQLServer2000 installed on a machine and i'm using it as a server. In the client machine i'm using SQLDMo to start the SQLServer service. When i use the start method i get an error 'Access Denied'. But when i run the same code in the server machine, it works fine. Can someone tell...- puthran
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
