Questions tagged as 'sql-server-2012'

Tagged questions
1
answer

Remote procedure call failed. [0x800706be]

After you install SQL Server 2008 R2, access the SQL Server Management Studio but the server name does not appear and the SQL Server Configuration Manager services are not active.     
asked by 26.05.2015 / 14:48
1
answer

How to put a SQL command in a variable

I have a following command in SQL and I need to put it inside a variable in SQL. That's the code. WITH DB_CPU_Stats AS (SELECT SUM(total_worker_time) AS [CPU_Time_Ms] FROM sys.dm_exec_query_stats CROSS APPLY (...
asked by 17.12.2014 / 17:49
2
answers

How to fill a datagrid in a form with fields in another form C #?

I'm doing a loyalty system, and wanted to use two forms for clients , form1 with datagridview and a button to sign up and the other form2 with the data fields to be filled , this form2 would be triggered by pressing the form1 button, w...
asked by 17.09.2014 / 22:18
0
answers

Error in SQL Server Data Migration to Oracle

I have a problem migrating the data that is in SQL Server to Oracle, using that "Migrate to Oracle" tool in SQL Developer, where it associates the data between the involved banks through a repository. > Then in the execution the data migration...
asked by 21.06.2018 / 19:33
1
answer

SQL Server Connection on laravel

Well, I have the following error: tcp provider: no connection can be made because the target machine has actively refused them. I'm using a bank created on my own machine, it's with the ODBC drivers, firewall disabled, however I use wamp to r...
asked by 11.01.2018 / 16:52
1
answer

Run SQL Server UPDATE error

Running the update statement below is experiencing the following error. What can it be?    Msg 116, Level 16, State 1, Line 3   Only one expression can be specified in the select list when the subquery is not entered with EXISTS UPDATE Est...
asked by 13.10.2017 / 19:20
0
answers

Generate sql script on a given date

Good afternoon! Well, I have a great mission that is as follows. I have a script that I set up below that I need it to be executed only on the 1st of each month, respecting the two conditions that I put in the IF clause. I tried via trigger a...
asked by 06.10.2017 / 20:05
1
answer

Connect SQL server with PHP

I am trying to connect a SQLServer 2012 using php 5.3 with the driver sqlsrv , however even getting connected to SQL management studio by php always return me the error    [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Failed...
asked by 24.07.2014 / 01:42
3
answers

Doubt SQL Query d

I am wanting to perform the calculation in the sql query where the result is the amount of open calls divided by the number of weekdays chosen period. Ex: 200 calls have been opened in the month and there are 17 working days in the month of May,...
asked by 30.06.2017 / 16:13
1
answer

SQL Server 2012 - Login for SQL Server Authentication

At the installation I put a password and wrote it down. When I login for SQL Server authentication the login field is blank, I just wrote down the password I do not know the login. I tried the same as Windows authentication, but it did not work....
asked by 05.06.2017 / 00:23