low and high depend on your system. I've had 11k/sec for some systems that maxed the server and 100/sec for other systems.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 -...

Got to some job that is running it. Could be a job running from somenoe's desk as well (scheduled tasks). Run a trace (profile ) for that time and see...

you can also use the table datatype to return some data to the calling procedure though the suggestion above is the more straightforward way.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com...

done!!!!!

thanks for the note and complement.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Don't think so. You can probably apply for the Beta,http://www.microsoft.com/sql/evaluation/betanominations.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Boy, I don't have Yukon handy (on the road), but it seems to me that it performs pretty well. If you've used Visual Studio, it performs like that, pretty well....

Sure can. Set the permissions for each db as though it's the only db. If you need cross db joins, the user must be in both dbs adn you qualify...

You should be able to create a role, deny permissions to all tables for the role except the table you want and then do it that way.

Alternatively you could...

you could set default values in the definition of the parameters for the proc and then not pass anything in. Or check to see if you want defaults with and...

Also any network "drives" you have need to be mapped permanently WHILE YOU ARE LOGGED in as the MSSQLSERVER account. Not using your account.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com...

If there is a dos errorlevel of 0, then the query succeeds. The query in other words returns a 0.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I like it. Works well, data limited to the connection doing the work.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

No, our search sucks. We're working on it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Does this happen everytime? I'd run profiler in the background and see what is actually completing. This runs a number of commands.

You can also just run sp_who2 from QA and...

Monitor the service for up and down. I wouldn't monitor other items (CPU, disk wait, etc) unless you can set a limit of of like 3 failures over 15 or...