Top "Sql-server-administration" questions

How can I query the list of database roles in a SQL Server 2000 database?

In Sql Server 2000, is it possible to return, via SQL query, a complete list of database roles that exist in …

Read More
sql sql-server-2000 sql-server-administration
SQL Server 2016 _can't start mirror

After upgrading SQL Server 2014 to SQL Server 2016 (both Enterprise editions), I can't start mirror. This works normally on SQL Server 2014. …

Read More
sql-server-2016 sql-server-administration
SQL Server 2008 R2 Upgrade / Server Move to SQL Server 2014

I have a new server and want to install SQL Server 2014 Standard and migrate my database across from my old …

Read More
sql-server sql-server-2008 sql-server-2014 sql-server-administration
SQL Batched Delete

I have a table in SQL Server 2005 which has approx 4 billion rows in it. I need to delete approximately 2 billion …

Read More
sql sql-server tsql sql-server-administration
RESTRICTED_USER

Before changing database schema I issue: ALTER DATABASE SET RESTRICTED_USER On completion: ALTER DATABASE SET MULTI_USER I understand …

Read More
sql sql-server tsql sql-server-administration
The transaction log for database 'tempdb' is full

I have only read permission to the database I'm querying in. The same query was working for since yesterday but …

Read More
sql sql-server sql-server-2012 database-administration sql-server-administration
How to determine the size of a Full-Text Index on SQL Server 2008 R2?

I have a SQL 2008 R2 database with some tables on it having some of those tables a Full-Text Index defined. …

Read More
sql-server-2008-r2 size server-administration sql-server-administration