Questions tagged as 'sql-server-2000'

1
answer

Delete the last two characters of a sql server string

I use SQL Server 2000 and I have a table with a field rut of type VARCHAR (eg: '17045782-8' I need: '17045782') to which I have to remove the check digit and the hyphen. And I do not find it with substring(rut,0,x) since the...
asked by 24.03.2017 / 14:55
2
answers

Client - Sql Server 2000 Server

my question is presented, in Sql Server 2000 and Vb6, what I want to do is access with my application to the PC-server from the PC-client to access the data of the database. How do I make that connection? Where do I start ?, Thank you very much...
asked by 18.11.2016 / 19:32
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
1
answer

Backup of the physical part of a Server 2000 Sql Base

I need to do, a backup of my database in sql server 2000, but only of the physical part, because I modified some tables, and add some new SP, well thank you very much from now, very happy with this community. Greetings     
asked by 11.11.2016 / 20:13