Viewing 15 posts - 16,501 through 16,515 (of 19,564 total)
GTR (3/12/2010)
I would set up AD group and grant permission to the group and add users to that group.
And then put that group in a role in SQL Server 😀
March 13, 2010 at 11:43 am
lmu92 (3/13/2010)
@paul-2: CONGRATULATION to be one of the top 25!
Congrats indeed. He's been making a mad push lately.
March 13, 2010 at 11:35 am
FabricioLimaDBA (3/12/2010)
That's OK. I work with Sql Server 2000 and 2005 yet. I will make the upgrade.Thank you.
Something that I do is make it conditional. I run in a...
March 13, 2010 at 11:26 am
Jeff Moden (3/12/2010)
Steve Jones - Editor (3/12/2010)
I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.
Heh......
March 13, 2010 at 11:24 am
Paul White (3/13/2010)
GoGreen (3/12/2010)
I am trying to import data from file(txt, xls) using multiple Insert statement.Is there any limitation on query size that SQL server can handle at one time?
That...
March 13, 2010 at 10:59 am
Paul White (3/12/2010)
tosscrosby-60625 (3/12/2010)
BananaramaEpilator
NAIR
March 13, 2010 at 10:55 am
Since many DBA's create an "admin" database to house such things as numbers tables, stored procs, and other administrative types of objects - it is perfectly plausible to house a...
March 13, 2010 at 10:55 am
SQL_Quest-825434 (3/12/2010)
I think Jason has a good post of how to do this:
http://www.sqlservercentral.com/articles/Log+growth/69476/
HTH,
\\K
Thanks, I think it is a good solution too 😉
March 13, 2010 at 10:44 am
Paul White (3/12/2010)
Jeff Moden (3/12/2010)
We're rootin' for ya!* snigger *
D'oh
March 13, 2010 at 10:26 am
Alvin Ramard (3/13/2010)
Grant Fritchey (3/13/2010)
Alvin Ramard (3/12/2010)
Great job on Twitter Grant. Mention DBCC TimeWarp to Paul and then run. 😀
I haven't logged back into Twitter yet. You're saying...
March 13, 2010 at 10:24 am
I would have to weigh in on the side of permissions. If create or replace only handles them in the event of a replace, then what does it really...
March 12, 2010 at 5:20 pm
FabricioLimaDBA (3/10/2010)
select distinct B.name ,
case type when 'P' then 'Stored procedure'
when 'FN' then 'Function'
when 'TF' then 'Function'
when 'TR' then 'Trigger'
when 'V' then 'View'
end
from...
March 12, 2010 at 5:18 pm
That error relates to an out of space situation in your log file or data file. Make sure your files are properly sized.
March 12, 2010 at 5:09 pm
Take this a step further. Set up roles in your databases. Grant the permissions to the roles. Then add a user to the necessary roles.
March 12, 2010 at 4:44 pm
Viewing 15 posts - 16,501 through 16,515 (of 19,564 total)