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 |
|
Laith Scofield
Starting Member
10 Posts |
 Posted - 2010-12-05 : 14:06:57
|
| what the difference between mdf files and sql files ?? both are opened in sql server management studio, and how can i add sql files up to my project in vb.net ???"It's fine to celebrate success but it is more important to heed the lessons of failure."Bill Gates |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-05 : 14:08:58
|
| An mdf file is the file that holds the data for a database and is accessed via the server.An sql file is a query saved from management studio. Not it's just a default and can be changed.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Laith Scofield
Starting Member
10 Posts |
Posted - 2010-12-05 : 14:11:32
|
| So can produce mdf files in SQL server studio ??? and how ?"It's fine to celebrate success but it is more important to heed the lessons of failure."Bill Gates |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-05 : 14:22:03
|
| An mdf file is created when you create a database.Right click on databases select new on the second tab will be the mdf file and ldf file that will be created to hold the data and log.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
sebekz
Starting Member
5 Posts |
Posted - 2010-12-06 : 03:25:10
|
| Please also note, that in case you need to copy/move MDF/LDF files (both are required for the database to work), you need to detach the corresponding database from the server first.================================================================Organize you SQL Serverwith a smart Management Studio PluginSQL Handy Groupie SSMS Add-In[url]www.skilledsoftware.com[/url]Create custom folders and group databases, tables, views, procedures, UDFsextending native SSMS functionality================================================================ |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-06 : 04:34:29
|
quote:
Originally posted by sebekz
Please also note, that in case you need to copy/move MDF/LDF files (both are required for the database to work), you need to detach the corresponding database from the server first.
Not quite true and not really relevant but if the database is detached and there is a single mdf and ldf then only the mdf should be required. The ldf will be rebuilt. It's one way of reducing the size of the ldf file.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
mdf files and sql files