Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!.

Questions tagged [sql]

Ask Question

Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [mysql], [postgres], [mssql], or [oracle].

1,295 questions
Newest Active Bountied Unanswered
Score of 0
1 answer
175 views

I installed SQL Server Management Studio (SSMS) v21. It has similar Tools/Options settings as SSMS 2012, but they not working. Specifically, the background colour of the main window is different. It ...
Score of 0
1 answer
314 views

Context I have a powershell script that performs some setup for an application in a test environment. Among other things, the script calls sqlcmd several times. A few days ago, I performed a restore ...
Score of 1
0 answers
453 views

I recovered my database when I try to run a sale report on the software I get this error message" cannot find either column dbo or the user-defined function or aggregate"dbo.F_GET_CAMBIO, or ...
Score of 0
1 answer
222 views

We have SQL Server 2016 and SSRS to go with it. I have a number of reports that work perfectly for about 70 users but 1 cannot use any of the report parameters. She sees them but cannot choose ...
Score of 1
1 answer
3948 views

In my production environment, rare undisposed transactions occur that hold lock on one tables. I want to fix it in my application code. I can get the TransactionId and SessionId ad hoc, but how do I ...
Score of 2
2 answers
298 views

When I manually run query directly in SSMS, it successfully runs (in 10-20sec). When the query is initiated through the .NET/IIS web application, it hangs pretty much indefinitely, and ends up locking ...
Score of 2
1 answer
1108 views

At work we've been running into a sort of mysterious problem. Every few hours, one of our tables (tasks) sees query latency grow (caused by CPU use) followed by a burst of LWLock:BufferContent, then ...
Score of 4
2 answers
826 views

I have a Server Server 2008 R2 instance. I need to upgrade to SQL Server 2016 temporarily until an infrastructure upgrade to newer hardware and newer software. I try to upgrade to SQL Server 2016 ...
Score of 0
1 answer
49 views

By default when we create a trigger is located under the associated table in a foler called Triggers , I need to change this location? Is it Possible ?
Score of 1
0 answers
657 views

I want to make a better query for Windows Server OS patching (2016 & 2019). The one listed below is what I wrote that my company currently uses. If a newly built servers OS install time is ...
Score of 1
0 answers
49 views

I cannot join the primary site to an existing hierarchy while installing Microsoft Configuration Manager. SQL and the SCCM Server are connected. Am I doing something wrong?
Score of 0
1 answer
90 views

Trying to install the BILicense Service for Sage X3 SEI (Sage Enterprise Intelligence) on a Windows 2019 server. This is a prerequisite before installing SEI for Sage X3. Straight out of the gate it ...
Score of -1
2 answers
2009 views

I installed SQL 2012 on a new Server 2022 vm and restored a database on the new server from a SQL generated backup. The new SQLserver/instance is not showing up in the Odbc client on a windows client. ...
Score of 0
1 answer
148 views

I have my SCCM Server connected to the SQL Server via ESXI through two different VM's. I have Microsoft Configuration Manager on my SCCM trying to get it connected to the SQL Server. How do I connect ...
Score of -1
1 answer
79 views

WMI Provider Error: Access is denied. [0x80070005] I cannot connect the SQL Server to the SCCM Server with two seperate VM's. I have two VM's on my ESXI Host. I am trying to point one VM to another. ...

15 30 50 per page
1
2 3 4 5
…
87