>Thanks, I'd have to install sql express 2005 when I have already have sql
>server 2008. Not sure if doing that would upset sql server 2008 or vs
>2008.
>news:1D6E4CAD-3A2B-4ACD-8596-23E4354F692F@microsoft.com...
Quote:
>>unless you have the admin access to sqlserver you can not create a
>>database.
>>most likely your isp only allows an autoconnect (via a connection
>>string) to
>>a database you upload (app_data folder). this means you create the
>>database
>>locally, disconnect it then upload.
>>>
>>-- bruce (sqlwork.com)
>>>
>>>
>>"AAaron123" wrote:
>>>
>>>Wow!
>>>>
>>>I was expecting that I could programmatically connect and then create
>>>with a
>>>set of sql commands.
>>>>
>>>>
>>>I should have mentioned that I have SQL Server 2008, the host has SQL
>>>Express 2005 ( I have the free service, he has better for payers).
>>>>
>>>If the SQL Server 2008 script is OK to use on SQL Express 2005 (is it?)
>>>can
>>>I just remove the Go's from the script?
>>>>
>>>Thanks for the info
>>>>
>>>>
>>>"Lloyd Sheen" <a@b.cwrote in message
>>>news:OdxVR4aSJHA.3604@TK2MSFTNGP03.phx.gbl...
>>>>"sloan" <sloan@ipass.netwrote in message
>>>>news:%23Jo8QjaSJHA.1144@TK2MSFTNGP05.phx.gbl.. .
>>>>>What is "The Host"?
>>>>>>
>>>>>>
>>>>>"AAaron123" <aaaron123@roadrunner.comwrote in message
>>>>>news:OG0GXhaSJHA.4084@TK2MSFTNGP04.phx.gbl. ..
>>>>>>I want to create a database with one table on the host.
>>>>>>>
>>>>>>I can't user SQL Server Management Studio to do it so I guess I have
>>>>>>to
>>>>>>do it programmatically.
>>>>>>>
>>>>>>I have in mind that in the session start (or maybe application start
>>>>>>would be better) I'd check to see it the database exists and if not
>>>>>>create it.
>>>>>>>
>>>>>>The problem is that I have no idea how to do that.
>>>>>>>
>>>>>>Can you point to documentation of maybe show an example of how to do
>>>>>>that?
>>>>>>>
>>>>>>>
>>>>>>Thanks
>>>>>>>
>>>>>>
>>>>If you have SSMS on your development workstation you can do the
>>>>following:
>>>>>
>>>>Create your database on your test SQL Server.
>>>>Create your table on your test SQL Server
>>>>Script the database using SSMS (create option)
>>>>Script the table using SSMS (create option)
>>>>>
>>>>Use those scripts thru ADO.NET to create the database first and then
>>>>the
>>>>table. You will also have to ATTACH the newly created database. Also
>>>>note that the script created will have lots of GO's. You will have to
>>>>execute each set of commands between the GO's as SQL Server does not
>>>>know
>>>>what GO is.
>>>>>
>>>>You might also have to set permissions and ensure that the location of
>>>>the
>>>>database file is valid and accessable by SQL Server.
>>>>>
>>>>Hope this helps
>>>>LS
>>>>
>>>>
