Thanks for your reply Gail Show.

I want some guide lines reagarding what are the best practices we need follow. When we need to write the Remote query ( in the...

Thanks for the question learnt something new today 🙂

hi GRant,

Thanks for reply,

i tried to pass XML as parameter , event that is also thrown the error.. is there any other way we can pass the collection of items...

Hi stewart,

Thanks for you quick reply

for the first option it is difficult to use because in where clause we are passing the variables to filter the records.

for second option --

I...

hi steve,

Thanks for your reply. I have one more concerns here

i have two date parameter From Date and Todate i need to display the validation message

in the following use...

Hi GSquared,

thanks for your reply it is DNS problem i resolved it and also ima facing one more problem in safari ,UI disturbance.Like

calender control is not working in safari...

Hi Lowell,

Iam Getting this Error

Msg 15581, Level 16, State 1, Line 3

Please create a master key in the database or open the master key in the session before performing this...

hi Gail show and HowardW thanks for your reply.

I am looking something like encrypt and decrypt is there any other way in sql server we can acheive ?

Thanks and regards

Deepak.A

Hi Koen verbeeck,

What is CHECKPOINT , how to issue the CHECKPONT , how it will...

GilaMonster (2/10/2011)

---

deepak.a (2/10/2011)

---

Thanks for reply,if we use columns or * will it make any performance difference? and also

Like ex : if exists(Select 1 ... ) or if exists(select Top...

thanks dave for your reply and sharing nice article

Hi GilaMonster,

Thanks for reply,if we use columns or * will it make any performance difference? and also

using top 1 1 instead 1 will give better peroformance ?

Like ex :...

Nice Question .

There is a another way to Check that , using the below query

create table #testvm (ID int)

select * from tempdb.sys.objects where OBJECT_id= object_id('tempDB..#testvm')

drop table #testvm

Thanks & Regards

Deepak.A

hi,

Nice Question . Can u pls provide the reference links to understand more about this.

Thanks

Deepak.A

this is the one of the way to handle those error.

DECLARE @sortby VARCHAR(10)

SET @sortby='String2'

SELECT String1, String2, Date1

FROM (

SELECT 'StringValue1', '2',...