nope...

not directly like that.

there's two ways to do it;

one is by using dynamic SQL, and the other is by using synonyms.

Declare @Location varchar(30)

set @location = 'database1.dbo.table1'

EXECUTE('Select * from ' +...

deepkt (7/9/2013)

---

1) Say A1, A2, A3, A4, A5, A6 are given Order as 1,2,3,4,5,6

2) Now, Change the existing Order of A3-3, A4-4, A5-5, A6-6 to a New order A3-1, A4-2,...

no not at all.

I'm suggesting to continue to use integrated security.

it seems to me, that you planned on setting it up that way, but the piece that is missing is...

to guarantee a specific order, you must have an explicit ORDER BY as part of your command.

SELECT

* FROM MiscItems ORDER BY DisplayOrder

i think the only thing missing is for you to find a domain group that everyone belongs to, like domainname\Domain Users, and add that as a login, and then as...

here's two ways to get to the default trace:

one via a query:

--SELECT * from sys.traces

declare @TraceIDToReview int

declare @path varchar(255)

SET @TraceIDToReview = 1 --this is the trace you want to review!

SELECT...

how about creating a procedure that runs under elevated privilesges, and give the helpdesk permissions to that?

here's just one example:

CREATE procedure pr_CallBoostedSecurityProcess( @name varchar(128), @password varchar(128) )

WITH EXECUTE...

Ed Wagner (7/9/2013)

---

A good programming practice is to always drop your temporary stuff in the procedure when you're done. I know they're supposed to be destroyed when the session...

Sean Lange (7/9/2013)

---

ummm....tables do not reside inside of a user or a role. They exist in the database, access to those tables is handled by the permissions granted to users...

amit_pjoshi (7/9/2013)

---

Hello Expert,

Can someone help its very urgent?

While developing the SSRS report we have to create a stored procedure using MDX query for this we have to hold the MDX...

it is not necessary to upgrade, no; the database backup is the same, regardless of service pack, version, and that's what you would backup/restore. the service packs / CU change...

tstagliano (7/9/2013)

---

what we are utilmately trying to do is run this procedure on a daily or weekly basis to pull in the actual price of our material to load into...

it does not matter if you are admin or not.

this is a common security misconception/"gotcha"....

tstagliano (7/8/2013)

---

One last piece of advice i need. i am able to run this for the first time, but i need to delete the dbo.tblPlexActualPrice table everytime the SPROC...