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.

The main risks are that someone can access resources outside SQL Server using a shell and could potentially damage the server. For bcp out, I don't know of another way....

There are ways to query an hierarchy and they get easier all the time, but if you know there are up to 3 levels, I'd build 3 tables, linking each...

If you installed express, by default it doesn't take remote connections, only local ones. Might not be listening on a TCP port. Check the SQL error log to see if...

insert x

select case when count(a) > 1 then 'All' else 'group' end 'firstcol'

, secondcol

...

from table