More explanation in second column what data type it is, or can you post the structure of you table with these two columns ...

When you import data from Excel using wizard, the column with Date will appear in this format

yyyy-mm-dd hh:nn:ss.mss

so you can now select the imported table with formatting date...

Haa interesting route to DBA...anyway not bad recommendation! Hope to someone becoming DBA with your guide!

I agree with Lynn! Check my signature and why not to post the problem in the correct way and find the solution as better as we can!

I suggest you to upgrade in Windows 7, if you want to be comfortable with you SQL Server installation!

It will take long time if your table has lot of columns and many data types, here I'm talking for the structure of the table and all other objects related...

Ok, seems that you are in domain environment from your scenario, so you can do the database aliases in you DNS Server where you put the name for the SQL...

ekknaveen (12/1/2009)

---

I had two triggers update and delete on xyz table. I created another trigger for insert on the same (xyz) table. But this is executing after 5 minutes of...

First of All ...BACKUP everything that you have in SQL Server Express 2005.

After that, you can leave installed the SQL Server Express, and starting installation then migration to SQL...

You are welcome!

Steve Jones - Editor (11/19/2009)

---

I'll second Andrew's experiences. It's been a few years (6-7), but I worked in one place that had it and ran into it twice while consulting....

Sorry this is for you problem:

CREATE TRIGGER CANNOT_DELETE

ON YOURTABLE

FOR DELETE

AS

BEGIN

RAISERROR ('DELETIONS ARE NOT ALLOWED!!!',16,1)

ROLLBACK TRANSACTION;

END

The code above is for the auditing the deletions!

Anyway you have 2 alternatives to...

dastagirid (11/19/2009)

---

Sorry for this..

I have 10 records in a table.

Now i am going to delete one record in a table.

When i have to use trigger to restrict the delete...

can you post more info about your problem ...!? Better to answer with more information if we have..anyway check BOL!

http://msdn.microsoft.com/en-us/library/aa258254%28SQL.80%29.aspx

Ok just for info about this problem that I done everything with export and inserting data to the existing table but first deleting the old data then reseeding values and...