Ask Question

Community
SQL Server

SQL Server Questions & Answers

Get a modern-day SQL Developer Training that will help you learn the basics of database querying, Microsoft SQL and the best-practices of Database Management to gain confidence with our Online SQL Certification and surmount a trending career field

1.4KDiscussions

1.7KAnswers

0Waiting for an answer

Ask a SQL Server Question →

What to do if identity_insert is on?

How can I insert an ID into an identity column in SQL Server? I'll make a special item into my table and I will quickly detect that item by the ID.…

SQL Server

1 Answer · 1.5K Views · Answered ✓

Asked by: Ranjana Admin · 4 years ago

The target principal name is incorrect and cannot generate sspi context - How to resolve this issue?

We had a power outage last night and when the server came back up our domain users could not access our SQL Server 2000 instance name: MASSQL.We can…

SQL Server

3 Answers · 31.0K Views · Answered ✓

Asked by: Alan Taylor · 4 years ago

I received access denied; you need (at least one of) the super privilege(s) for this operation - What to do now?

I have created a user and given privileges to the user1. grant all privileges on db1.* to user1@'%' with grant option; Am using mysql workbench to…

SQL Server

3 Answers · 14.0K Views · Answered ✓

Asked by: Amit raj · 4 years ago

What to do if I cannot generate sspi context?

Cannot generate SSPI context\' is a generic error. It can be caused by many issues

SQL Server

1 Answer · 582 Views · Answered ✓

Asked by: Diana Campbell · 4 years ago

What to do if I cannot generate sspi context?

Cannot generate SSPI context\' is a generic error. It can be caused by many issues

SQL Server

1 Answer · 821 Views · Answered ✓

Asked by: Diana Campbell · 4 years ago

What to do if select list is not in group by clause and contains nonaggregated column

A quick fix of select list is not in group by clause and contains nonaggregated column

SQL Server

1 Answer · 3.5K Views · Answered ✓

Asked by: Dhananjay Singh · 4 years ago

How to show databases in oracle?

To show databases in oracle -

SQL Server

1 Answer · 1.2K Views · Answered ✓

Asked by: Deirdre Cameron · 4 years ago

How do mongo create user as admin for any database?

The \'...AnyDatabase\' roles should be added to the admin database for the mongo create user:

SQL Server

1 Answer · 1.1K Views · Answered ✓

Asked by: Deepak Mistry · 4 years ago

How to remove a database from a postgres drop database force?

To remove a database from a postgres drop database force -

SQL Server

1 Answer · 1.9K Views · Answered ✓

Asked by: debbie Jha · 4 years ago

How to restore a specific database from backup using the mongo restore command?

Use the following command to mongo restore:

SQL Server

1 Answer · 512 Views · Answered ✓

Asked by: David Piper · 4 years ago

How to convert timestamp to timestamptz postgres?

I have a decently-sized (~50k rows) time-series database running on Postgres, with some other structured data (in another database instance) which is…

SQL Server

2 Answers · 3.1K Views · Answered ✓

Asked by: alex GONZALEZ · 4 years ago