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 |
|
neerav.saini
Starting Member
9 Posts |
 Posted - 2009-07-01 : 03:28:21
|
| hi all,I have imported data from another database 'northwind' to my database 'TESTER'.Before importing i have selected filegroup '2' as default which contains ndf file.After successful transfer of data i change filegroup.I have few question 1.why transfer data is visible in changed filegroup '3' after setting it as default2.i have usedCREATE CLUSTERED INDEX [cluster_index] ON [dbo].[Categories] ([CategoryID])with drop_existing ON [3].After this query i drop my index.Then how will i test that my data in filegroup '2' has been transfered to filegroup '3'Thanks,NeeravThanks,Neerav |
|
|
|
|
|
data on one filegroup