JP10 (7/9/2013)

---

yes I believe it's on a SAN (IT guy is on vacation). This happens when we restart the service only and not the server.

So what was...

also, the bad news: keep in mind the hostname/workstation id as well as the Application Name can be configured to say anything in a connection string,

so you cannot always rely...

is this on a sAN, where the SAN ends up coming on line AFTER the SQl service is already started?

i've seen a similar situation on my developer machine.

if you...

Rod at work (7/9/2013)

---

OK, I've added our Domain Users group to the logins for SQL 2008 R2 Express on my PC. It's server role is public. Domain User's default database...

i think it has to do with FOR XML returns a stream of xml, and not an object we typically expect.

this is what i used for the proof of concempt...

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...