@ Nils and Steves

Yes, it now gives me the new field with old value.

BUT i want that to happen only once, like i dont want that trigger to act...

@@ Sergiy

Thank You Sir , I got to know how to look at inserted n deleted.

Just FYI the "using inserted" and "using deleted" is da part of comment

Not actual...

@steve-2

1)

Initially i tried an AFTER INSERT trigger but it gave an error of "Table is mutating"

Later i realized that it was dumb mistake since i was asking my...

I appreciate your curiosity.

Its just a sample table i created in my mind to post it here.

In fact i have a status in place of Age.

And I...

Thank You for ur advice, i will check it out.

Anyways i FOUND this Wonderful article which does my job a lot easier

Data dictionary in seconds .. I am thankful...

Thanks for the link i think that would be a great resource for me ...

i wish u can throw some light on my other question too

http://www.sqlservercentral.com/Forums/Topic932919-391-1.aspx

Thank...

<b>@@Dave Jones</b>

We are looking for high availability and scalability, and by using EC2 we can be less worried about buying our own servers etc.. Since ours is a small business..What...

@@Steve

I am using EC2.

Why cannot i run SQL Server Locally and put my DB files on Cloud?

So how can SQL Server and Cloud storage work together?

Reference to any articles and...

@@ Garadin

When you said the most expensive calculator. I have a question.

When we need to do some complex arithmetic in SQL Server .. while processing and filtering out the

data ?...

When you said the most expensive calculator. I have a question.

When we need to do some complex arithmetic in SQL Server .. while processing and filtering out the

data ? what...

Thank You, I got my answer.

@@Gail.. Thank You

@@Bradley: Yupe.. i too guess it should be near to Denormalization.

Anyways i will update you if i attend this interview.

It for people to access/add/update their Info.

Most of the time people do custom search in website..

We should run a select query and post the results to web.

I am also a newbie exploring things like you.

This is an awesome site which has the A-Z list of all

Service packs

Hot fixes

Patches

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Njoi

I got it WRONG

But i love this part of your reply to "awoodhouse"

Wrong, you have to use the most recent differential backup based on the full backup file you are...