Someone, while locking down the SQL Server, removed the permissions by which the DBAs came in and administered the server. As a result, we cannot get back into SQL Server. How can we restore our access to SQL Server? Check out this tip to find out.
2012-03-29
4,423 reads
This script reverse engineers SQL statements to recreate database permissions.
2011-10-24 (first published: 2011-10-07)
16,012 reads
I am new to SQL Server 2005/2008 having administered SQL Server 2000 and below. I have heard there are a lot of new permissions at the database level. What are they and what do they give rights to perform?
2009-04-08
4,866 reads
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,962 reads
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
hi everyone I am getting an error when I add a variable to a...
Comments posted to this topic are about the item How to Use SQL Server...
Comments posted to this topic are about the item Choosing an AI in Sept...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers