This is a little bit confusing. Please will you provide table DLL in the form of CREATE TABLE statements, some sample data in the form of INSERT statements and,...

Yes, I think you can use an XML file, although I've never done it that way myself. I think you'll need to study this area quite carefully since it...

Are you sure about that? Can you not create a different configuration filter for each package, and store them in a SQL Server table? Then, when your file...

Das

The SSIS equivalent of dynamic properties in DTS is Package Configurations. You'll probably need to do a bit of reading about it, since I don't think it works in...

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