Replication And DB Owner - ? For Ray Miao
Nov 23, 1999
Ray or Someone please help!
I have not aliased pager as dbo. Are you suggesting to try this? I want the replicated tables to show a db owner of 'pager'. Here is another description of my situation (I think the first one may have been confusing):
I have a Database named Page with 'sa' as the db owner. The objects (tables and sps) of this database have the owner 'pager'. This is the way the database is defined on the Publication and Subscription Servers. But, when the replication process is completed, the replicated tables on the Subscription Server have the owner 'dbo'. I want my replicated tables on my Subscription Server to have the owner 'pager'. So, that the 4 replicated tables will have the same db owner as the existing tables on the Page Database.
Is this happening because I have the NT trusted connection which points to 'sa' on the SQL Server? If so, can I change the trusted connection to point to 'pager'? I am just guessing at this point. I will continue to research this issue. Someone has suggested that I go into EM, Manage Logins, select 'pager', and put 'dbo' in the Alias column for the replicated database (Page Db) row. I will try this.
Thanks in advance, Kevin
-----------
If you alias pager as dbo, the object created by pager will show owner of dbo. This is the way sql6.5 works, but sql7 will show pager as owner.
------------
Kevin G. at 11/22/99 5:14:22 PM
I am in the process of replicating a table within a workgroup setup (not a Domain).
I notice that when the table is created on the Subscription Server the replication process is creating the tables with a db owner of (dbo). I want the tables to be created with 'pager' as the owner. 'pager' is already defined as a db owner in the source and destination database. In the Publication Server Source Database, 'pager' is the owner of the tables selected for replication.
How can I accomplish this? Currently, I am doing the following on both the Publication and Subscriber Servers: logging on NT as 'Administrator' and starting both services (MSSQLServer and SQLExecutive) with the 'sqlnt2' NT Login which is a member of the NT Administrators Group. The NT Administrators Group has been trusted to SQL Server on both machines.
I am using the NT4.0, SP3 and SQL Server 6.5 with SP5a.
Thanks in advance, Kevin
View 1 Replies
ADVERTISEMENT
Sep 13, 1999
Thanks. I worry about my setup information may be have some issue.I can't express it in word.so please tell me you e-mail address,i will send a document to you.
Some information may be useful,i had did same thing with another database,it's normal in 1 day.
View 1 Replies
View Related
Mar 8, 2000
I will try the mixed security tomorrow. I have in the mean time discovered that I am not able to use the odbcping.exe utility successfully. It returns the same 08001 error message (Specified SQL Server not found). Does this means that the problem is within ODBC? What are somethings that I can try?
Thanks, Kevin
-----------
You need mixed security, also check password of the sql service account on nt.
------------
Kevin G. at 3/8/00 3:21:47 PM
I have set up replication on two SQL Servers (6.5), SP5a, on NT 4.0 (SP3). The Distribution Task on the Publisher is failing with the following error:
08001[Microsoft][ODBC SQL Server Driver][dbnmpntw]Specified SQL Server not found.
I am using standard security in a workgroup environment. I have my trusted connection setup and I am using named pipes. I had this process working on our test servers but when I tried to implement it into production I received the above message. Please give me some ideas or things to try. What source can I use to look up the 08001 error?
Thanks, Kevin
View 1 Replies
View Related
Jun 5, 2007
A former employee at my organization created a replication job to back up our database. The developer has since left and his windows account was deleted. I'm now receiving this error:
SQL Server Scheduled Job 'Replication agents checkup' (0xFC17DD4EF8E5694E8B786EE54CF8AD0D) - Status: Failed - Invoked on: 2007-06-05 15:40:00 - Message: The job failed. Unable to determine if the owner (username) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user 'username', error code 0x534. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).
How can I fix this? I looked under the Replication folder but didn't see anything.
View 4 Replies
View Related
Mar 14, 2002
Ray!
I'm not DOS lover.
Can you write the command?
Thank you,
Elena.
Use dos copy command.
------------
elena at 3/13/2002 1:10:36 PM
Hi!
What should I do to copy backup file from remote server directory to my machine?
Thank you,
Elena.
View 2 Replies
View Related
Nov 14, 2000
And thanks to Ray for another frustrating response. Gentle suggestion, if you are going to hang out here you may find people appreciate a tad more detail than 'script it'. I consistently get a chuckle out of your responses.
View 5 Replies
View Related
Jan 18, 2001
Ray Miao is at it again ...( refer thread on " SQL 7.0 TEMPDB " for laughs )
John says his tempdb is growing, he cannot find a way of shrinking it other than restarting SQL Server. Ray Miao's $1.7 million answer ? Restart SQL Service !!
A simple theory should apply to these kind of forums. Be CONSTRUCTIVE !!? If you do not have a reasonably good answer for a problem, keep out !!!
View 3 Replies
View Related
Oct 8, 1999
Ray,
I see you answering questions out here all the time like I do, and had one question for you.
Are you really moving all of your user data from the primary (or default) filegroup into another named group like is discussed in the swynk column for up-to-the-minute recovery?
I am not clear on the benefit of doing this. It appears to me that the inability to restore to current would only happen if the primary group was corrupt, and I don't read that this happens very often.
Where are you on this issue?
View 2 Replies
View Related
Sep 12, 2002
Ray, I'm sending you this message because you have helped me (and many others) in the swynk forum, and I appreciate that. I just joined this new forum, and can't do a search using "SQL" because it doesn't have at least 4 letters. Is it possible that we have a SQL forum where SQL is not allowed in searches?? Are they kidding? Respectfully, Robert Boyd
View 1 Replies
View Related
Jan 5, 2000
Thank you Ray Miao, you are correct the NT Admin password was changed. Now I'm not sure what the best Startup Service configuration should be.
What are the implications of starting the service as a System Account vs specifing a specific account?
Thanks,
Paul
View 1 Replies
View Related
Jul 2, 2002
Can anyone help me with handy scripts/stored procedures to capture blocking info on the server? We have SQL 7.0 w/sp3.
Ray replied earlier saying that I can use so_who2!!, I think everyone knows that,please reply with some valuable info!!Please..
Thanks.
Sonali.
View 4 Replies
View Related
Mar 20, 2003
Hi,
I have a little problem regarding getting owner name of object. In my application, user is creating a table with no owner name. He is logged with some login other than 'sa'.
The table is created with db's default owner name (if no server roles specified for that login) otherwise it uses the login's owner name mentioned in db properties.
Please guide me if i want the correct owner name under which the table is created, shall i use CURRENT_USER for that?
Regards,
View 3 Replies
View Related
Aug 21, 2005
How to find out the login , that is the owner of the database .
I mean if i havea database say DB1
I want to find out , which login user is the owner of this DB
Thanks
View 1 Replies
View Related
Jul 23, 2005
Hi,I currently have two databases (DEV & TEST) with the same users butdifferent owners. The TEST database is on a remote machine with 2database users - USR1 & DBO. The DEV database is exactly the same.However, when I create procedures etc the DEV database recognises theowner as DBO and the TEST database USR1.I have made USR1 an owner on DEV and I login using the correctcredentials. However it still is not recognising this when creatingprocedures.This is very frustrating when doing a SQL Compare as it thinks thestored procs are different!I have done a sp_changedbowner and this didn't work. There must beanother config value that need changing?Any ideas?Thanks.
View 2 Replies
View Related
Jul 30, 2007
We are using SQL Express and I have a problem with dbo.
On my machine if I logon to SQL Express using windows authentication
and create a new database I automatically have db_owner role membership
on the new database.
On a colleagues machine, if he logs onto his SQL Express using windows authentication
and creates a new database he does NOT have db_owner role membership
on the new database.
How come?
I have checked pretty much everythng - windows built in admins, SQL express sysadmin roles
service pack versions but I can not find any difference in setup.
What should I do to his machine/SQL Express setup so he automatically has db_owner role membership
for every newly created database?
Thanks
Charlie
View 4 Replies
View Related
Jul 27, 2006
Hello,
I need to user full name for the table as seen below.
SELECT @RowCount = COUNT(*)
FROM T1 c INNER JOIN [MyInstance].MyDB.dbo.T2 b ON c.T1_ID=b.T2_ID
T2 may be re-created by different users, how can I get this working for all users if the creator is not dbo?
View 5 Replies
View Related
Oct 17, 2005
hi: I get a database called"linlin".But the owner of database is not dbo or sa,but user "ss".I revert the database into my SQL server. When I use it with user sa, I need add linlin. before the name of the table and storage processes.But what influnce to do this? When insert ,update,delete something from linlin with user sa,is it OK?My SQL is personnal edition. Appreciate your help!
View 3 Replies
View Related
Aug 6, 2002
hi,
I just imported my access database into sql server 2000 and apparently during this importation the owner was set to my name. This gives my a problem retrieving the data in asp.net though. I found out that the problem (System.Data.SqlClient.SqlException: Invalid object name 'tablename') is situated at this ownership by stripping the query to a bare minimum and trying it on a new table created in sql server with dbo as the owner.
My problem now is that I can't seem to find the way to change the owner to dbo from 'peterj'. Can you help me on this one ??
View 1 Replies
View Related
Aug 17, 2001
Hi,
Is there any way to change the owner of DTS package after it has created?
Thanks..
View 5 Replies
View Related
Oct 5, 2000
How can I get different between DBO owner and another user when I select SP name from SYSOBJECTS? How to compare a SP's create by DBO and another user?
Example for, I want to list all SPs of DBO owner to excute my statement (as sp_changeobjowner...), but when I select all SPs in SYSOBJECTS to cursor, if there is any SPname's created by another user (no DBO), I'm getting error.
Thanks in advance,
J.K
View 1 Replies
View Related
Nov 4, 1999
How Can I change table's owner
View 2 Replies
View Related
Aug 6, 2002
I want 'sa' to own all the user databases. Currently the database properties screen shows the owner as myself, 'al', but the list from the Users tab in EM for the database doesn't list me, but lists the dbo as login name 'sa'. DB_changedbowner 'sa' says:
Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46
The proposed new database owner is already a user in the database.
BUT, who really owns the database; if it's 'sa' then why am I showing up on the properties page as the owner???
Thanks,
AL
View 2 Replies
View Related
Nov 7, 2001
Hi, can a SQL Server Agent job owner be a userid instead of sa? I tried to changed it to my own
userid with sysadmin role but the job wouldn't run unless it is own by sa.
View 1 Replies
View Related
Mar 2, 2005
I have several Production Databases on my SQL Server 2000 Standard Edition Server (mixed mode authentication) that I'd like to change DBO Permissions on. When I look at the Properties of the DB(s) from EM, the Database owner is showing up as a Windows NT USer who is no longer even with the company!!
Can I use the sp_changedbowner 'sa' command to change the database owner to sa without disrupting Production? Might sound like a dumb question.. but ya never know!!!!! Also, I had someone on another forum tell me that 'sa' as db owner is a bad idea but I don't know why??????? can anyone elaborate on that?????
View 5 Replies
View Related
Mar 9, 2005
I need to the table owner.
Not from in Enterprise Manager, but from my app. (it's written in Delphi).
Any suggestions?
Thank you,
Keith
View 2 Replies
View Related
Nov 24, 2005
Hi,
I've a database table named MYTABLE
It's owner is T01.
Now when I log on as MA I want to do a select like this:
select * from MYTABLE -- Gives me an error.
Select * from T01.MYTABLE -- goes fine..
I really don't want to specify the owner for every table. All tables have the owner T01.
Is it possible to use some statement before executing my sql statement.
Something like this :-=
Use owner T01
select * from MYTABLE.
Is it possible ?
//Martin
View 3 Replies
View Related
Aug 6, 2005
Hello,
I need to change the owner of all stored procedures from x to y. I know there is a sp_changeobjectowner sp, which does that, but in that way I will have to write a loop to get all sps which are owned by user x. Can somebody help me with that?
View 3 Replies
View Related
Aug 4, 2006
hi,how do i change the table's owner as dbo using sql server 2000 query.kalai
View 2 Replies
View Related
Jul 20, 2005
Hello there,Im trying to change the owership of the DTS package but am a littleconfused.sp_changeobjectowner changes the ownership of table, view, or storedprocedure in the current database...How could i change the DTS package ownership?Thank you in advance.Leo*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 2 Replies
View Related
Jul 20, 2005
Is there a system SP to change object owner in the DB?
View 1 Replies
View Related
Jul 20, 2005
I've got this question:Is it possible to assign the 'current owner' using a query like thefollowing one:set current schema OWNER1 (in DB2 sql, this allow me to reference the tableswithout an explicit indication of the owner (es: after this query I cansimply write 'Select * from dummy', instead of 'Select * fromOWNER1.dummy')).Thank youFederica
View 2 Replies
View Related
Jul 27, 2006
Hello,
I need to user full name for the table as seen below.
SELECT @RowCount = COUNT(*)
FROM T1 c INNER JOIN [MyInstance].MyDB.dbo.T2 b ON c.T1_ID=b.T2_ID
T2 may be re-created by different users, how can I get this working for all users if the creator is not dbo?
View 4 Replies
View Related
