Viewing 15 posts - 1,306 through 1,320 (of 7,502 total)
As long as you stay on the same SQLInstance, it should be OK.
Just:
1) create another DB ( enable ownership chaining )
2) create the table you need
3) grant the account being...
September 3, 2012 at 8:12 am
way to late ( due to summer holidays ) but here are the results on my dev server ...
I loaded 1000000 rows is MytestTable;
use SSC_Test
/*
DECLARE MytestTable TABLE ( col1 INT,...
August 29, 2012 at 7:26 am
Great thinking pattern !
Marvelous results !
August 23, 2012 at 5:33 am
You'll need to be granted
VIEW SERVER STATE
and
VIEW DATABASE STATE
to be able to use the mentioned DMO in Glens script.
We grant these privileges to our devs (dev and qa instances)...
August 23, 2012 at 4:07 am
Have a look at the wonderful scripts Glen provided for us .
SQL Server 2005 Diagnostic Information Queries by Glenn Berry
August 23, 2012 at 12:37 am
Both queries look the same to me ...
Except for the cast clauses used with the second one !
Are you sure your @varriable-content isn't longer than 10 characters ?
where SetupDetailsId...
August 23, 2012 at 12:28 am
Apparently you didn't want to do a one by one approach, just generate your stuff !
Select 'ALTER LOGIN ['+ name + '] DISABLE ; '
from sys.server_principals
/* exclude disabled accounts, sysadmins...
August 22, 2012 at 12:10 am
Just disable the logins and the engine won't let anybody in !
It works as well for SQLUsers as for windows logins and groups.
ALTER LOGIN [AnySQLUser] DISABLE ;
ALTER LOGIN [yourdomain\your_windowsgroup_EXEPT_SQL_ADMINS] DISABLE...
August 21, 2012 at 11:54 pm
We always use Gert Drapers' solution mentioned at : http://www.sqlservercentral.com/Forums/FindPost368228.aspx
August 21, 2012 at 3:06 am
"auto close on property set to true"
If this is a production box, I recommend setting "auto close on" property to false.
This way sqlserver will bring the db online when the...
August 20, 2012 at 11:45 pm
You've seen the message:
The log for database 'Commun' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
it says ...check the eventlog...
I...
August 19, 2012 at 1:12 am
The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released
August 17, 2012 at 1:48 am
SQLQuest29 (7/30/2012)
Good article ..There is a slight potential security risk associated which is described here http://blogs.msdn.com/b/askjay/archive/2011/03/11/why-is-using-instant-file-initialization-on-my-sql-server-a-potential-security-issue.aspx
Some misconceptions are well explained here: http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-instant-file-initialization.aspx
Thank you for adding these great references to...
July 31, 2012 at 8:09 am
gbargsley (7/30/2012)
I...
July 31, 2012 at 8:07 am
Mea culpa, mea culpa, mea maxima culpa ➡
Dear, Jeff, forgive me because I have sinned.
I hope you don't kick me out of the anti RBAR brotherhood.
Actually...
July 23, 2012 at 12:48 am
Viewing 15 posts - 1,306 through 1,320 (of 7,502 total)