Maybe grant ddl admin, then DENY perms on the tables... It think that would work. In a car, so cant test presently. I guess you could use triggers,...

You can generate the statements to grant permissions on existing objects by querying off the sys.objects table where object type is P (proc) like this:

print 'go'

print '--object level perms'

select 'GRANT...

Another way to do this- if you have another SQL Server which is not Express edition, you can schedule maintenance jobs to run from that server.

That's typical. Your reinedexing is causing higher than normal transaction volume.

Some people choose to switch to bulk-logged recovery for indexing operations, but if you have the space, you can...

Can you please post the contents of the errorlog and the sqlagent.out... not just the error you think might be the problem, but the entire log around the time you...

I do something like this in Access07 .adp:

Dim Requestorid As String

Requestorid = Combo139.Column(1) 'for combobox... use .value for textbox

strsend = "exec PROCNAME @requestorid='" + Requestorid + "'"

CurrentProject.Connection.Execute strsend

I agree that scheduled job is the way I would go...I guess you could also use a logon trigger if you were looknig for an alternative approach.

logicinside22 (12/12/2011)

---

Hi Guys,

Like to know Best practices for Transaction Log you used for your enviornment.

Is it good to delete old transaction Log backup after having latest Full Backup and Differential...

You can also see "Agent XPs disabled" in SQL Server Configuration Manager... which is what I was assuming he was talking about... the suspense is killing me 😉

John Mitchell-245523 (12/12/2011)

---

Not just errorlog, but also sqlagent.out. If you don't have a sqlagent.out, then that's probably the problem - the service is configured to write to a folder...

abhishek_dwivedi03 (12/12/2011)

---

In my base machine , SQL server agent service is not coming up and is showing the error : (Agent xps Disabled ) .

I had done a fresh installation...

looks like this is a known issue, addressed in a CU / SP2: http://connect.microsoft.com/SQLServer/feedback/details/585210/sql-server-2008-data-collection-execmasterpackage-timeout

just stumbled across sysmaintplan_logdetail and sysmaintplan_log from which I think I'll be able to pull the data. thanks just the same.

Elliott Whitlow (12/8/2011)

---

I don't think they are stored in a table at all. Maintenance plans are SSIS pacakges and looking at the text of one I saved out I...

mpaulus-1000078 (12/6/2011)

---

I do not have forced parameter turned on. Thank you for your insight. I'm at a loss as well, that is why I posted. The SQL...