Scope Resolution Operator in SQL SERVER

Question

What is the significance of using Scope Resolution Operator (::) in SQL SERVER. As we all know when we are using GRANT command Scope Resolution Operator will be part of syntax.

GRANT ALTER ON Schema :: DBO TO user_name

Is there any specific meaning for it or it is used just like that.

Answer 1

refer,

http://sqlblog.com/blogs/kalen_delaney/archive/2006/09/06/186.aspx

it does not have any meaning check below query,

SELECT * FROM ::fn_trace_getinfo(default)

and if you execute without :: it still get executed.