I would be interested is seeing your errors.

Why don't you uninstall?

You should not have to reformat. Worst case scenario perform a manual uninstall.

You stated that the installation of the Management Studio Express takes you around in circles.

What happened after you installed SP1?

quillis131 (8/25/2011)

---

A Column from AS400 table is Empty (no value)..... this column is mapped to Sql smalldatetime data type column. I get an error saying that this column...

You problem sounds similar to the following.

http://www.sqlservercentral.com/Forums/Topic332680-324-1.aspx

Huh?

It is good to Consolidate Servers and sometimes to is better to have Databases isolated.

You hinted that it is important to be careful in determining what Databases can cohabitate on...

Yes you can download Express and there is a Graphical Interface which you can download.

http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

http://www.microsoft.com/download/en/details.aspx?id=22985

Personally I prefer the functionality of the Developer Edition. It only cost $49 for a Developer...

Christi Wilson (8/25/2011)

---

Can someone point me to a good article on derived tables vs temp tables in regards to performance?

I didn't want to start a whole new thread as...

tracmonali (8/25/2011)

---

I have got the backupfolder share. But the thing is if I follow the wizard to restore, it points only to the folder on the same server and not...

GilaMonster (8/25/2011)

---

That's not valid T-SQL. Case takes an expression not a value and there's no boolean expression 'INSERT' that says that the trigger was an insert.

If can be done like...

Who is Hugo?:-D

If you denormalized your database how can it be in 3rd normal form?

Typically you denormalize on a reporting version of the database.

Speaking of back in the saddle, I can't help but think of this song 🙂

http://www.youtube.com/watch?v=bDKxUt9UkmU

Please answer my questions in...

krishusavalia (8/24/2011)

---

Thanks for your response,

It was really helpful but the trigger you created is not worked for the UPDATE. when I am doing the update then it just inserting the...

Why don't you experiment with it?

http://msdn.microsoft.com/en-us/library/aa258254(v=sql.80).aspx

The following link demonstrates how to hande a INSERT, UPDATE and DELETE in a single Trigger.

http://technet.microsoft.com/en-us/library/ms189799.aspx