srikantzs (3/17/2010)

---

To just check the Permission set on that table,

I used a Table valued function,but it didn't return any rows.

SELECT *

FROM fn_my_permissions('tablename', 'OBJECT')

0 rows returned

which tells me the permissions...

Does any of the data it gets live on a different server than the procedure is running on?

If so, sounds like it's losing it's connection to a remote...

Not sure how that would change permissions. What reason did it give for failing?

Agreed. Way to...

srikantzs (3/17/2010)

---

Hello guys,

I had a job to alter data type of the primary key in...

Good one. I'd never really thought about it much, but totally makes sense.

Aglet

Might make sure there isn't a firewall blocking that TCP port.

I'm not a SAN expert, but even if the SAN can keep up with your I/O needs when you put the data/log files on the same disk, I would argue...

32-bit or 64-bit?

I agree, it's got to be something running. What would I profile for though?

We do have a nightly job that defrags/rebuilds indexes, but the tempdb growth doesn't happen anywhere close to when that job runs.

That's what's so frustrating about this...it seems...

Just out of curiosity, has anyone ever run up against the 250 index limit in SQL 2005. I can't imagine ever needing that many in our environment.

Perhaps...

What do you mean by it will filter things out? Won't it just return a set of SPs that user has permission to execute?

I wound up with this:

select *

from

sys.database_permissions p

inner join sys.objects o

on p.major_id = o.object_id

inner join sys.schemas s

on o.schema_id = s.schema_id

where

p.class = 1

and p.major_id > 0

and p.grantee_principal_id = 22

and o.type = 'P'