The SQLAgentUserRole might be just what you need. See BOL at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm

Hi Luke,

There should be a button labeled "Locations..." next to the local computer name after clicking "Search...". If you click "Locations...", you'll be able to see other computers in...

What you see there is the name and description of the step that the workflow applies to. Workflows don't have identifying names.

I think I was born with a DIY gene. I remember making toys out of scraps of wood in my dad's garage. In my teens, I installed car...

Yeah, I guess the trick for you is to decide which situation is most likely to happen and cause the most harm: developers increasing database size without telling you or...

You can see the levels of support here: http://support.microsoft.com/default.aspx?scid=fh;%5Bln%5D;lifecycle. Use the Product Lifecycle Search at the bottom of the page to see the support dates for specific versions.

Hi Sharon,

1. Yes, we run the trace on the server that is being audited. The trace rollover argument of sp_trace_create specifies that when the trace file reaches it's max...

If all he needs to do is backup a database, db_owner membership is overkill.

I found this article if you really want to generate a script:

http://www.dbazine.com/sql/sql-articles/cook10

It's the same Wizard no matter how you start it. See my advice about the Copy Objects option. It's one of three choices after you've specified the source...

Are you creating the tables as they're imported? Are you using the import/export wizard in SQL 2000 or SQL 2005?

In the the SQL 2000 DTS Wizard, you...

Here's what we run in a DTS package. You can put it in a stored procedure, a T-SQL...

Sorry, I missed your transformation requirement. Unfortunately, transformable subscriptions is a deprecated feature in SQL 2005 replication. That and the fact that some lag time is acceptable, makes...

To elaborate on Mani's reply, if you have a DTSRUN command, such as in a job or batch file, you may find the password after the /M argument (if the...

You could try a stored procedure with a KILL statement and EXECUTE AS a login with sysadmin or processadmin membership. Another option is to add developers to the processadmin...