Lowell (9/5/2012)

---

nzhang6666 (9/5/2012)

---

Just found out. The compatible level of the database is set to sql server 2000 (8.0).

I didn't know function can not be used in parameters of a table...

Lowell (9/5/2012)

---

i just tested it in 2008R2, 2005, and compatibility 80.

change your database compatibility.

EXEC dbo.sp_dbcmptlevel @dbname=N'SANDBOX', @new_cmptlevel=90

try it in tempdb if you want, and it works fine, since tempdb will...

Just found out. The compatible level of the database is set to sql server 2000 (8.0).

I didn't know function can not be used in parameters of a table valued function...

I got following error when compiling --1 (commented --2 and --3).

Incorrect syntax near '('.

Are you testing on SQL server 2005?

Hi opc, I saw your code. But actually I was not just seeing the results of the config statements. There are more logic after the config statements, which I didn't...

Thanks for the replies, I was on holiday so didn't come here.

Actually in my first proc (nz_test1) I just want to make sure to turn on 'xp_cmdshell' and 'ad hoc...

Hi Lynn,

I got the point. The receipt_id can not guaranteed to be ordered, if it's not the first column in the ordering columns. In this case the subtype is fixed,...

Hi Lynn,

Just compared the results and they are same.

I don't understand why you suggest doing this. I mean even the data is different but they are still ordered. As...

Thanks for the reply. I will be able to do some test next week. We will see. Thanks.

It seems trying to add timeout in openrowset is not doable. The workaround is to try to ping to the server use xp cmdshell 'ping -n 2 -w 3000 ip'...

so there is no way?

Thanks, that works!

I can use the sa account...