Can All SS2000 Jobs Run As Owner Sa?

Sep 6, 2007

We have several servers, each with many jobs. Some jobs run as Owner "SA", and some jobs running as various domain admin accounts. We have been told to modify all jobs to run with Owner "SA". Now, some of the jobs read or write flat files and I am a little concerned about this. Does the domain account which starts the SS2000 services determine the rights to read and write files? If so, I guess changing all jobs owners to "SA" has no real risk?

Thanks!

Michael

View 1 Replies


ADVERTISEMENT

How To Allow Non-SysAdmin, Non-Owner To Run Jobs?

Oct 25, 2002

I need to have a NON-sysAdmin, NON-Owner to be able to run specific jobs.

I'm ok on the non-sysadmin part, but how can I allow someone to run a job she does not own?

Thanks
Michael

View 3 Replies View Related

Query/Report For 'Owner' Of All SQL Jobs

Nov 3, 2006

Is there a query/report that I can run against all our SQL servers to see who the 'owner' of each job is?

If so, can this be run in SQL Server Enterprise Manager 8, SQL Server Management Studio or Hyena?

View 2 Replies View Related

How Do I Do This In SS2000?

May 6, 2004

Hi all,

I have a simple query which returns all the names of products attached to a particular order.
select a.orderid, b.product_name
from orders a, order_items b
where a.orderid = b.orderidSay it returns this data: (sorry about the formatting!)

orderid product_name
===== =========
001234 Sweater (Black)
001234 Trousers (Large)
001234 T-Shirt (Pink)

What I want to do is, instead of getting 3 rows back, I want to roll up all matching values (of product_name) from the order_items table into a simple string seperated by a comma. So, for the data above I would get a single row with the orderid and a string containing something like this: "Sweater (Black), Trousers (Large), T-Shirt (pink)".

I'm sure there's an easy way to do this in SQL Server 2000 but I've not been able to work out how to do this and I couldn't see anytihng in SQL Books Online..

TIA for any help...

Mike

View 8 Replies View Related

Why Does Ss2000 Become Unresonsive?

Nov 30, 2007

Today an instance periodically becomes unable to accept connections. The service will respond to a service-shutdown and when restarted will accept connections for a minute or two but then refuses to accept connections or service active connections. We have gone through several cycles of this.

The log contains rows of :


2007-12-03 13:16:33.46 spid2 Process ID 55:0 owns resources that are blocking processes on Scheduler 7.
2007-12-03 13:16:38.47 spid2 Process ID 55:0 owns resources that are blocking processes on Scheduler 7.
2007-12-03 13:16:43.49 spid2 Process ID 55:0 owns resources that are blocking processes on Scheduler 7.

Any comments??

Michael (the perplexed)

View 1 Replies View Related

Db Diagram Of SS2000 In SS2005

Apr 30, 2007

I have MS SQL Server 2005 Developer Ed. and try to make a database diagram of remote MS SQL Server2000 database in MS SQL Server Management Studio.
I receive an error "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."

View 1 Replies View Related

SS2000 Performance - Unconvincing

Mar 3, 2003

Dear Listers,

Has anyone experienced performance degradation after converting / uprading from SS7 -> SS2000 ? .... wrt executing a reporting stored proc. that creates dynamic sql and makes extensive use of temporary tables.

If so, what measures were taken to progress towards a final resolution ?

Our scenario:

SS7 code was executed in isolation. ie. it was the only instance running on the box. When the SS7 job had completed, the SS7 instance was shutdown and the SS2000 instance was started .... then the SS2000 code was executed

- Identical h/ware (The SS7 and SS2000 were installed on the same box)
- Identical schema, indexes, triggers, views
- db files on identical RAID5 array
- Stats updated
- Tables reindexed
- data & procedure caches purged

Note that the temporary table(s) were NOT indexed.

TIA

John

View 1 Replies View Related

Some Data From SS2000 To Oracle : Options ?

Nov 12, 2006

Requirement: Some data (basically a SELECT) FROM SQLServer(2K) toOracle/Lnux on a CONTINUAL basis.Does NOT need to be Real-Time...can be like (Oracle's) Materialized View,i.e. automagically refreshable.What are my options in impleneting this process ?thanks--10gR2/Linux

View 1 Replies View Related

Migrating SS2000 DTS To SS2005 SSIS

Mar 11, 2008



Hello,

Is it possbile to migrate SS2000 DTS packages to SS2005 SSIS involving databases with compatibility mode set to 80. If yes, what are the potential issues, which may occur?

Sajish

View 6 Replies View Related

Can RS 2005 Read An SS2000 Database?

Sep 27, 2007

we have a 2000 db that we'd like processed by RS2005. We dont want to convert the db to 2005. Is this possible?

View 1 Replies View Related

How To Force Space Allocation To A SS2000 DB?

Sep 17, 2007

I have to force a space allocation to a DB file in order to stop a Diagnostic Manager alert which states that the database is over 80% full. Now, I don't think this alert is rational, nor do I think it is useful in any way but that's the way it goes. My only option is to allocate more space to the DB so that the space used will fall below 80% so the alert will stop being issued.
So, can you tell me how to force a space allocation on an existing db file?

Thanks,

Michael

View 1 Replies View Related

SS2000 To SS2005 Transactional Replication Issues?

Nov 1, 2007

Hi,

We are implementing push transaction replication from Production SQL Server 2000 database to SQL Server 2005 reporting server and SQL Server 2000 Test server.
SQL Server 2000 PROD to 2000 Test is simple but from SS2000 to SS2005 I have following questions:
Is it feasible to create push subscription from SQL Server 2000 to SQL Server 2005 database?
When I am trying to setup publisher/subscription properties, It only give me options to pick SQL Server 7.0 or 2000 or heterogeneous databases.
When I am trying to register SQL Server 2005 database in EM of SS2000 it don't allow me to add it and through exception that I need to use Management studio, Is there any alternate way to register?

Thanks
--rubs

View 1 Replies View Related

SS2000 Shows Password In Icon Tooltip

Jan 15, 2007

My co-worker, no idiot, says that the tooltip in the system tray forthe SS2000 icon usually shows the computer and server, but once in awhile shows the password (two slashes and the password).Is this a known bug of some sort? It really shouldn't be showing hispassword. It's likely the developer edition, but still, that isn'tgood.

View 2 Replies View Related

Query Problem (w/ A Case Statement) In SS2000

Feb 15, 2008

In SS 2000 I want to create a sproc that returns the correct address block for a contact. I want to concatenate AddressLine1 and AddressLine2 if AddressLine2 has a value. When I run the following query I get an error (below):

SELECT vwICPContacts.PersonID, vwPersons.PreferredAddress, vwPersons.Email1,vwPersons.email2, vwPersons.email3,
CASE
WHEN vwPersons.preferredAddress='Home Address' then
case
when (isnull([vwpersons].[HomeAddressLine2],'') = '') then [vwPersons].[HomeAddressLine1]
when (isnull([vwpersons].[HomeAddressLine2],'') <> '') then [vwPersons].[HomeAddressLine1] + Char(13) & Char(10) & [vwPersons].[HomeAddressLine2]
END
ELSE
case
when (isnull([vwpersons].[AddressLine2],'') = '') then [vwPersons].[AddressLine1]
when (isnull([vwpersons].[AddressLine2],'') <> '') then [vwPersons].[AddressLine1] + Char(13) & Char(10) & [vwPersons].[AddressLine2]
END
END
AS MailingAddress
FROM (vwPersons INNER JOIN vwICPContacts ON vwPersons.ID = vwICPContacts.PersonID) LEFT JOIN vwCompanies ON vwPersons.CompanyID = vwCompanies.ID

Error Message:
Server: Msg 403, Level 16, State 1, Line 1
Invalid operator for data type. Operator equals boolean AND, type equals nvarchar.

I've done this before but am completely stumped. Any ideas?

Jane

View 4 Replies View Related

SS2000 Error: No Mapping Between Account Names And Security IDs Was Done

Oct 25, 2007

Hello all;

I am trying to form a replication system but at the very beginning i couldn't pass an obstacle.
While trying to create the Replication it says i have to change the user which starts the SQL Agent because the current starter user account is a system account and this will make the replication between servers fail.
"SQL Server Agent on OZN currently uses the system account, which causes the replication between the servers fail. In the following dialog box, specify another account for the service startup account."
I change it in the properties dialog box of the SQL Server Agent. The new account is the one I formed and granted accordingly. But it gives the following error when I try to apply the changes.
" Error 22042: xp_SetSQLSecurity() returned error -2147023564, 'No mapping between account names and security IDs was done' "

I tried many things, searched in the net, changed the owner of the database, applied new accounts, many grants, applied service pack 4, etc...

If anyone helps it will be very much appreciated. Thanks in advance...

View 3 Replies View Related

Best Way To Retrieve Oracle Data Into SS2000 Near Real-time?

Jul 19, 2007

I have no idea where to post this kind of question, so here it is!



I have a requirement to retrieve oracle 10 data into SS2000 in as near real-time as possible (stupid users!) and join with resident SS data for on-demand reporting. (We use SS replication to populate some reporting tables from other SS2000 instances and this has spoiled the users as well as the developers! )



I would like to know if there are any clever ways of doing this, or if a plain-old DTS package running in some kind of loop is the practical answer. 1 minute delay is probably too long . . . I don't know if data can be pushed from the oracle side. Or if we need to write a Service and use it to suck and push.



Any suggestions?



thanks!

View 1 Replies View Related

Getting Owner Name

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

DB Owner

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

Db Owner

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

Dbo Owner

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

The Owner Of The Table

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

Owner Of Db---------urgent

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

Change Owner To Dbo

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

DTS Job Owner - Urgent

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

How Can I Get Different Between DBO Owner And Another User?

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

Change Owner

Nov 4, 1999

How Can I change table's owner

View 2 Replies View Related

Database Owner - Sa Or ?

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

SQL Agent Job Owner

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

Change DB Owner

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

How Do I Get Table Owner?

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

Table Owner

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

Change Owner Of All Sps

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

Table Owner

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







Copyrights 2005-15 www.BigResource.com, All rights reserved