User CR241

21 votes

SQL server DB status runnable, sleeping, suspended, running and background meanings

answered Jul 3, 2018 at 23:44

5 votes

Permission to create linked server

answered Jul 18, 2017 at 15:29

4 votes

Change all databases in "RESTORING" state to ONLINE

answered Jun 15, 2017 at 22:21

4 votes

Accepted

Login Error while connecting SQL Database through Power BI?

answered Jun 23, 2017 at 18:22

4 votes

What causes "lock request time out period exceeded" when droping a column?

answered Jul 14, 2017 at 16:40

3 votes

Error 0x80131904 failed to load assembly id 65536 / HRESULT: 0x8013150A for microsoft.sqlserver.integrationservices.server

answered Sep 7, 2018 at 18:19

2 votes

Query is still running

answered Jun 5, 2017 at 15:55

2 votes

How To: Optimize SQL Query (SQL Server)

answered Jun 8, 2017 at 14:21

2 votes

MS SQL :Export data from query output to excel which has a column with huge data

answered Jul 19, 2017 at 14:39

2 votes

Lost connection to server executing ALTER TABLE

answered Oct 18, 2018 at 22:10

2 votes

SSMS 2017 Export SCOPED CONFIGURATION

answered Dec 6, 2018 at 22:07

2 votes

What are the sp_send_dbmail return values?

answered Jan 15, 2019 at 21:45

2 votes

Accepted

How to grant permissions to database but restrict to certain schemas?

answered Apr 23, 2019 at 21:49

2 votes

How to restore a .backup file from a single table on postgres?

answered Oct 15, 2019 at 23:40

1 vote

How to get (format) a Firebird v3 DATEDIFF() to the number of years, months and days all together?

answered Dec 13, 2019 at 0:32

1 vote

Migration from SQL SERVER 2008 R2 to 2019 with Log Shipping

answered Mar 22, 2021 at 23:08

1 vote

sql script hangs in SQLplus on Solaris

answered Mar 14, 2019 at 0:11

1 vote

Accepted

Can't change authentication mode from Windows to both SQL Server and Windows

answered Oct 19, 2018 at 18:06

1 vote

Sybase to SQL Server Migration

answered Oct 25, 2018 at 18:52

1 vote

How to dump a large database?

answered Feb 3, 2020 at 23:37

1 vote

Accepted

How do I allow non sysadmin accounts the ability to create/query linked servers in SQL Sever 2014?

answered Oct 10, 2018 at 18:11

1 vote

Grant read access to my SQL Server database to all future SQL users

answered Dec 8, 2017 at 6:53

1 vote

Couldn't find sql server agent in Sql Server 2014 Management Studio?

answered Apr 19, 2018 at 6:01

1 vote

Microsoft SQL Server Error: 18456(Administrator is also not able to access)

answered Jun 20, 2018 at 0:40

1 vote

SQL Server Management Studio 17.1 Mirroring bug

answered Jun 9, 2017 at 20:01

1 vote

SQL Server mirrored backup using cluster shared volumes

answered Jun 20, 2017 at 20:32

1 vote

Accepted

The definition of object '[sp_name]' has changed since it was compiled on fail-over to mirror database

answered Jun 20, 2017 at 21:15

1 vote

Granting a SQL Server database only user execute on xp_instance_regread fails

answered Sep 7, 2018 at 17:52

1 vote

Unable to fully drop a database snapshot

answered Jul 25, 2018 at 0:01

1 vote

mysql update based on select result, How combine?

answered Aug 17, 2018 at 21:09

Stack Exchange Network

64 Answers

SQL server DB status runnable, sleeping, suspended, running and background meanings

Permission to create linked server

Change all databases in "RESTORING" state to ONLINE

Login Error while connecting SQL Database through Power BI?

What causes "lock request time out period exceeded" when droping a column?

Error 0x80131904 failed to load assembly id 65536 / HRESULT: 0x8013150A for microsoft.sqlserver.integrationservices.server

Query is still running

How To: Optimize SQL Query (SQL Server)

MS SQL :Export data from query output to excel which has a column with huge data

Lost connection to server executing ALTER TABLE

SSMS 2017 Export SCOPED CONFIGURATION

What are the sp_send_dbmail return values?

How to grant permissions to database but restrict to certain schemas?

How to restore a .backup file from a single table on postgres?

How to get (format) a Firebird v3 DATEDIFF() to the number of years, months and days all together?

Migration from SQL SERVER 2008 R2 to 2019 with Log Shipping

sql script hangs in SQLplus on Solaris

Can't change authentication mode from Windows to both SQL Server and Windows

Sybase to SQL Server Migration

How to dump a large database?

How do I allow non sysadmin accounts the ability to create/query linked servers in SQL Sever 2014?

Grant read access to my SQL Server database to all future SQL users

Couldn't find sql server agent in Sql Server 2014 Management Studio?

Microsoft SQL Server Error: 18456(Administrator is also not able to access)

SQL Server Management Studio 17.1 Mirroring bug

SQL Server mirrored backup using cluster shared volumes

The definition of object '[sp_name]' has changed since it was compiled on fail-over to mirror database

Granting a SQL Server database only user execute on xp_instance_regread fails

Unable to fully drop a database snapshot

mysql update based on select result, How combine?