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 |
|
agapimu6969
Starting Member
9 Posts |
 Posted - 2007-12-19 : 17:14:12
|
| hi everyone,I have three questions. Maybe they are very easy but I am new in Sql server.1) I have a filegroup named fg and two files ndf inside it which named f_ndf1 and f_ndf2. How can i do for create a table and to put it in f_ndf2.2) Is it possible create a stored procedure and to put it in f_ndf1?3) If I do a query in ssms like select * fro table. This query is wrong and I received a error message. Which file log are errors written of the ssms query?Thank you in advances for your answers. |
|
|
RyanAustin
Yak Posting Veteran
50 Posts |
Posted - 2007-12-19 : 17:21:44
|
| Check out http://msdn2.microsoft.com/en-us/library/aa174545(SQL.80).aspx for explanation of file groups. Also #3 should be select * from table. But what error message are you getting? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-19 : 18:11:07
|
| 1. You can't specify file, should be in filegroup.2. No, it's always in primary filegroup.3. Sql doesn't write those kind of error message to user db. All system messages are stored in master..syscomments. |
|
|
|
agapimu6969
Starting Member
9 Posts |
Posted - 2007-12-20 : 05:45:10
|
| Ok, thank you very much. So when I have un filegroup with two files ndf, How does sql server manage this files when I put objects into filegroup where the new object goes to f_ndf1 or f_ndf2? You can tell me an article where it's explained well, the manage of files ndf inside filegroups. Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 15:48:59
|
| Sql will use both files proportionally, find details in books online. |
|
|
|
|
|
|
Files ndf