It looks like they are disabled by default with SQL Server 2008? I need to look somewhere else for my appilcation connection problem then.

No, I'm not domain admin on the server. Do you have to be to use Activity Monitor?

Thanks.

Ok, thanks. I understand that then. I was afraid it meant something in the Windows registry!

I got that error when installing sp1 on SQL server2008 standard ed. But I can't rerun it, it says sp1 is installed already.

How do I know if it's installed correctly?...

Thanks, I didn't think I had to restart services but didn't see it actually stated anywhere and wanted to make sure.

I was wondering how the max works in the max(case... portion of your example?

Also, what did you mean when you referred to this:

- you also need to take care...

I removed reference to the vstextid and it works good. Thanks very much for all the help.

Ok, I figured out the date,

exec spvisitstuff '2008-04-01' works!

Any help with building the loop through the id's is greatly appreciated though:)

Thanks!

I'm trying to run the stored procedure as you have suggested, without the subqueries and I have what I hope is not a dumb question. When executing the command to...

The purpose of @vstextid is to pass the TPM300_PAT_VISIT.vst_ext_id to the subqueries.

Maybe I'm making this more complicated than it needs to be.

The purpose of the stored procedure is to...

exec(@vstextid): Guess I thought it was needed to run the code. It was similar to an example I was trying to use.

And you're right this executes but returns no rows,...

Thanks very much for the quick response. The version and edition upgrade document on Microsoft site said it is possible, so I thought I would try. I'll probably have...

I have enabled SQL Agent service. What would I have to do to the permissions though? The other services work just fine.

Thanks!

I did end up uninstalling developer ed and installing standard. It worked just fine. I ran out of time to keep trying the upgrade method. I will try it...

I'm trying to get this command to work:

start /wait d:\setup.exe addlocal=SQL_Engine instancename=MSSQLSERVER upgrade=SQL_Engine skuupgrade=1 /qb

But I get error that the upgrade is blocked because the existing component is a later...