1. If you've got a DBA on staff, there's really no need for developers to be dbo. We'd rather have our DBA staff control backups and security. Developers...

I think I'd drop all the role members then re-add the two logins to the role. Here's a way to script the sp_droprolemember statements:

set nocount on

create table #rolemembers

(Group_name...

This info isn't stored anywhere in SQL 2000.

Raju,

Can you post the restore statements that you're running so we can see exactly what you're doing?

Thanks

If it's a Windows login, you can use sp_denylogin and sp_grantlogin or you can do it in Enterprise Manager by checking "Deny access" or "Grant access" in the login properties....

SELECT * FROM sys.foreign_keys

WHERE is_disabled = 1

Unless developers are members of sysadmin, they wouldn't be able to modify or delete jobs owned by other logins.

musicman_7 (3/14/2009)

---

Thanks Greg, but I tried that option and couldn't get it to work ... probably just wasn't using the right syntax, but I was able to find a way...

When you open a job in SSMS and go to the "Steps" tab, you can specify the start step but I don't think there's a way to connect that to...

I have only migrated DTS packages to SQL 2005 by saving them as files then importing them in SSMS, so I don't know if your method will cause any problems....

The only way I can think of depends on there being an encrypted DTSRUN command somewhere in a scheduled job or a batch file. If you can find that,...

There are tons of scripts to choose from here. Use the Search box above to look for "script user permissions". I like this one: http://www.sqlservercentral.com/scripts/31776/ which scripts permissions...

You could try using the 2008 Upgrade Advisor which will run against a SQL 2005 intance. It's available for download here: http://www.microsoft.com/downloads/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en. I haven't tried it yet, but...

The code you show here isn't using the parameter at all. Am I correct in thinking that you want to use the input parameter to see if Table3.col1 =...

What I mean is the Wizard will run on the machine where the program that starts it resides. So, if you run it on your workstation, the Wizard runs...