Can all SS2000 jobs run as owner "sa"?

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Access project connecting to SQL 2005 I don't fully understand the issue that you hit, but here's an example of how you can separate tables and views in different schemas and grant permission on the views schema, so that a user can select from the views, but not from the tables: -- create a test database and a test login&user -- create database test use test create login alice with password = 'Vl&cptn1cf0' create user alice -- create separate schemas for tables and views -- create schema sch_tables create schema sch_views -- create a table and a view that selects from it -- select will work due to ownership chaining -- because both schemas are owned by dbo -- create table sch_tables . t ( answer int ) insert into sch_tables . t values ( 42 ) create view sch_views . v as select * from sch_tables . t -- allow alice to select from the schema sch_views -- grant select on schema :: sch_views to alice -- now test that alice can select from view but not from table -- execute as login = 'alice' -- this select will work -- select * from sch_views . v -- this select will fail -- select * from sch_tables . t -- revert impersonation of alice -- revert -- cleanup -- use master drop database test drop login alice Thanks Laurentiu Tag: Can all SS2000 jobs run as owner "sa"?
  - 2
    - Filters - Report Builder Have you tried using 'LIKE' in your sql query and defaulting the first name to a %. This way if they don't enter anything all first name will be returned with the same last name. Tag: Can all SS2000 jobs run as owner "sa"?
  - 3
    - Connection Managers Area not coming up Do you have an Integration Services project opened Tag: Can all SS2000 jobs run as owner "sa"?
  - 4
    - How to make this query... I'm away from a SQL Server computer and i did not test the following but try it on a test table: delete from db_stockprices where symbolid in (select Symbolid from db_stockprices where Date<>@yourdatavalue) hth Tag: Can all SS2000 jobs run as owner "sa"?
  - 5
    - What is the best book to start from scratch? You might want to give a look to a similar discussion here. Also, there is a sticky here that is given as part of the "Getting started with SQL Server" forum -- the forum that you are in - that is listed as a learning resource. Also, books online for SQL server is a must have for reference. Tag: Can all SS2000 jobs run as owner "sa"?
  - 6
    - Mirroring on separete domains First, you have now posted the address of one of your servers on the internet for all hackers [ TCP://xxxxxxx:nnnn"] Next, check the firewall to be sure you are not blocked. Can you ping the server Tag: Can all SS2000 jobs run as owner "sa"?
  - 7
    - Trigger with access to remote server Setup a linked server on the server where youwant to place the trigger on and do your DMl operation on this using the syntax LinkedServer.database.objectname. As this is a distributed transaction you will need to have the MS DTC service running for providing concistency through the transaction. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Can all SS2000 jobs run as owner "sa"?
  - 8
    - problems at beginning of set up Try this, Go to Control panel-->Administrative tools-->Services You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there] Tag: Can all SS2000 jobs run as owner "sa"?
  - 9
    - Trigger? This trigger will work for an insert only. You'll need to add FOR INSERT, UPDATE to make it work for an update statement CREATE TRIGGER tr_TriggerName ON TableName FOR INSERT AS BEGIN DELETE tbl FROM TableName tbl JOIN INSERTED i ON tbl.PrimaryKeyField = i.PrimaryKeyField WHERE CONVERT(varchar(10), OrderDate, 101) = '01/01/1900' END GO Of course, instead of doing this, you could always create a constraint on this field that doesn't allow that date. Tim Tag: Can all SS2000 jobs run as owner "sa"?
  - 10
    - Report connection fails with DNS name No replies yet We are stuck up with this issue since quite some time. still waiting for some positive inputs. Tag: Can all SS2000 jobs run as owner "sa"?
  - 11
    - Creating Stored Procedure in SQLServer2005 You can create the SP in Query Analyzer i.e. Sql Server Management Stodio. In the query window select the database and execute the Sql code 'Create Procedure ...' Senthil Tag: Can all SS2000 jobs run as owner "sa"?
  - 12
    - Secure a single SQL Server database + Make float fields encrypted The comments below are focused on SQL 2000. Security is subtaintially enhanced in SQL 2005 with many improvements in the ability to deny even seeing the table names, etc. 1. Proper use of logins, database permissions, and roles, will allow you to have multiple databases on a single server, and prevent users of databaseA from seeing or accessing data in databaseB. (Users of DatabaseA will, however, be able to list the tables, views, stored procedures, etc., on DatabaseB -just not access the definitions. They will not be able to alter the stored procedures or make SQL Backups. 2. SQL 2000 does not have internal capability to encrypt data. There are thrid party products available. There are many 'unsound' encryption suggestions floating around, but it really can't be easily done without a third party product. (SQL 2005 allows strong encryption of fields as well as tables.) With all of this in mind, a local administrator (or domain administrator) could easily take the database offline for a few minutes and make a copy. Then by attaching that copy to another server, he/she would have relatively easy access to all data. There is no simple method to protect a database from local administrators that are inclined to defeat your security. On another point, you will find, over time, that float is the wrong datatype for currency -use decimal instead, unless of course, you are dealing with amounts as large as the national debt. Bottom line: If you can't 'trust' the administrators, you have a problem. Tag: Can all SS2000 jobs run as owner "sa"?
  - 13
    - Stored procedure assembly Error YOu wil lhave to impersonate the user doing anything that needs permissions across SQL Server. http://msdn2.microsoft.com/en-us/library/ms345105.aspx Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Can all SS2000 jobs run as owner "sa"?
  - 14
    - Referencing a conditional column in the WHERE clause -- Possible? Unfortunately, you can't. You are creating an ALIAS for an expression, and the expression is not 'known' by that ALIAS in the 'acquisition' part of the query. Once the data is acquired, you can refer to the ALIAS in the ORDER BY because a 'derived table' has been determined. You could, however, wrap this query in another, and use the ALIAS in the outer query. That does't provide much help with filtering though... The 'best' option is to repeat the CASE structure for Actual_Latitude in the WHERE clause. Tag: Can all SS2000 jobs run as owner "sa"?
  - 15
    - Returning resulsets between procedures !! Jortiz: You have to use a temp table instead of a table variable to receive your data. create a temp table instead of declaring a table variable; you are not allowed to use a table variable for what you are attempting. Dave Tag: Can all SS2000 jobs run as owner "sa"?
  - 16
    - Communication between tasks in an SSIS Package Fahad349 wrote: Hi, Also, How could I make the file path of Flat File Source or Connection manager dynamic or configurable through some file Fahad Look at package configurations. The forum search will be your friend. Tag: Can all SS2000 jobs run as owner "sa"?
- Next
  - 1
    - Lookup problem. The cached Lookups are case sensitivite, while non-cached Lookups use DB collation rules to match data, this may cause different behavior. A common workaround is to force case of the data in caching SQL statement and in the incoming data (e.g. make both upper case). (update) See also another recent thread on same issue: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2105670&SiteID=1 Tag: Can all SS2000 jobs run as owner "sa"?
  - 2
    - rsreportnotready Hello Senthil, In the report properties execution tab, check the box for 'Create snapshot when the apply button is pressed', then press Apply. Hope this helps. Jarret Tag: Can all SS2000 jobs run as owner "sa"?
  - 3
    - My first Trigger_Delete field We can help you with a TRIGGER, but first it would help us to have a more thorough description of your intentions. (The above is a bit confusing and contradictory.) Is the record deleted What indicates that a 'person' is terminated Why is the significance of '01/01/1700' If the purpose is to set the date to NULL, what is the significant action that should cause that change Does this "someone manually deletes it" mean the record or just the date Tag: Can all SS2000 jobs run as owner "sa"?
  - 4
    - Updating table issue Can you post your select and update statements, along with some sample data Tag: Can all SS2000 jobs run as owner "sa"?
  - 5
    - Problem with dates format passed as parameters... where are you switching the dates. may be create and set a workflag and set it to 0 or 1 based if its 1 dont do anything if its 0 switch the dates to american format. so even if the user clicks the view report again, it will check for 1 and does nothing. Thanks Kishore. Tag: Can all SS2000 jobs run as owner "sa"?
  - 6
    - Assing Report Parameters Did you just curse I'm not even sure what you're asking. It's too general. What are you trying to do Tag: Can all SS2000 jobs run as owner "sa"?
  - 7
    - Set DefaultMember for Time Dimension I think your issue might be explained in Mosha's blog post here:http://www.sqljunkies.com/WebLog/mosha/archive/2005/12/31/cube_init.aspx If I am right, basically you would add a statement something like the following to your MDX script: ALTER CUBE CURRENTCUBE UPDATE DIMENSION [Data Set Date], DEFAULT_MEMBER = Tail(NonEmpty([Data Set Date].[Date].MEMBERS),1).Item(0) Tag: Can all SS2000 jobs run as owner "sa"?
  - 8
    - SQL Server service pack question You need to use x86 version, the 64 in file names refers to the version of SQL Server. But I am curious, why did you choose to use 32 bit version if you have 64 bit OS - seems like you are throwing away both performance and scalability... Tag: Can all SS2000 jobs run as owner "sa"?
  - 9
    - Make a field unique ALTER TABLE myTableName ADD CONSTRAINT constraintName UNIQUE (myField) Tag: Can all SS2000 jobs run as owner "sa"?
  - 10
    - Database File refer these http://www.mssqlcity.com/FAQ/Devel/move_tables.htm http://www.mssqltips.com/tip.asp tip=1112 Madhu Tag: Can all SS2000 jobs run as owner "sa"?
  - 11
    - xml value method randomly returns null when assigning to a variable Does not repro on 9.0.3054. http://sqlservercode.blogspot.com/2007/04/stop-messing-around-with-sql-server.html for clarification http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx better yet http://www.sqlservercentral.com/columnists/sjones/2960.asp This almost reminds me of O****e, who are re-releasing CPU patches once in a while just before the next one. Tag: Can all SS2000 jobs run as owner "sa"?
  - 12
    - Dropdown - multi-select won't show values if only one item is available Weird, because I cannot make that happen. I created two dropdowns with items that are each way longer than yours, the second one is dependent on the first and has only one item, and I don't get that scrollbar in the dropdown, the page just becomes wide enough for the dropdowns and I have to scroll the whole page across to see the second dropdown, but it displays fine. I tried it in Report Manager, then I tried it in the Report Viewer and there it also works although it looks a little different. Instead of the whole report getting wider, just the parameters section gets wider, so I have to scroll it, but again the dropdown is full width. I'm using Reporting Services 2005 with SP1. Tag: Can all SS2000 jobs run as owner "sa"?
  - 13
    - Auditing table data changes Moving to Transact-SQL from SSIS. Tag: Can all SS2000 jobs run as owner "sa"?
  - 14
    - SQL Server 2005 SP2 x64 crashes...LazyWriter: warning, no free buffers found. With the information available my best guess would be memory pressure. The lazy writer process flushes pages to disk and releases them from memory. Could you run the following queries and post the results: Code Snippet select name, type, single_pages_kb, multi_pages_kb from sys.dm_os_memory_cache_counters Code Snippet select * from sys.dm_os_performance_counters where counter_name = 'Lazy writes/sec' WesleyB Visit my SQL Server weblog @ http://dis4ea.blogspot.com Tag: Can all SS2000 jobs run as owner "sa"?
  - 15
    - Help on one colum Use the following query.. Select Replicate('0',10-len(Convert(Varchar,ColumnName))) + Convert(Varchar,ColumnName) From TableName Tag: Can all SS2000 jobs run as owner "sa"?
  - 16
    - Folders on Dimensions Hello! Yes I think you can. You have a property for each attribute called display folders in the dimension editor. Click on the attribute and choose properties. For calculations(display folders) you can go to the Script tab in the cube editor. Search for a small properties button at the top called calculation properties. HTH Thomas Ivarsson Tag: Can all SS2000 jobs run as owner "sa"?

SillyMS

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

Top

Re: Can all SS2000 jobs run as owner "sa"?

Allen White

With respect to accessing external resources, the service account which runs SQL Server Agent requires access rights to those resources for the job to be successful. The owner of the job has no effect on those rights.

HTH.

Top