RE: SQL Server 2000 permissions problem

2003-04-02 Thread Matthew Walker
> Ouch... I was hoping I could just run a stored proc :( Um I don't really know what I'm doing when it comes to SQL Server so bear that in mind ;-) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscript

Re: SQL Server 2000 permissions problem

2003-04-02 Thread Kay Smoljak
Matthew Walker wrote: > Can you dimply do a global search and replace any "dbo." In your code > with "" ? My code doesn't have "dbo"... My code doesn't have anything except tablename.field, and that's always worked on three dev servers and at least three production servers before :) In fact, I've

RE: SQL Server 2000 permissions problem

2003-04-01 Thread Matthew Walker
Can you dimply do a global search and replace any "dbo." In your code with "" ? > > Now that I've created the new database and populated it with the data, > > the local code can only access those tables that are owned by dbo. > > Trying to access one of Fred's tables results in "Base table not > >

Re: SQL Server 2000 permissions problem

2003-04-01 Thread Kay Smoljak
Kay Smoljak wrote: > I'm having some weird kind of permissions problem with our dev box SQL > Server that I've never come across before, which makes me wonder if > something has changed on the machine to cause it. So either a > permanent solution or a temporary work around would be fantastic. > Thi

SQL Server 2000 permissions problem

2003-03-31 Thread Kay Smoljak
Hi all, I'm having some wierd kind of permissions problem with our dev box SQL Server that I've never come across before, which makes me wonder if something has changed on the machine to cause it. So either a permanent solution or a temporary work around would be fantastic. This is using CF5. The