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.
| Author |
Topic |
|
alidad
Starting Member
3 Posts |
 Posted - 2006-09-21 : 12:29:46
|
| Hi, I"m new for sql server 2005 express, I have scripts file called "filename.sql" and when run script by going to open sql file in sql server 2005 express and run it. there is no error and run successful.But then I want to save that file under *.mdf where allow me to connect from asp.net in visaul studio.net.My question is how can I save to *.mdf from *.sql after I run script!if I could not be able to do that, how can I set up connect between asp.net files and "filename.sql" from the visual studio.net 2005!Andy other idea please help me thanks. is there is any other link where I can learn more tutorial!alidad |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-21 : 14:14:40
|
| You never save .mdf files, they are the database files used by SQL Server, they get created when you create a database and from then on SQL Server reads and writes them, you never read/write/open them yourself. If you do you will corrupt them and your database will fail.Script files contain T-SQL code that you execute over a connection to SQL Server.Try starting herehttp://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx |
 |
|
|
|
|
|
Run sql Script