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...

no. Data is not "archived". You'd have to build your own process for this.

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

also http://www.sqlservercentral.com/columnists/rsharma/enterprisevsstandardedition.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

Have you run a dbcc checkdb? I'd be curious to see if this shows up there. The latch issue might be fixed with a clustered reindex rebuild of the tables...

There is a minimum size to which you can shrink files, AFAIK, it's about the base level at which it was created. I'm sure you've run the shrink script a...