J
Jeff
Is there a way to backup and restore an SQL database with Vb.Net 2005
G
Guest
You can issue the backup command through T-SQL:
http://msdn2.microsoft.com/en-us/library/ms186865.aspx
J
Jeff
Can you direct me to sample code as to how to run T-SQl withing
Vb.net. Thank uou
Vb.net. Thank uou
R
Robin Tucker
Hi Jeff,
You should use the SMO libraries. A much more programmer-friendly way of
doing things:
http://www.sqldbatips.com/showarticle.asp?ID=34
Robin
You should use the SMO libraries. A much more programmer-friendly way of
doing things:
http://www.sqldbatips.com/showarticle.asp?ID=34
Robin
P
Patrice
Try :
http://msdn2.microsoft.com/en-us/li...client.sqlcommand.executenonquery(vs.71).aspx
The general documentation for ADO.NET is :
http://msdn2.microsoft.com/en-us/library/e80y5yhx.aspx
http://msdn2.microsoft.com/en-us/li...client.sqlcommand.executenonquery(vs.71).aspx
The general documentation for ADO.NET is :
http://msdn2.microsoft.com/en-us/library/e80y5yhx.aspx
G
Guest
Neato - totally forgot about these. I'm still stuck on SQL Server 2000
C
Cor Ligthert [MVP]
A code sample fom Ken,
http://www.vb-tips.com/dbpages.aspx?ID=53524c9b-096f-42da-a5da-eb3bdb382068
Cor
http://www.vb-tips.com/dbpages.aspx?ID=53524c9b-096f-42da-a5da-eb3bdb382068
Cor
L
Lloyd Sheen
Cor Ligthert said:
Cor,
Every time I go to that site (every link you provide) the site shows
info for a second and then changes to a blue screen with "Select a tip to
display (Show the Details).
On the link you provided above if I click the "Show" link I can see
"Select a SQLClient Tip to display" with SQLCRL: Create a custom function as
the only "tip"?
It is like my browser is out of sync with the site although I think it
is really the other way around?? I checked for cookies but can see none
that from that site.
Lloyd Sheen
J
Jeff
Thanks unfortunately the machine I am working uses Microsoft SQL
Server 2000
Server 2000
R
Robin Tucker
Jeff,
If you are using SQL 2000 you can always use SQLDMO. I'm not sure how the
SMO libraries ship - I know they aren't SQL 2005 specific, i.e. you can
still access databases on SQL 2000 with them. So those would be better, but
my older SQL 2000 project is using SQLDMO quite happily.
This is an example here (scroll down).
http://www.sqldev.net/sqldmo/SQL-DMO.NETEventsVB.htm
Robin
If you are using SQL 2000 you can always use SQLDMO. I'm not sure how the
SMO libraries ship - I know they aren't SQL 2005 specific, i.e. you can
still access databases on SQL 2000 with them. So those would be better, but
my older SQL 2000 project is using SQLDMO quite happily.
This is an example here (scroll down).
http://www.sqldev.net/sqldmo/SQL-DMO.NETEventsVB.htm
Robin
C
Cor Ligthert [MVP]
Lloyd,
Thanks I saw it, we will take action.
Cor
Thanks I saw it, we will take action.
Cor