Questions tagged as 'sql-server-2008'

Tagged questions
1
answer

Creating a trigger SQL server 2008 ERROR: The object does not exist

The following trigger marks me the following error when executing it:    Msg 8197, Level 16, State 4, Procedure   InsertHystoryOfOrderHasProfiles, Line 1 The object   'dbo.OrderHasProfilesOfPayments' does not exist or is invalid for th...
asked by 13.08.2018 / 20:32
0
answers

Replication Sql Server 2008 R2

I try to enable the transactional replication with updatable subscriptions and it throws me an error, but I looked for information and it tells me to run the following procedure, but it does not work for me: exec sp_link_publication @publisher...
asked by 17.08.2018 / 15:11
0
answers

Subtracting a next value based on a condition in the same SQL column

I need to create a query that every time I find a value "Sent" in the Status column, then subtract it in the Events column taking into account a next value that is after Sent. Table that I am using: Catalogo Status Eventos ------...
asked by 09.07.2018 / 19:30
0
answers

Import an XML to two tables in SQL Server

I have a XML that exports two tables, now that XML I want to import it to another table with the same fields, they are too much data that is why I exported it, I hope you can help me thanks. This is my query SELECT * FRO...
asked by 27.04.2018 / 19:52
1
answer

Problems connecting from apache (ubuntu) to sql server using PHP

I will try to explain: I want to connect from a server that I have xubuntu to sql server 2008 using a php query. I already have the necessary drivers and extensions installed on the server. The sample query that microsoft gives me if I can conne...
asked by 26.04.2018 / 15:04
1
answer

Upgrade sql server 2008 to 2016

Where are you thinking about doing the upgrade of sql server 2008 (SP4) Enterprise Edition 64 bit A Sql server 2016 ???. We have a DWH and I would like to know what I need to know for migration, compactibility of versions between the two. I a...
asked by 26.03.2018 / 17:36
1
answer

Problem connecting Yii2 with SQL Server

I'm trying to connect my Yii2 application with a database in SQL Server, the version I'm using is 10.0, this is my error message:    exception 'PDOException' with message 'SQLSTATE [08001]: [Microsoft] [ODBC Driver 11 for SQL Server] Named Pi...
asked by 01.03.2018 / 03:10
1
answer

Retrieve IDENTITY

Dear I have a problem that I was looking for I did not find a solution, I have the following tables in sql server 2008 and I have an application in Visual studio 2017, from WinForms WEB, with my connection to my database through CODE FIRST...
asked by 15.09.2017 / 22:01
0
answers

change column name of a temporary table SQL SERVER 2008

I have problems when renaming columns in a temporary table are several I have executed this example script and I get the following error    / Faulty Rename / EXEC sp_rename   'dbo.AllocationDetails. [Conversion_Fee_Per_Share]',   '[Conversi...
asked by 06.09.2017 / 18:46
1
answer

Unable to connect to server SQL SERVER 2000 SQL Authentication

I need to perform a Hardening validation for a SQL Server 2000 database migration to SQL server 2008, trying to connect through some client (Microsoft SQL Server Management Studio) to SQL Server 2000 or from LocalHost with (SQL Query Analyzer )...
asked by 21.07.2017 / 16:48