I do not. The question fails to specify the version and the answer requires use of an undocumented and potentially unsupported procedure.

-- Mark D Powell --

Thanks for the update. -- Mark --

Being as I am only a part time SQL Server DBA and do not code T-SQL or any other SQL Server applications when would you need to use a function...

Second attempt to post. Page cannot be display on first.

On my SQL Server 2005 system I was able to run the query:

select createdate,*

from dbo.aspnet_membership

order by createdate desc

without error. ...

I agree the use of the word "only" means the statement precludes any of the other answers from being chosen at all.

I got it right but I assumed that the...

Naturally I cannot remember where I read the articles I would like to reference but I did find the following:

Academic sytle paper

Data Extraction and Ad Hoc Query of an Entity—...

There is a good deal of information on the web explaining why the EV model does not scale and does not perform well under load.

No amount of indexing will fix...

I agree with Joshua. If a non-default setting was chosen when the role was set this should have been specified either in the question on in the answer by...

Yes, this code does compile. Thanks.

Yep, nothing but syntax errors. I notice some odd single quotes at points by themselves then I have an undefined variable Mark not preceeded by an "@" symbol.

Mark should...

But according to the doc you can update Access from SQL Server. My guess why the column labeled distributed transaction is marked "no" may be because two-phase commit is...

Blask it I was thinking the author messed up but Exchange Server is marked as not being able to be used in a distributed query in the SQL 2005 documentation...

What version of SQL Server is this for?

Using SQL Server 2000 SP4 if I follow the execute directions I get procedure not found errors. If I change the database...

The solution of runnind sp_dropserver and sp_addserver is a lot better than the solution I found at MS which was to rename the server back, drop the maintenance plan jobs,...

From the reference "The Replication Merge Agent is an executable that applies the initial snapshot held in the database tables to the Subscribers"

That looks like the first answer to me.

Can...