So, you must have figured out how to create a stored procedure. The procedure and the tables is accesses must have the same owner. In our shop, all...

You should be able to delete any of the log files except the current one, which is the one with no extension. The older log files would have the...

Open the package in DTS Designer and click on "Disconnected Edit" under the Package menu. Expand Steps, highlight the one you're interested in and you'll see the details ...

You can also create a server group in the "Registered Servers" pane. See "Registered Servers" under the View menu in SSMS.

Specifically, use sp_change_users_login to link the user with the login on the development server.

This should help: http://www.sqldts.com/238.aspx

Best practice is to use stored procedures and only grant users EXECUTE permission rather than table permissions, but you can grant permissions at the database level using GRANT or by...

Unless the permission box is checked, the permission isn't granted to the user or role. However, if a user has execute permission for a stored procedure that selects, inserts,...

You'd have to do that as part of your queries. You could insert the selected data into a table or use sp_send_dbmail to send an email message with the...

1. Expand SQL Server Agent in SQL Server Management Studio

2. Right-click on Jobs and select New Job...

3. On the General page, give the job a name

4. On the Steps...

If the config file path was wrong in the job step, wouldn't that indicate that the job was changed rather than the package?

Unfortunately, I don't think a modification history of...

Ang,

I think you almost answered your own question. A differential backup backs up changes since the last full backup while a transaction log backup backs up changes since the...

or sp_helprotect 'table_name'

It's used for multserver job administration where one server is the master and one or more servers are target servers. See "Multiserver Administration" in BOL.

No wonder the confusion. That looks like a different question.

Does this query work for you?:

-- CHANGE LOGINNAME TO THE LOGIN YOU'RE INTERESTED IN

set nocount on

declare @name sysname,

@sql nvarchar(600)

if...