you create users and dbs in the same way as you do in SQL standard.

You may want to start by looking at books on line

http://msdn.microsoft.com/en-us/library/ms130214.aspx

there is a lot...

There are three ways that MS recommends, two you can do without restarting the server however you need to ensure that there is no activity happening in the...

Open the script and run it against database2.

Yes it works excatly the same way as standard SQL server,

However you will need to explicity allow remote network connections in the SQL config manager on the server

It sounds like your report server has not been setup correctly

have you run the reporting services configuration manager?

if so, are there green ticks on the first 6 items on...

Yes Isdate can handle all the above invalid dates and return 0 , it will return 1 for any valid dates.

This is fairly easy to test in SSMS

yes with SQL server express you can create SQL databases up to 4gb all for free..

have a look at the hotfix error logs there should be a message in there to indicate why there was an error

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

I have had a similar issue when connecting to MySQL i could connect fine but was unable to see the table definitions, I think it is a limitation...

Is SQL Browser running?

also as above, are you local or remote?

I have to ask;

Does your SQL server allow remote connections and named pipes?

you have to enable this in SQL server configuration manager

You can...

Okay well I would look at putting the log on a seperate disk if possible.

Is your transaction log running on its own disk?

I am not sure however that your performance issues are related to the t-log.

You should analyse the execution plan of the problem...

You could enter a default value in the value column the the variables window.

This should allow you to select the variable and the default value will be over written when...