Yes, if you alias the user to dbo it'll try dbo.object first. Easy way to test: create a stored procedure in Northwind owned by dbo and given execute to public.

CREATE...

More information on how to setup and secure Reporting Services can be found on Microsoft's site:

Reporting Services Technical Resources

You'll probably be most interested in the whitepapers...

Some other books for writing T-SQL:

Advanced Transact-SQL for SQL Server 2000, Itzik Ben-Gan and Dr. Tom Moreau

The Guru's Guide to Transact-SQL, Ken Henderson

Professional SQL Server 2000 Programming, Robert Vieira

Oops. I missed the part of the database name. Kathi and Yelena are correct, of course. If you're within the database, you're fine, otherwise you do need to specify the...

The whole catch on names involves how SQL Server does the lookup. If no owner is specified, SQL Server looks for objects in the following manner:

1) user.object

2) dbo.object

Therefore, if the...

Not in SQL Server 2000 unless you are speaking of the db_datareader and db_datawriter fixed database roles.

Based on the PASS briefing, you will be able to assign security at...

See answer here: Administration post

The user account used to run SQL Server must have sysadmin fixed server role membership, as does the user account used to run SQL Server Agent. What a lot of...

Quite a few shops still do. There's been no announced word from Microsoft on this one, so we'll just have to keep our eyes open.

Awesome news!!!

Hi Denis,

If when a stored procedure or view is created WITh ENCRYPTION, this technique won't work. However, with the ability to decrypt stored procedures so readily available, it doesn't do...

It was in SQL Server 7 by granting permissions to certain stored procedures. However, that mechanism was unsupported. I've not seen a similar write-up in SQL Server 2000. The problem...

and everything is set right in AD? Account can be delegated and the SQL Server (actual computer) is authorized to delegate?

That's a great book. Thanks, Steve, for mentioning it. You can't go wrong with that one. I wish a lot more administrators would read that or equivalent material.

Sorry, I didn't go back and look at the post, I had put servername and instancename in between greaterthan and lessthan signs, making it look HTML code...

try:

Servername\Instancename

(local) will try and...