sql script

[coder12345]

Hi,

I'm having trouble getting the sql script to create a non-existing database and then execute the script on it. I'm not exactly sure what the problem is, I am using the correct sa password. Any help would be greatly appreciated! Thanks!

[Alex_Ronquillo]

Please give more details about this. Are you getting some kind of error? Can you include the script you are using? What version of IA are you using? What OS are you using?

[coder12345]

I'm not getting any error messages, the database is just not being created and the sql script is not running.


IA7 WinXPSP2


****Updated****

Sorry, I thought I had attached this jpg. The problem that I'm having is that the database 'UserDatabase' is not being created.

File Attached:

untitled.JPG

[neillans]

Can you post *exactly* the command you are using (and your script)?

One thing that people always seem to forget, is before you can create a database you need to OPEN an already existing database - the typical one is the default "master"

[coder12345]

Sorry, I thought I had attached this jpg. The problem that I'm having is that the database 'UserDatabase' is not being created.

File Attached:

untitled.JPG

[Alex_Ronquillo]

I am not sure if (local) works for local installation of MS SQL. Please try "localhost" instead and let me know the result

[Gizm0]

I am not sure if (local) works for local installation of MS SQL. Please try "localhost" instead and let me know the result

It works. The default for MS SQL IS (local) not localhost or anything like that. It's either IP or (local).

Now, to the question. You forgot to OPEN a new database as neilans told you above. Please insert this "USE [Biodb] GO" before setting the date format. It's even better to create the database from within a script than leaving IA to do it.

[coder12345]

Hi,

Thanks for all the suggestions. =) I am still having some problems.

I tried "USE [Biodb] GO" and also "USE master GO" but the database 'UserDatabase' is still not being created.

It's even better to create the database from within a script than leaving IA to do it.

Where would be the a nice, reliable place to put this script? Should I do it within IA?
I kind of wanted to rely on IA to create this database for me since I'm not an SQL expert or anything. What are the pros and cons of relying on IA to do it for me vs. doing it myself?

Thanks!