Viewing 15 posts - 16,006 through 16,020 (of 19,564 total)
To find out the schema_owner for each table, you could do the following:
Select o.name, schema_name(o.schema_id)
From sys.objects o
To find out further permissions, I have a blog post on the topic at:
March 24, 2010 at 10:36 am
Tom Brown (3/24/2010)
Paul White NZ (3/24/2010)
Tom Brown (3/24/2010)
Finally put IE out of its misery after it had swallowed 1.5Gb and showed no sign of return after 5 mins.
Is...
March 24, 2010 at 10:19 am
Alvin Ramard (3/24/2010)
CirquedeSQLeil (3/24/2010)
Steve Jones - Editor (3/24/2010)
tosscrosby-60625 (3/24/2010)
Much more often then you may think! Steve is all-knowing/all-seeing, sometimes with a little help from his friends, but he does have...
March 24, 2010 at 10:17 am
Steve Jones - Editor (3/24/2010)
tosscrosby-60625 (3/24/2010)
Much more often then you may think! Steve is all-knowing/all-seeing, sometimes with a little help from his friends, but he does have his finger on...
March 24, 2010 at 9:23 am
SQLDraggon (3/23/2010)
I told them there is no reason to do that for every column and every table ... but they insist.
Put the burden on them. Ask them to provide...
March 24, 2010 at 9:15 am
RBarryYoung (3/23/2010)
Lynn Pettis (3/22/2010)
CirquedeSQLeil (3/22/2010)
Alvin Ramard (3/22/2010)
Lynn Pettis (3/22/2010)
GSquared (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
My main subjects of conversation so far...
March 23, 2010 at 11:13 pm
GilaMonster (3/23/2010)
Been fiddling with this on and off for a couple years now. Initial idea was just the light from...
March 23, 2010 at 11:08 pm
Woot Woot.
Nice question Ron. Nice implementation of the pic in lieu of script as well.
I like the feature.
March 23, 2010 at 10:17 pm
tapankumar.bhatt-1037817 (3/23/2010)
Please find query. I made some customization in the Query developed by central user.
Create TABLE #db_file_information(
fileid integer
, theFileGroup integer
, Total_Extents integer
, Used_Extents integer
, db varchar(30)
, file_Path_name varchar(300))
--...
March 23, 2010 at 10:06 pm
Jeff Moden (3/23/2010)
Guess that settles it... Barry is back and feelin' fine! 😛
err.... Barry's back is feelin' fine 😉
March 23, 2010 at 9:36 pm
RBarryYoung (3/23/2010)
Roy Ernest (3/15/2010)
people born on 29th of February never gets old... 🙂 They are always young..Heh. Actually, so am I. 😀
Welcome back. How was the surgery?
March 23, 2010 at 8:27 pm
Alvin Ramard (3/23/2010)
CirquedeSQLeil (3/23/2010)
Alvin Ramard (3/23/2010)
March 23, 2010 at 7:25 pm
cjohn5552 (3/23/2010)
Thanks for your reply. Re-attaching and detaching the database didn't work, but logging in as another user did. So I guess it was a permissioning issue....
March 23, 2010 at 7:22 pm
Viewing 15 posts - 16,006 through 16,020 (of 19,564 total)