Thanks...DNA ,Meely (:P), Igor Brusetti & The_SQL_DBA ...

Jeff Can you please help me for the same...??

Cheers!

Sandy.

Can you please brief the Commands also for individual points what you have nicely explained last post, So I can use directly....

Cheers!

Sandy.

But, One more thing here..

If I wants to do some DBA Activity like DBCC...If my Database is Online.. will it become a issue for my endusers.?

Can you please tell some...

Gail,

I think it needs more ground work to make it proper.

Let me think on this (perhaps this weekend) and come up with a quick solution to manage this type...

Gail,

I agree with you, but for that you need the know the inner and out proc too. rite?. and the DB contains more than 750 Procedure and Its not that...

Hi Steve,

I need this because in my application its necessary to know the dependency for the Stored Procedure objects. If this is the situation how can handle it. and for...

Hi,

lets assume the database is Old and sql 2000, so how can i update it?

Cheers!

Sandy.

it's my pleasure, Meely....;)

Cheers!

Sandy.

Gail,

I do agree with you, hope Meely clear now..

But still also i am not agree with a primary key on a Table variable for highly transactional table. which is gives...

Yes Gail,

I do agree with you for both the point you specified in above post.

Yeah, but table variables are treated the same in terms of the TempDB system tables and...

Gail & Meely,

I think Gail can better answer for this,

Well, As per my observation and understanding the Table Variable concepts. Its does not make more difference if primary key...

Milu 🙂

I can say its depends on the time when you develop your codes.

if you are using the table for highly transactional then you can go for Table variable...

Thanks John again to you...

Cheers!

Sandy.

John, its works for me...Even I tested it...

It is working for multiple user and multiple session too...for same time...

THANKS A LOT..

Cheers!

Sandy.

But If by mistake click twice even some validation for disable the button database going to halt condition. how to come over this situation.

Cheers!

Sandy.