Dont' cross post.

Handled here: http://www.sqlservercentral.com/Forums/Topic436125-357-1.aspx

Right click, properties, remove the dbouse only option

If you need a result, send it back from the SP. A proc with an update statement doesn't generate a result set.

you can force one

create proc myproc

as

begin

update xx set yyy...

First, the 4 part naming convention is server.database.schema.object. The prefixes are everything before the object.

Second, I'd recommend that you create a view in one database pointing to the other object....

This is a windows issue, not a SQL issue. SQL takes it's time from the windows system.

Look up time servers. You should have a server on your network that acts...

HAVING is used with aggregates. I'm not sure what you mean. Are you saying something like

select *

from mytable

where ID = (select count(*) 'cnt'

...

In addition to above advice:

- Index primary keys and foreign keys.

- Do not assume the primary key needs to be clustered. Look at the queries that you...

If you are talking about the code behind built in XPs, this is code at Microsoft that they are not releasing. Or I haven't seen released. The XP is a...

I definitely agree with you on SSMS. I tend to use QA unless I need to see an existing object. I like quick, lightweight stuff.

Jim,

you are correct and if I...

Did you restart the service?

You should be able to start the service and run that query. It doesn't do much to the database and should complete quickly.

What's on your laptop? Enterprise only installs on a server operating system.

I'm not sure if you can install 2000 as a named instance with 2005. You might need to install...

Something much be blocking it. Stop the query and run it again.

You can't do it directly with a SPROC unless you are using xp_cmdshell. The job fires dtsexec, a command utility, which loads and executes the package. The way you're doing...

Can you connect with a Data Source from the client computer?

SQLAgent runs and accesses the computer on which it is running. You cannot remotely deploy the agent.

What do you want the Agent to do? Perhaps there's a way around it.