Hi,

Apex SQL also has a great tool. Called ApexSQL Doc. http://www.apexsql.com/sql_tools_doc.asp

Regards,

M

Hi,

This stored procedure appears only to select the Fullname, email address, time , login status and IP address of all events that happened between the begin datetime and end...

Hi,

I am preparing for the 70-444 now. I have completed the 70-431.

Is it ok to do the 444 wihtout first doing the 70-443?

Thanks,

Minette

Nevermind it appears to have been a faulty disc

One more thing

If you just want to add the database name the following will work:

EXEC

sp_Msforeachdb @command1 =

"Select o.name,u.name,'?'

from ?..sysusers...

Hi,

May I ask why are you using an undocumented procedure? Why not just write your own loop?

I don't think your query is right, since you are not joining to...

Hi Daniel,

This is a different issue, but I think setting NOCOUNT to ON should fix this problem.

For some reason it thinks that when it receives the rowcount ,...

Hi,

This is actually caused by your settings if you add the following to your procedure it should work.

SET

FMTONLY OFF