I know this is a 2005 forum, but you should look into policy-based management for SQL 2008- this would allow you to set up criteria and only allow objects with...

In the properties of the script task, add the variable into the read/write variables list.

Putting User::variableName or just the variable name should work (provided you didnt change the namespace).

that will...

In addition to the other posts, I would also make sure any logins you bring over from sql 2000, ensure that the password is either a strong password, or...

After looking over the package configurations, this would probably be better for another situation, and was very useful.

However, I ran into issues with generalizing the location of the XML file...

Thanks for the suggestion! I'll take a look at package configurations. I haven't done too much with them. But I'm assuming i could loop through a list...

this only seemed to generate "GRANT CONNECT" statements when I ran it.

Steve

Ok cool. I mentioned that they'd still be able to stop SQL if they wanted, but figured it couldn't hurt to mention the builtin\administrators removal.

Take care,

Steve

Madhu,

I think the points of some of the others posters aren't being heard.

By setting instance 1 on node 1 to use 12GB of RAM, you cannot expect a successful failover...

The sysadmin will still be able to stop SQL SErver and delete files, but you should make sure that you remove the builtin\administrators group from being an administrator in SQL...

RBarry,

Thought it might have just been my screen resolution. I fixed the tabs in there.

I did note that the script was "similar" except for database level instead of login...

rick (1/30/2009)

---

If you subscribe to SQL Server mag, you can find an excellent tool built by Rodney Lundrum. His really wonderful SSIS package has allowed us to begin automatically collecting...

/*

This script will script the role members for all roles on the database.

This is useful for scripting permissions in a development environment before refreshing

development with a copy of production. ...

Madhu,

Check out this URL:

http://social.msdn.microsoft.com/forums/en-US/sqldisasterrecovery/thread/17c2744c-2e18-45c8-8b88-0e0b5db6461c/

It has a few recommendations for getting access to the single user connection that is allowed.

Two of the suggestions are:

1. Make sure SQL Agent is...

I agree with the partitioning post. Lay out multiple disks, and separate the load of your largest tables across multiple filegroups containing multiple files.

For example:

Orders table has data from...

As a previous poster briefly mentioned, check the Windows Environment Variables. By default it's set to the docs and settings folder. If anyone logs on to run a...