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'

Are you authenticating with the same user both ways?

I'm sure most companies that provide online backups for businesses would do that...but I'm just talking my personal data (mostly digital pictures and things with sentimental value). I don't...