Really nice question.

And of-course nicely explain the answer.

Hi Cadavre,

Yes it works, Thanks for reply...:-)

Hi,

I m grateful to all of u for taking the time to offer help.

Thanks again to all of u.....

Hi,

Thanks for your reply...

There are some in-built sql function available in sql server like say;

DatePart, DateDiff and DateName which may help you out.

Plz refere the syntax from MSDN of above function.

Hope, it may...

Hi,

For that follow the below steps:

-> Go to "Tools" menu and click on "Options"

-> In the option window, click on "Designers".

-> Here now uncheck the checkbox which says: Prevent...

OOPSSSS!!!!!!:-P....

really so sorry....

-> Open table design in SSMS.

-> Select "Owner_Id" column and see the property at bottom side.

-> You can find "Identity specification". set it to "Yes".

That's it.

Yes, I completely agree with Gilamonster...

as he said - "You learn nothing if you get other people to do your work for you"

first try to find it by doing some...

Hi,

If possible, then convert yr query into stored procedure or make Views.

Otherwise it can't help u...

But what is yr actual requirement?

Hi,

Show me your initial query that u made to accomplish this task.

Jayraj,

Try below script.

select name from sysobjects where id in (select sd.depid from sysobjects so, sysdepends sd

where so.name = 'My_DownloadComplains' and

...

Hi muthukkumaran,

First-of-all thanks for yr reply....

Yes, I check the error logs in sql server. Here below is the detail...

At 2.35 pm I got the below message.

[298] SQLServer Error: 4060, Cannot...

Yeah, I agree with CirquedeSQLeil, The lack of a column in the where clause makes none of the answers correct

Superb!! this is excellent introduction...Thanks Gail.

Waiting for yr 2nd and 3rd article...