You need to create a new project and add the package to the project. Then you can use the button with the green triangle to run the package (or...

Yes, I think it's possible to do this with a trigger. But I'm not doing all your work for you. Have a try, and post back if you...

What have you tried so far?

John

Also, you're confusing the output parameters of the procedure with the result set. You can only use INSERT INTO to insert the result set - not the output parameters.

Try...

Another DBA? Triggers? Database restored?

John

No. From Books Online:

Note the "all". You need to grant permissions...

You could put the different types of table in different schemas and then grant permissions on the schemas.

John

Easier than that in SQL Server 2008 and above:

SELECT CAST(CURRENT_TIMESTAMP AS time)

John

Edit: just noticed the milliseconds requirement. You can either convert the above to varchar and chop off the...

If there's nothing to choose between two different syntaxes, I usually go for the ANSI standard. That's why I prefer <> in this case.

John

OK, this is the last time I'm going to ask. I know it's extra effort for you to prepare and post full DDL, INSERT statements and procedure definitions, but...

Yes, the conditions in the WHERE clause do appear to be mutually exclusive. Don't change the ANDs to ORs just for the sake of getting it working, though -...

No, datetime values are not stored in any format - just as two integers, like Lowell said. You can use varchar to store dates in any format you like,...

Yes, I don't see why that shouldn't work.

John

Like I said, it's pseudo code, so you'll need to check the exact syntax of ALTER LOGIN and the structure of server_principals to see what the column names and the...

The only way I know for existing logins is to execute the ALTER LOGIN statements one by one. You can generate them very easily something like this (pseudo code...