Questions tagged as 'sql-server'

Tagged questions
1
answer

How to execute a script before a view in sql server?

I created a view and it fetches information from an X table. However, this X table must be created in a select, before running the view, so that the data is updated. How can I create something in the sql server so that as soon as the user cli...
asked by 09.04.2015 / 16:02
0
answers

The operation could not be performed because OLE DB provider "MSDASQL" for linked server "XYZ" was unable to begin a distributed transaction

I am trying to perform a update on a database on another server through a LINKED SERVER configured on my local server. I've tested it and it works perfectly when I use queries in the DBMS. In my web application, I use hibernate 3.5 and wh...
asked by 10.04.2015 / 19:28
2
answers

SQL connection to bd in the network

I developed a C # application that uses SQL Express that initially the bd and the application were installed on a single machine. The client now needs the bd to be available from another computer on the network. I installed SQL Express on the "o...
asked by 14.04.2015 / 13:09
0
answers

Does mirroring influence server auditing?

Does Mirror Break Influence Server Audit? I ask this because in the databases where I need to redo the mirroring for some reason, I also have to specify the audit again (BASE > > > >> Database Audit Spec. > > > Audit Field)....
asked by 19.01.2015 / 17:32
0
answers

Execute a block of execution (SQL Server) in Doctrine + ZF2

I need to execute a SQL execution block (SQL SERVER) on a Repository in Doctrine. My environment is with ZF2 + Doctrine 2. I've read a few things about ResultSetMapping in Doctrine, but I could not. Code: public function teste() {...
asked by 11.03.2015 / 16:29
1
answer

Application with Crystal Reports does not find Database on the client

I made a small application that uses Crystal Reports to generate reports. I made the .EXE of it with InstalShield LE, installed it in my PC and it turned beauty. However, when I install on another machine, the application does not find the Da...
asked by 05.01.2015 / 17:52
0
answers

Transactions in SQL Server, how do they work? [closed]

I'm having trouble understanding this content in college and finding good materials to understand, could someone explain to me better how transactions are specified and the delimiters defined in the DBMS, in particular SQL Server? How does it al...
asked by 20.10.2014 / 17:18
0
answers

Publishing asp.net application on IIS 8

I'm trying to publish my application on a windows server 2012 with IIS 8. I made the step by step go on "Site -> Add Website" fill in with the coordinates, paths, and so on. I deployed the default folder "Inetpub -> wwwroot", but I get the follo...
asked by 21.10.2014 / 20:15
4
answers

Is it possible to reference a column other than a primary key in another table?

For example, I want to reference the id_2 of Table 1 in Table 2, I know I can do with primary keys but with other columns I do not know if it is possible. Table 1: id (primary key of table 1), id_2, name Table 2: table_id2 (primary key of...
asked by 07.05.2014 / 16:20
0
answers

Error in Execute SQLTask Result

I am developing a project where in one of my execute sql task has a query, select stuff((select ',' + campo from tabela FOR XML PATH(''))1,1,'') as resultado this query returns so | resultado | |1,5,3,6,7,9,6,4| and I'm putting thi...
asked by 21.11.2014 / 15:36