What server level permissions are you trying to give your users?

When going across databasses, the users have to be given access to the base tables in the other databases. The only way around this is to pull the data...

Banana-823045 (10/26/2011)

---

Just a quick addendum to hopefully demonstrate the crux of problem.

This will fail in an error:

EXECUTE AS USER = 'dbo';

EXECUTE AS LOGIN = 'proxylogin';

REVERT;

REVERT;

Even though the user 'dbo' is...

I'll have to play with this at home. I know where I am working now, they have a procedure dbo.TruncateTable used to truncate a table without giving the developers...

From BOL regarding the EXECUTE AS Clause:

By specifying the context in which the module is executed, you can control which user account the Database Engine uses to validate permissions on...

Banana-823045 (10/26/2011)

---

Sure.

I do not want to grant permissions on server directly to any users but there are some operations that I would like to allow users to perform without...

Can you explai what you are looking for in a little more detail? I'm not sure what you are asking about with regard to EXECUTE AS. Are we...

Okay, I'm sorry but that was just gross.

What are the error messages you are receiving?

Kiara (10/26/2011)

---

Stefan Krzywicki (10/25/2011)

---

SQLRNNR (10/25/2011)

---

ChrisM@Work (10/25/2011)

---

Brandie Tarvin (10/25/2011)

---

ChrisM@Work (10/25/2011)

---

A nice pair of ski...

Duplicate post, please post responses here.

Please do not double post, it will only split possible answers.

Just to let you know, if you read and follow the guidelines in the first article I reference below in my signature block, you will get better answers faster. ...

CELKO (10/24/2011)

---

>> I need to convert yesterday's date from getdate()-1 to something like 20111023. <<

You do not understand that DATE is a temporal data type; there is no converting it....

CELKO (10/24/2011)

---

The next trick is a report period calendar. It gives a name to a range of dats.

CREATE TABLE Report_Periods

(report_name VARCHAR(30) NOT NULL PRIMARY KEY,

report_start_date DATE DEFAULT CURRENT_TIMESTAMP...

Here is how I would do it:

If run on the last day of the month for the current month:

set @startdate = dateadd(mm, datediff(mm, 0, getdate()), 0);

set @enddate = dateadd(mm, datediff(mm,...