BOL says the user needs ALTER permission on the database to rename it:

http://msdn.microsoft.com/en-us/library/ms174269.aspx

sqlguy-736318 (12/15/2011)

---

A Login with the serveradmin server role is allowed to drop a database. Can a Login with a non-serveradmin role be enabled to drop a database?

I have a...

i'm pretty sure it's simply using the .NET classes System.Net.Mail.SmtpClient and System.Net.NetworkCredential to send any emails;

in .NET, it's pretty simple to use that to send an email.

this is how...

does your database have any triggers?

if the trigger is not well written, it might rollback the action(in this case, a delete, right?) and the data would remain in place...that's the...

here's away that takes foreign keys into consideration; with MsForEachTable, you get errors in deleting due to foreign key violations.

it also has the ability to add tables you want to...

newbieuser (12/15/2011)

---

We are facing some issues on the application with the lower case fields in the database.. So we need to change them all to upper case..

I would...

i've seen and create scripts to transfer logins from one server to another ...search for sp_help_revlogin...i believe there are different versions depending on whether you are 2005 vs 2008,...

ok i declare mea culpa, now that i see that my post somehow got it's carats stripped out; that's how i found it in my snippets as well. i fixed...

i tried switching to LOWER as Brandie identified, and i get a function that never finishes executing...in the meantime, i'll post an older version from my supply of 8 differnet...

you'll have to script the jobs, i think; as i remember it,you'll hit a coule of issues:

system databases cannot be restored between versions or service packs. (ie 2005-->2005SP2, or 2005-->2008,2008-->2008R2,...

TallyTable?

something like this:

SELECT SomeStuff

FROM BusinessTable

WHERE FiscalYear IN(SELECT YearNumber --An integer like 2010

...

wouldn't forcing the optimizer to use merge joins, instead of allowing it to pick what it thinks is best also potentially affect the performance?

I'll let others expound on why nolock...

I've had a number of what i thought of as "developer only tools" that i generated to make my life easier suddenly get promoted into tools the QA or helpdesk...

well, searching the scripts and articles section here on SSC will get you lots and lots of examples for scripting out users and roles, and object permissions too;

permissions on the...

here's another example using 7zip's command line utility:

my example here shows my exe in a specific path for clarity.

http://downloads.sourceforge.net/sevenzip/7za920.zip