dbMDFName = C:\main\ext\AssetTrackingExt.mdf;
dbLDFName = C:\main\ext\AssetTrackingExt.ldf;
string str = "use master \n GO \n sp_attach_db 'ATT'" + "," + "'" + dbMDFName + "'" + "," + "'" + dbLDFName + "'";
this is my backup database code but an error occur
"Incorrect sysnat near Go"
what is solution for this error
Loading

jayakrishnan MorayurPosted Jul 26, 2011, 7:04 AM
Suthish NairPosted Jul 26, 2011, 4:14 AM
Jaganathan BantheswaranPosted Jul 26, 2011, 3:16 AM
Try like this,
string str = "use master \n GO \n sp_attach_db N'ATT'" + "," + " N' " + dbMDFName + "'" + "," + " N' " + dbLDFName + "'";