Can't find objects

I have a database with a bunch of objects owned by a user named, "tims". I a
m
logged into SQL Query Analyzer as the tims user, but I can't locate objects
unless I use I qualify them with the owner name. For example,
exec sp_select_corridors #doesn't work
exec tims.sp_selelct_corridors #works
BTW, this was working before. I recently did a DTS import on another
database on this server. I am wondering if the tims login got messed up. If
so, how would I fix it?
Thanks!
- JohnnyI would drop the objects and re-create them, specifying dbo. as the owner...
"JohnnyMagz" <JohnnyMagz@.discussions.microsoft.com> wrote in message
news:8E5E39D7-E65D-44CB-81CE-DD5324A475FA@.microsoft.com...
>I have a database with a bunch of objects owned by a user named, "tims". I
>am
> logged into SQL Query Analyzer as the tims user, but I can't locate
> objects
> unless I use I qualify them with the owner name. For example,
> exec sp_select_corridors #doesn't work
> exec tims.sp_selelct_corridors #works
> BTW, this was working before. I recently did a DTS import on another
> database on this server. I am wondering if the tims login got messed up.
> If
> so, how would I fix it?
> Thanks!
> - Johnny|||Can you check if there is another sp with the same name?

> exec sp_select_corridors #doesn't work
Any error?
AMB
"JohnnyMagz" wrote:

> I have a database with a bunch of objects owned by a user named, "tims". I
am
> logged into SQL Query Analyzer as the tims user, but I can't locate object
s
> unless I use I qualify them with the owner name. For example,
> exec sp_select_corridors #doesn't work
> exec tims.sp_selelct_corridors #works
> BTW, this was working before. I recently did a DTS import on another
> database on this server. I am wondering if the tims login got messed up. I
f
> so, how would I fix it?
> Thanks!
> - Johnny

Can't find microsoft.sqlserver.execpackagetaskwrap.dll in Sept CTP

I'm trying to find the following reference for a VS2005 C# project but can't see to locate it on two of my machines which uses Sept CTP install (Ent & Dev) both with SQL2K already installed:

Namespace: Microsoft.SqlServer.Dts.Tasks.ExecutePackageTask
Assembly: Microsoft.SqlServer.ExecPackageTaskWrap (in microsoft.sqlserver.execpackagetaskwrap.dll)

The only thing that I can find is ..\Program Files\Microsoft SQL Server\90\DTS\Binn\ExecPackageTask.dll

Is that the same thing or am I missing something? Thanks.

It's in the GAC.

|||Thanks but I still can't reference it in my C# project. Is it referenceable or use within another namespace?|||

Try this:

Right click References --> Add Reference in your C# project
In Add Reference dialog select Browse page.
In File Name type:

%windir%\assembly\GAC_MSIL\Microsoft.SqlServer.ExecPackageTaskWrap\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ExecPackageTaskWrap.dll

P.S. You don't need it if you access properties using TaskHost.Properties[]

sql