I don't know because I haven't tested, but I would guess that ALTER and DROP/CREATE would both cause the procedure to be recompiled at next execution. This is a...

Marios

Probably best to use the system stored procedure sp_helprotect.

John

Marios

I don't have time to do it now, but it should be fairly easy to get what you want by joining sys.database_permissions to sys.database_principals.

John

OK, you say this isn't working. Does that mean that it gives an error message, or it runs but doesn't do what you expect, or something else? Please...

Dave

Is the time zone important in your calculations? If not, you could just knock it off the end. This worked for me:

select cast ('03/18/2008 13:12:29' as datetime)

John

Dave

If you use CONVERT instead of CAST, then you can take advantage of the date style options. These are explained in Books Online.

John

This is as easy as I'm going to make it for you. If you're not willing to help yourself then you won't find many people here willing to help...

You can find this out easily for yourself by reading about database maintenance plans. If you don't want to use one of those, look up the syntax of BACKUP...

If we did that, you might think it was easy! Have a go at writing it yourself, and post back if there's any particular aspect you don't understand.

John

Yes, that looks right. If you run SELECT DATEADD(m,-12,getdate()) then you see it returns the date from a year ago. Just one thing to beware of: if your...

We're not going to do all the work for you. Have a go at writing the query yourself, and if there's anything in particular you don't understand, please post...

Have a look in Books Online for DATEADD.

Presentation is usually a job for the application layer. However, if you want to do it with T-SQL, you can do something like this:

DECLARE @List varchar(1000)

SET @List = ''

SELECT...

Yes, NOWAIT isn't valid syntax for SQL Server in this context. And the TOP 100 PERCENT is only useful if you're ordering the result set - which you shouldn't...

Yann

What Robert is saying is that you should examine the graphical execution plan. If anything in the plan appears in red, this is where you need to start tuning...