Run this:

SELECT USER_NAME(dpe.grantee_principal_id) AS [UserName],

dpr.type_desc AS principal_type_desc,

dpe.class_desc,

OBJECT_NAME(dpe.major_id) AS object_name,

dpe.permission_name,

dpe.state_desc AS permission_state_desc

FROM sys.database_permissions dpe

INNER JOIN sys.database_principals dpr

ON dpe.grantee_principal_id = dpr.principal_id

WHERE

USER_NAME(dpe.grantee_principal_id) = 'domain\user' and see if there are any...

I don't get it. Are you saying that moving the indexes created larger files? What is the issue at hand?

Does the user have any permissions denied? That will trump what you have granted.

Lynn Pettis (7/3/2012)

---

Try the following to get the list of files:

dir *.* /a: -D /b /s /n

NOTE: No space between the a: and the -D. I had to put...

jaytaba (7/3/2012)

---

Hi Jared, thanks for your suggestion. The issue is that, there are no set patterns with the name of the data files. Some files have extensions and some...

The problem is that you are thinking of them as "partial duplicates," which itself is impossible (IMHO). Why not look for the '.' in the file name, since that...

We do the same procedure without initializing. We sync missing data manually with a merge, SQL Data Compare (redgate), or with a simple insert and join if the data...

+1...

What is the exact statement you are running?

The alternative is to stop adding data to the file.

Luis Cazares (6/28/2012)

---

Will something like this apply? (I'm learning how to use CROSS APPLY :blush: )

SELECT DISTINCT y.*

FROM Table x

CROSS APPLY (SELECT TOP 3 * FROM Table y WHERE...

what's the logic? From what you are telling me you are saying this:

If sysccc = 8 is not there, show syscc = 9

Else do not show record where syscc =...

The first thing I can think of is that you are joining the huge table over and over. Why?

lrutkowski (6/27/2012)

---

I am trying to create a job step, dynamically. I would like to put a line break\carriage return, after a comment line. So, for example, in my...

achen9291 (6/27/2012)

---

Select ClientUserName, DestHost, count(DestHost) counts from #ProxyLog_record

where ClientUserName =(Select top 1 ClientUserName from #ProxyLog_count_2) Group by ClientUserName, DestHost order by counts desc

I...