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
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.
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 RelatedRay 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 !!!
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?
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 RelatedRay 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
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.
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.
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