The script used to create a role would be:

exec sp_addrole N'rolename'

Then to add permission you would need to specify the permission as well the object such as:

GRANT  SELECT  ON [dbo].[tablename]...

Without knowing the exact DDL of the user table and what data resides in the Excel sheet it's dificult to give a detailed answer.  However, the general process could be...

This should work:

RESTORE DATABASE [corp-reports] FROM  DISK = N'C:\corp-reports'

I have always gone the route of a Linked Server since it is easilly documentable and it allows for integrated security to be defined at the link level.

I would set up a trace on that database that dumps the results to a table.  You can then analyze connections whenever you like.

I had this same problem and unfortunatly we did not find a way to do this other than wrapping all of the procedure calls into one stored procedure.  When we...

Would This Work:

DECLARE @grp VARCHAR(50)

SELECT MEM

FROM  GRPMEM

WHERE  (GRP LIKE @grp OR GRP IN (

SELECT GRP

FROM GRPMEM

WHERE GRP IN (SELECT MEM FROM GRPMEM WHERE GRP LIKE @grp)

)) AND MEM NOT IN (SELECT...

After starting at a new job I inherited a number of these types of situations.  The problem here was the recovery option on the databases was set to Full but...

Probably the easiest ways for you to do this is to use the Maintence Plan Wizard.  Using this you will be able to set up a job that will backup...

Is the authentication set to NT only, or mixed mode?

An uimportant thing to consider here is that when a job is executed it is done so under the credentials of the user which is running the SQL Server Agent. ...

Would somthing like this work:

SELECT a.ID,

 a.NAME,

 b.TABLE,

 b.MEMO

FROM  SALE a LEFT OUTER JOIN MEMO b

ON  a.SID = b.RECORDID AND MTABLE LIKE 'SALE'

Asssuming there is the same unique key in both tables youcould simply do this using a query like:

INSERT INTO table1

SELECT * FROM table2 WHERE ID NOT IN (SELECT ID FROM...

We actually use the UDL method but we place the UDL files in a secured location that can only be opened by the DBA group.

When I had to do this in the past what I did was create a table with fields I knew would be large enough.  Then ran the LEN function against...