Re: connection problem.
From: Bill Hollinshead (billhol@online.microsoft.com)
Date: 09/24/02
- Next message: Leon Parker: "Reading SysProcess System Table to find idle processes"
- Previous message: Ing. Juan Manuel Alegrķa B.: "How to execute script.sql from VB6"
- In reply to: jimmers: "Re: connection problem."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: billhol@online.microsoft.com ("Bill Hollinshead") Date: Tue, 24 Sep 2002 19:02:34 GMT
In addition to fully qualifying the name (with object ownership), you could
sp_changeobjectowner so that @newowner = 'dbo' (but one should then still
fully qualify the name with 'dbo')
Thanks,
Bill Hollinshead
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no
rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
- Next message: Leon Parker: "Reading SysProcess System Table to find idle processes"
- Previous message: Ing. Juan Manuel Alegrķa B.: "How to execute script.sql from VB6"
- In reply to: jimmers: "Re: connection problem."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]