Questions tagged as 'sql-server'

Tagged questions
2
answers

hierarchyid, remove children from one node and assign to another node

I have a user table, with the use of hierarchyid, I need to remove all subordinate Users from User 1 and assign them to User 2. SELECT US.cd_usuario ,(SELECT cd_usuario FROM USUARIO USR WHERE USR.NODE = US.NODE.GetAncestor(1))...
asked by 02.10.2015 / 22:22
0
answers

See which user created or changed a Linked server

Sirs, How to audit the creation or change of Linked Servers in SQL Server 2008 or higher? (See who created or changed a linked server).     
asked by 07.08.2015 / 18:35
0
answers

System Integration C # Desktop with WEB System in ASP.NET [closed]

I have a Desktop System in C # and the data is written to SQLServer. How can I record this data simultaneously in a Web System developed in ASP .NET?     
asked by 15.08.2015 / 02:57
0
answers

SQL Server: error 7303 (architecture mismatch)

I've researched a lot, but I have not found a solution for my case yet. I need to create a linked server for a database in Access (mdb file). I use SQL Server 2012 Express x64 on Windows 8.1 x64. I ran odbcad x32 (which is inside the syswow64 fo...
asked by 14.08.2015 / 20:10
1
answer

Doubt with data recording time in master-detail tables?

After inserting a record, I use select max(IDControle) to retrieve the table id to record the items. When the time is only 1 second, I noticed that the items were all recorded in the 1st record. Does anyone have any idea how this could...
asked by 13.07.2015 / 16:08
0
answers

How to connect on a centos 6 sql server base 64 bits [closed]

I have already done the following: rpm -ivh http://dag.wieers.com/rpm/packages/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm wget http://rpms.famillecollet.com/enterprise/remi.repo yum install freetds yum install freetds-devel yu...
asked by 05.06.2015 / 18:54
0
answers

Problem with aggregate function, using CreateQuery from Hibernate

In a Packaging, a fk Packaging refers to the 'parent', the larger packaging. EX: let's say that inside a package B fit 10 packages A. A packing record A will have in your package the packing B in which it will be inserted. There is a query...
asked by 30.07.2015 / 21:42
0
answers

Oracle10g integration with Sql Server 2008 via JDBC

I need a help, I have a system that does integration between Oracle with Sql Server, this worked perfectly however the Sql Server was 2000, it was upgraded to Sql Server 2008, I used the 2000 jdbc driver, now I uploaded it through loadjava jdbc...
asked by 01.07.2015 / 23:27
0
answers

MySQL access through MSSQL client

First of all I would like to inform you that my knowledge in SQL is beginner ... I have a proprietary MSSQL client application and would like to know if there is any way to get it to the MySQL database through a linked server or another way. The...
asked by 01.06.2015 / 20:20
0
answers

Split access between the new site and the old one

I'm going to publish a new site and I wanted only a few accesses to go to it so that I can evaluate its operation and the other accesses will be forwarded to the current site. Facebook does something similar when it launches a new interface. The...
asked by 08.05.2015 / 16:07