New MSSQL Database

[jimbo]

Hi

I have a pro account and i want an MSSQL database being set up, my question is: is this database only to be queried by one website only? As in none of the other websites will have knowledge of this db? If this is true can i move it from one site to another if i end up closing the site that uses it for example?
Also what version of SQL is it? If i want full text search on it, is this provided as standard and then all i have to do is set up full text catalog/indexes etc?
Few questions a bit rambled i know but its friday afternoon!

[Darren]

Hi Jimbo, the database can be accessed from any of your sites (assuming you have the correct connection string). We use SQL 2005 at the present time, and full text search should be enabled, contact us if there are any problems.

[jimbo]

great thanks Darren, the control panel tells me i need to contact an admin to get the DB set up. Would i just set up a support ticket as and when?

[Darren]

Hi jimbo, that's right - just let us know your required database name and a password in the support ticket, and the site you want it added on (for our records - so we can resolve which databases belong to which accounts etc) and we'll create this for you and let you know the connection details.

[jimbo]

Great thanks again for the help, i'll drop you guys a line in the next few days