SQL Server datafiles folder

[JaymeJeffman]

Hello.

This is my first time with SQL Server.
Is there a way to use different datafiles folder in SQL Server, like Oracle does. Do SQL Server has the concept of "tablespace"?

 

[bborissov]

You can create database whenever you want. Just not use CREATE DATABASE [name]. Because that will create database in default for SQL Server folder. Check the BOL for FULL command syntax. BTW you CAN'T create with the same alias.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.