Permission On Msdb

Feb 8, 2001

How would you set up a task run by user without sacrificing the alias permission on msdb (SQL 6.5)?

Situation:
I have set up a task for runing replication by a user with the alias permission on msdb in order for the user to run the task. And I do not want to grant the alias permission to the user for the security reason. But if I set it up by granting only the sp_runtask permission to the user on msdb I always got the message like "You cannot perform this action on a task you do not own."

Please share your workaround. Thank you ahead of time

View 2 Replies


ADVERTISEMENT

Sp_droplogin Gives Error SELECT Permission Denied On Object 'sysjobs', Database 'msdb', Owner 'dbo'.

Mar 19, 2008

Hi,

When I am trying to drop a user using following statement

--First remove access from all databases
Set @SQL =
'
USE [?];
if ''' + @login_name + ''' in (Select name from sysusers )
EXEC [?].dbo.sp_revokedbaccess @name_in_db = N''' + @login_name + ''';
'
Exec sp_msforeachdb @SQL
Print 'Access Removed.'

exec @ret_value=master.dbo.sp_droplogin @login_name

I am getting an error,

User has been dropped from current database.
User has been dropped from current database.
Access Removed.
No permission to access database 'model'.
Server: Msg 229, Level 14, State 5, Line 1
SELECT permission denied on object 'sysjobs', database 'msdb', owner 'dbo'.

Login dropped.

The SQL Version I am using is
-------------------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)



Please help me to solve this issue.

Mujeeb.

View 5 Replies View Related

Service Broker Is Disabled In MSDB Or MSDB Failed To Start

Nov 21, 2005

Whenever I start my SQL Express 2005 database, I get the following in the logs :

View 10 Replies View Related

SQL Server - Permission Issues : Execute Permission Denied On Object 'SprocName'

Dec 13, 2005

I have an application that uses Integrated Windows authentication. My Web.config looks like below
<add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" />
When users try to access my application, they get the below error:
Execute permission denied on object 'SprocName', database 'DBNAME',Owner,'dbo'
The Only way I  could get rid off the error is if I set DBO permissions for the user group on the databse.
Can someone suggest how to set up a security group with the ‘necessary’ permissions on SQL SERVER (ie read,write execute Sproc etc) and not too many extra ones, like DBO.
Thanks,
 

View 2 Replies View Related

Insert Permission Denied After Granting Permission

Sep 19, 2007



SQL Server 2005 anomoly?
In SQL Server Management Studio I granted specific permissions to user "A" to do Select, Insert, Update, Delete on Table "B" -
When I logged on as User "A" and attempted the Insert imto table "B" I got the following error:
"Insert Permission Denied on Table B, Database C, Schema dbo"
Is this a problem with the dbo schema?

Then I went back and created a stored proccedure "D" with the exact same Insert statement inside the procedure. I granted User "A" execute permission on the stored procedure "D".
I then logged on as User A and executed Stored Procedure "D". No Problem - stored procedure executed fine with the Insert.
I attempted the Insert statement again - straight SQL - as User "A" and got the same error as above ("Insert Permission Denied.....")
Strange behavior - cannot do a SQL. Insert even though user has permissions but can execute a store procedure with the same Insert statement.
What gives?


View 2 Replies View Related

Big Msdb ?

Jan 15, 2002

Hello
I have a very large base msdb, I do not arrive has to purify it with sp_delete_backuphistory, it is much too long, have another solution? thank you

View 2 Replies View Related

Msdb

May 10, 2001

Hi ,
I am facing a paculiar problem.I got some jobs scheduled in MSDB.They are running fine for some time. Yesterday when i tried to open the properties of a job from EM i am getting an error 'Select Into Bulk copy option not enabled'
Can anyone got this before? I appreciate if any one can throw some thoughts on this.
thanks in advancce
MM

View 1 Replies View Related

Msdb

Nov 6, 2000

I know that msdb is used to manage the job schedulers in sql server 7.0 ( job agent ). Does this (msdb) like other databases, where I can control its size, shrink it or expand it.

IF am backing up the msdb, and I errased all jobs scheduled in sql agen. Can I restore all the deleted Jobs by restoring the msdb.

Ahmed

View 1 Replies View Related

MSDB

Jun 15, 2000

Does anyone know how to fix this message?
Message: Could not insert a backup or restore history/detail record in
msdb.dbo.sysbackuphistory or sysrestorehistory.
I ran DBCC CHECKDB (msdb) and no errors were reported.
Thanks

View 5 Replies View Related

MSDB

Jun 6, 2002

Hi ,

I have a job called JOBA scheduled to run every 10 min.
Is there a way in Tsql that I can find out whether the job is currently running or not.Is there any table/field in msdb database that gives me the desired info.

TIA,
Kinnu

View 2 Replies View Related

MSDB Is Too Big

Dec 18, 2007

My MSDB is too big [about 14 GB]. When I closely looked all tables, here is what I found -

Top 3 biggest tables are -

sysmaintplan_logdetail - rows- 124923 - data - 13375456 KB
DTA_Tuninglog - 181658 rows - data - 163248 KB
sysmail_mailitems - records - 14227 data - 126208 KB

I am not a DBA, so if any one can explain in simple terms how I can cleanup this maintenance plan log detail without increasing the size of tempdb? How can I stop this database growing in the future?

I have only a gig of space left on that drive.

Thanks in advance

View 18 Replies View Related

MSDB Over 300MB!

Aug 19, 2002

I made a few changes to backup jobs. Within a few hours the MSDB grew to like 355MB. ANY ideas why this happened??

View 1 Replies View Related

MSDB Restore Help Please

May 12, 2001

I am trying to restore my msdb database after rebuilding my RAID, and reinstalling sql. I can restore my user databases fine, but my msdb gives me error 3132:
The media set for database msdb' has 2 family members but only 1 are provided. All members must be provided.

I really don't want to lose all my jobs, so any help would be appreciated. thanks.

View 2 Replies View Related

MSDB Problems

Feb 16, 2001

I have a problem with my MDSB database. After my nightly reboot, I received an error in my Lof File stating: Error 9001: Cannot file log device for msdb database. I looked and saw the msdblog.ldf, so I am alittle confused. I ran a dbcc checkdb, dbcc newalloc and dbcc updateusage on msdb, but I did not get any errors. I added an additional log file to try and fix it, but nothing has fixed it. I am perplexed because all my scheduled backups are failing.

Any additional advice would be helpful.

Thank you,
Jennifer Fleming

View 1 Replies View Related

Moving Msdb

Feb 29, 2000

I want to move the physical location of the msdb database on a SQL server. However I cannot drop the database with the drop database statement, even setting it to dbo use only and single user mode. I get an error message saying the database is in use. Obviously I do not want to reinstall the server. The reason I want to move it is because it is located in the default dir on the C: drive which is running out of space.

Any ideas.....

View 2 Replies View Related

Restore Msdb

Nov 13, 2000

hi, I already have jobs in the sql server agen. I want to copy all these jobs to another sql server, What is the best way to do it.
here what I am thinking to do
1. Back up the msdb from the sql server which has the jobs
2. restore msdb into the sql server where I need to create the jobs.


I got an error message, 15089 cannot change the 'single user' option of a database while another user is in the database.

But no one is in except me.? thanks for your input

Ahmed

View 5 Replies View Related

Msdb Full

Mar 20, 2000

Problem with Msdb
error 1105 can not allocate space in sysbackupdetail.
msdb has 1.0MB of database space available and 1.97MB of log space.
I intended to expand the database but must first expand the device. the available space for the device is -703. So I can not adjust and expand. Any ideas. My hourly dumps appear to be functioning if you view them ny expanding the device but tasks show them as failing.

View 2 Replies View Related

Msdb Restoration

Dec 7, 2000

Hi !

when i am trying to restore MSDB database from a disk backup it is giving an error saying
"Database in use.System administrator must have exclusive use of the databse to run the restore operation".
But i am not using msdb anywhere.when i see the processes under current activities i see an application named sqlagent-alert engine using the database.even after killing this process it reppaears and stops the restore operation.
so i stopped sql server agent and did the restore operation.It worked.
so is it necessary to stop sql server agent while restoring msdb?may i know the logical reason for it?

View 1 Replies View Related

DTS Tables In MSDB

Apr 3, 2003

Hello,

Can anyone tell me what tables are used to store DTS defs? When you create a DTS job, where does it get saved?

Thanks!

View 1 Replies View Related

MSDB Problem

Oct 27, 1999

when I am trying to restore a database from a dump device (device is mapped to other server) the following error occurs.

I tried doing checkdb and newalloc on msdb but it din't work.
Is there any problem if I truncate MSDB?

ERROR:
Could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphistory or sysrestorehistory. This may indicate a problem with the MSDB database. DUMP/LOAD was still successful. (Message 3009). NOTE: The task was retried the requested nu

View 2 Replies View Related

Sysbackupdetail In MSDB

Aug 30, 1999

The sysbackupdetail table in the MSDB database at our SQL6.5 installation has grown to over
50,000 rows, since we back up 25 databases every day. I've enlarged MSDB once because
of a space problem, and I'm wondering whether I can just delete the older entries in this table
to prune it, without dire consequences. MSDB has other history tables, and I'd like to handle
them all the same way.

If I mess with these tables, will the sky fall on me?

View 1 Replies View Related

Msdb Maintain?!

Nov 15, 2006

hi expertsss..
my msdb database is like 2gb big.. to me is really big.. so is there a way to maintain that? and how. ..
also.. my disk level fragment are bad on one of my drive (some datafiles in there and msdb is there too). is there any 3rd party tool i can use to do the defragment and set schedule ? please help thanks~

View 7 Replies View Related

Restoring Msdb

Jan 24, 2002

Hi,

I am trying to build a test environment for our production server. I backedup and restored all my databases. I had to copy the jobs too, so I backedup and restored msdb database. When I try to change any of the jobs, I get the following message.

"Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server."

I have no clue what this message is about. Can someone please provide me with some clues about how I can modify my jobs and get my test environment to work.

Thanks,
Rob

View 2 Replies View Related

Msdb Corrupt

Apr 28, 1999

After implementing a recommendation to perform dbcc checkalloc before nightly backup, I began getting the error below on msdb. Books Online suggests restoring from a known clean backup. We have only been using SQL Server for a few weeks and it seems that all our backups of msdb have the same problem. Is there any way of correcting this problem?


Msg 2521, Level 16, State 1
Table Corrupt: Page is linked but not allocated; check the following pages and table: alloc page#=3584 extent id=3816 logical page#=3816 object id in extent=8 (object name = syslogs) index id in extent=0

View 2 Replies View Related

Copy Msdb

Jun 28, 2002

I need to copy the msdb to another Server, same network, different Server Name. What's the best way to do this?

View 3 Replies View Related

Help MSDB Database

May 2, 2001

I have a new server setup running sql2000 as default instance. I wanted
to move all the jobs and dts packages from another server which is running
multiple instances of sql server. I backed up and restored the msdb database
to the new server and now I can't edit any jobs. I get this error?
can't edit or delete the job that originated from MSX server.
How do I fix this problem. Any help will be appreciated.

View 1 Replies View Related

Msdb Restore Help

May 14, 2001

I am trying to restore my msdb database after rebuilding my RAID, and reinstalling sql. I can restore my user databases fine, but my msdb gives me error 3132:
The media set for database msdb' has 2 family members but only 1 are provided. All members must be provided.

I just performed a normal database backup to disk, and i was able to restore the other db's i backed up the exact same way...
I really don't want to lose all my jobs, so any help would be appreciated. thanks.

View 1 Replies View Related

MSDB Suspect

Oct 14, 2001

I'm running Win2000/SQL2000 on a Compaq CL380 Cluster Server. After a powerdown to do a physical move, the MSDB is now marked SUSPECT. I have tried the stored procedure SP_RESETSTATUS, a DBCC consistency check, and also have restored the database from backup. The database still shows MSDB is suspect. What can I do? We can't get a good backup as long as it is still this way as it depends on the SQL Agent.

View 1 Replies View Related

Datefirst In Msdb

Sep 15, 2007

Hi

is there any option for changing the first day of week on all tables in msdb tables

i don't want to use set datefirst everytime because i live in europe

View 2 Replies View Related

Restoring Msdb

Apr 18, 2006

I need some data from msdb.dbo.sysjobs and msdb.dbo.sysjobhistory but I need it from a backup file.

I don't need to restore the msdb database, I just need some data from the backup. Everytime I try to restore it under some innocuous name like bills_db it tells me msdb is in use.

Is there a way to restore this db to some other name and retrieve data from it?

View 2 Replies View Related

Bad Page ID In MSDB DB

Jul 13, 2007

Hi All,
Greeting,

Sql Server 7
OS: Win NT

In the sql server logs i see the below error alerts

I/O error (bad page ID) detected during read of BUF pointer = 0x11e09e80, page ptr = 0x446b4000, pageid = (0x1:0x2c78), dbid = 4, status = 0x801, file = F:MSSQL7DATAmsdbdata.mdf..

Error: 823, Severity: 24, State: 1

Please help me in this.


Thanks in Advance
Adil

View 1 Replies View Related

Msdb Unavailable

Jul 13, 2007

I work on a SQL 2000 Standard server that is part of our SBS package. Two days ago we ran a set of MS updates on the server and the residual symptom is that DTS packages, the Import or Export wizard all will not run. The Sql Server Agent service runs under the local system account, however that was true prior to the updates.

The error when attempting to run an import is that the OLEDB connection object is not available. The error occurs when trying to use the Access driver or a DSN. Further investigation indicates that msdb could not be contacted.

Does anyone have an idea as to what might cause this and a workaround?
Thanks,

misdean

View 2 Replies View Related

Msdb..sysjobs

May 10, 2006

Recently we renamed one of the SQL Server 2000 Server from NAME1 to NAME2. In the msdb..sysjobs table the originating_server name is still the old name ( NAME1 ). As SQL server 2000 suports multiple instanaces it will not rename it back to local.

So my Question is If I update the sysJobs table's Originating_Server Column to the new Server Name ( NAME2 ) . Will I have any issues. Because I not able to make any changes to the Jobs as it throws an 14274 Error. I don't want to rename the server back to the original name and do all the process as its given in the MSDN Article.



Thx
Venu

View 2 Replies View Related







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