Thanks All. I did not require execute permissions. However the problem resolved after granting VIE DEFINITION permission to the users.

Execute permissions denied. I am checking again with giving view definition permission on the database.

Good question.

Thanks vk-kirov for the explanation. However still would like to know the sequential execution of the last query.

My apologies. It has UNIQUE CLUSTERED INDEX as well with IGNORE_DUP_KEY = ON, on columnsPriority, EmpNo, EmpName, EmpReport. However I want uniqueness for columns EmpNo, EmpName, EmpReport only.

I tried this function with almost same code but seems its not giving all the records. Also after the first record all records are coming with a space in the...

Yes Chandan. We were able to do telnet as well. Got the issue though. We tried connecting using FQDN and it worked. we used the server name as ServerName.DomainName.com. But...

Apart from the issue arising from mirroring/log shipping, can there be any other issues ? I considered the drive difference already. My concern is with any performance by having data...

So in case if tables are striped across files, will there be any downsides of moving any one of the file to some different drive ?

I ran following command on both servers:

select isdate('1/1/11')-- Gives 1 on both servers

select isdate('31/1/11')-- Gives 0 on 2008 but 1 in 2005

select isdate('1/31/11')-- Gives 1 on 2008 but 0 in...

Thanks Michael for the query. The query giving same result for the SELECT. however difference shows in result for DBCC command. Dateformat is shown as dmy and mdy as well...

GSquared, I mentioned "In 2005, it was returing 1 while in 2008 the same value returned 0"

Both you guys said same thing. My question is the result varying in sql 2005 and 2008.

select isdate('01/01/2011') or isdate('01-01-2011')

-- giving 1 in sql server 2008

select isdate('01/01/2011') or isdate('01-01-2011')

-- giving...

Is there a way to set it serverwide or database wide ? Or i'll have to put setr dateformat statement in my every procedure/query ?

Well, I sorted out the issue. It was required a fully qualified name and thereafter, BANG. It worked.

It worked for me. Apologies for late reply.