if you wanted something like elapsed time, you really have to do it between two dates, and not from an integer...the elapsed number of months depends on whether the month...

the DATEADD function can do this...adding those 366 days to a desired starting date...by default SQL is 1900-01-01, soe something liek this will return the following:

--returns 1901-01-02 00:00:00.000

SELECT DATEADD(dd,366,0)--same as...

Adding the moon thing came about with the question "when is the next...

here's a copy of mine named TallyCalendar, which generates dates from the SQL beginning of time (1900-0101) to 100 years in the future compared to today.

the advantage is i've added...

at least for US data, Here's a copy of one of mine; 42K zip codes, mapped to Cty/County/State;

CITYDATA_INSERTS.txt

populating city/county/state if you know the zip is no problem, but

if you...

durai nagarajan (12/16/2011)

---

Hello,

are you firing a Stored Procedure or query?

Kindly try the SP or query with the parameter directly on database and check. if the problem is there in DB...

yep, here's a proof of concepty suite of scripts to test with; worked fine for me:

create login ClarkKent with password = 'NotARealpassword'

EXEC master..sp_addsrvrolemember @loginame = N'ClarkKent', @rolename = N'dbcreator'

EXECUTE AS...

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...