Viewing 15 posts - 16 through 30 (of 311 total)
Thanks...DNA ,Meely (:P), Igor Brusetti & The_SQL_DBA ...
Jeff Can you please help me for the same...??
Cheers!
Sandy.
--
October 23, 2008 at 11:37 pm
Can you please brief the Commands also for individual points what you have nicely explained last post, So I can use directly....
Cheers!
Sandy.
--
October 23, 2008 at 3:14 am
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...
--
October 23, 2008 at 3:04 am
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...
--
October 13, 2008 at 7:45 am
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...
--
October 13, 2008 at 12:50 am
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...
--
October 12, 2008 at 11:16 pm
Hi,
lets assume the database is Old and sql 2000, so how can i update it?
Cheers!
Sandy.
--
October 10, 2008 at 6:10 am
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...
--
October 2, 2008 at 11:05 pm
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...
--
October 1, 2008 at 3:03 am
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...
--
September 30, 2008 at 11:30 pm
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...
--
September 29, 2008 at 5:04 am
Thanks John again to you...
Cheers!
Sandy.
--
September 11, 2008 at 1:52 am
John, its works for me...Even I tested it...
It is working for multiple user and multiple session too...for same time...
execute master.dbo.xp_cmdshell 'dtsrun /SserverName /UloginName /Ppassword /NDTSpackageName /M'
THANKS A LOT..
Cheers!
Sandy.
--
September 11, 2008 at 1:23 am
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.
--
September 11, 2008 at 1:03 am
Viewing 15 posts - 16 through 30 (of 311 total)