remove columns created by replication process

One of our users tried to set replication solution in a sqlserver (the idea was given up).
SQL Server added in each table a column related to replication.
We want to remove theses columns and I used the following script :

select 'ALTER TABLE dbo.'+object_name(id)+' DROP CONSTRAINT '+object_name(constid)+' GO'
+'ALTER TABLE dbo.'+object_name(id)+' DROP COLUMN '+'msrepl_tran_version GO'
from sysconstraints where object_name(constid) like '%msrep%'

Question:
1. I want to know how to introduce a carraige return in order to have some thing like this :

...
ALTER TABLE dbo.T_CommandCopyFile
DROP CONSTRAINT DF__T_Command__msrep__44AB0736
GO
ALTER TABLE dbo.T_CommandCopyFile
DROP COLUMN msrepl_tran_version
...
2. Is there any other solution to do this more simply ?I'd use:DECLARE @.crlf CHAR(2)
SET @.crlf = Char(13) + Char(10)-PatP|||Could you give me more explanation (why : char(13)+char(10))
I tried only char(13) only and I noticed the result (space in the beginning of the line).|||You really want the history lesson?

Ok, back in the days of CP/M, there was hot debate as to what constituted a "line end". The Unix crew wanted Line Feed (0x0a). The OASIS crew wanted Carriage Return (0x0d). Nobody would budge.

Teletypes needed both, and CR took longer to execute than LF did, so it was always sent first. Since nobody could make a "command decision" Gary Kildall made the call that they'd use what the teletypes wanted, to make it easier to print files and vex both of the software camps!

MS-DOS basically picked up where CP/M left off, so it followed the same convention. Windoze is the GUI that was later bolted on to MS-DOS, so it used the same convention... You see where we are headed here, right?

Anywho, the short answer boils down to Transact SQL sees a "line end" as being a carriage return followed by a line feed, aka Char(13) + Char(10) to us hydro-carbon based types.

-PatP

remote transaction on SQL Server

To support remote transaction on SQL Server i have configured user
options to 16384. However if i make changes in other properties of SQL
Server, user option setting reverts to its original value. I would
like to know 1. Is it possible to protect this setting so that change
in other properties do not effect this setting? 2. What are the
properties of SQL Server that are linked with user option settings
(i.e. Changes in those properties cause reverting in user options)?> However if i make changes in other properties of SQL
> Server, user option setting reverts to its original value. I would
> like to know 1. Is it possible to protect this setting so that change
> in other properties do not effect this setting?

The 'user options' configuration option is a bitmask specification. You
need to perform a bitwise OR in order to leave the other options intact.
The script below will turn on the specified option on and retain the other
option settings.

DECLARE
@.run_value int,
@.new_run_value int
CREATE TABLE #UserOptions
(
name varchar(40) NOT NULL,
minimun int,
maximmun int,
config_value int,
run_value int
)
INSERT INTO #UserOptions
EXEC sp_configure 'user options'

SELECT @.new_run_value = run_value | 16384
FROM #UserOptions

EXEC sp_configure 'user options', @.new_run_value
RECONFIGURE WITH OVERRIDE
DROP TABLE #UserOptions
GO

--
Hope this helps.

Dan Guzman
SQL Server MVP

"T.S.Negi" <tilak.negi@.mind-infotech.com> wrote in message
news:a1930058.0402152114.6d399d0c@.posting.google.c om...
> To support remote transaction on SQL Server i have configured user
> options to 16384. However if i make changes in other properties of SQL
> Server, user option setting reverts to its original value. I would
> like to know 1. Is it possible to protect this setting so that change
> in other properties do not effect this setting? 2. What are the
> properties of SQL Server that are linked with user option settings
> (i.e. Changes in those properties cause reverting in user options)?

Remote synchronization

Hi
We are considering an access front end app with back end tables on sql
server in our office. Is there a way to have a copy this app on a laptop
for a tele-worker and have it synchronised from time to time using either a
3G data connection, or the office LAN when the tele-worker is in the office?
I presume we will have to make copies of both access front end and sql
server backend on the laptop and then the laptop sql server will synchronise
with the office sql server. Is there a better way to handle this?
Thanks
Regards
have a look at DB Ghost - http://www.dbghost.com - I use it to synchronize my
laptop with the production database when I'm online so I have a database at
all times to run reports on.
"John" wrote:

> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either a
> 3G data connection, or the office LAN when the tele-worker is in the office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
>
|||For occasional testing... I simply backup/restore or attach/detach... Mostly
I use backup/restore because the production database does not have to come
down ( and the backups are already made).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <John@.nospam.infovis.co.uk> wrote in message
news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the
office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will
synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
|||I was under the impression that sql server supports synchronisation...or is
replication something different?
Thanks
Regards
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uzGwBYHBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> For occasional testing... I simply backup/restore or attach/detach...
Mostly[vbcol=seagreen]
> I use backup/restore because the production database does not have to come
> down ( and the backups are already made).
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John" <John@.nospam.infovis.co.uk> wrote in message
> news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
laptop[vbcol=seagreen]
either
> a
> office?
> synchronise
>

Remote synchronization

Hi
We are considering an access front end app with back end tables on sql
server in our office. Is there a way to have a copy this app on a laptop
for a tele-worker and have it synchronised from time to time using either a
3G data connection, or the office LAN when the tele-worker is in the office?
I presume we will have to make copies of both access front end and sql
server backend on the laptop and then the laptop sql server will synchronise
with the office sql server. Is there a better way to handle this?
Thanks
Regardshave a look at DB Ghost - http://www.dbghost.com - I use it to synchronize m
y
laptop with the production database when I'm online so I have a database at
all times to run reports on.
"John" wrote:

> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the offic
e?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will synchroni
se
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
>|||For occasional testing... I simply backup/restore or attach/detach... Mostly
I use backup/restore because the production database does not have to come
down ( and the backups are already made).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <John@.nospam.infovis.co.uk> wrote in message
news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the
office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will
synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>|||I was under the impression that sql server supports synchronisation...or is
replication something different?
Thanks
Regards
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uzGwBYHBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> For occasional testing... I simply backup/restore or attach/detach...
Mostly
> I use backup/restore because the production database does not have to come
> down ( and the backups are already made).
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John" <John@.nospam.infovis.co.uk> wrote in message
> news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
laptop[vbcol=seagreen]
either[vbcol=seagreen]
> a
> office?
> synchronise
>

Remote Procedure Call Failed

Hi,
We are running IIS 4 under NT Server 4.0 Server, Serice pack 3; SQL
Server 6.5, Service Pack 3 and ASP 2.0, for our development databases.
We recently upgraded to IIS 4 and since then we keep getting thid
Remote Procedure error.
The exact error reads:
The server has reached the maximum recovery limit for the application
during the processing of your request. Please contact the server
administrator for assistance.
The next message that comes up is:
Server Application Error
The server has reached the maximum recovery limit for the application
during the processing of your request. Please contact the server
administrator for assistance.HTTP/1.1 500 Server Error Server:
Microsoft-IIS/4.0 Date: Mon, 29 Mar 1999 22:09:57 GMT Connection:
close Content-Type: text/html Content-Length: 93 The remote procedure
call failed.
We keep rebooting the server but this error persists. I can't find
anything that points to what can be causing this.
Has anyone else come across this problem?
Thanx in advance,
-=lata=-Lata,
1. Does this error happen only on the IIS? At the time of error, are you
able to use Query analyser and enterpirse manager and other client
connections to connect to sql server?
2. When you say you rebooted the server, is it the IIS server or the sQL
Server or the Windows server?
If other sql server applications and client connections are running fine,
then it could be an IIS issue.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Remote Procedure Call Failed

Hi,
We are running IIS 4 under NT Server 4.0 Server, Serice pack 3; SQL
Server 6.5, Service Pack 3 and ASP 2.0, for our development databases.
We recently upgraded to IIS 4 and since then we keep getting thid
Remote Procedure error.
The exact error reads:
The server has reached the maximum recovery limit for the application
during the processing of your request. Please contact the server
administrator for assistance.
The next message that comes up is:
Server Application Error
The server has reached the maximum recovery limit for the application
during the processing of your request. Please contact the server
administrator for assistance.HTTP/1.1 500 Server Error Server:
Microsoft-IIS/4.0 Date: Mon, 29 Mar 1999 22:09:57 GMT Connection:
close Content-Type: text/html Content-Length: 93 The remote procedure
call failed.
We keep rebooting the server but this error persists. I can't find
anything that points to what can be causing this.
Has anyone else come across this problem?
Thanx in advance,
-=lata=-
Lata,
1. Does this error happen only on the IIS? At the time of error, are you
able to use Query analyser and enterpirse manager and other client
connections to connect to sql server?
2. When you say you rebooted the server, is it the IIS server or the sQL
Server or the Windows server?
If other sql server applications and client connections are running fine,
then it could be an IIS issue.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Remote MS Sql Server

Hi collegues,
I've to managing some "sqlserver server" on shared hosting on CrystalTech
structure.
Now I use "enterprise manager 2000" but it's very slow in every operations
also If I've a 1Mbit DSL, and I see all db in every server, not only mine
db.
Are there some other tools to manage remotly sql server, more fast?
Thanks
Merlinox (Italy)
http://merlinox.splinder.it
http://www.merlinox.tk (per l'Aido)
Merlinox (Italy)
http://merlinox.splinder.it
http://www.merlinox.tk (per l'Aido)
> Are there some other tools to manage remotly sql server, more fast?
Query Analyzer
|||But to use query analyzer I've to manage all with T-SQL.
There aren't visual tools.
Right?
On Tue, 27 Apr 2004 17:20:29 +0300, Bojidar Alexandrov
<bojo_do_not_spam@.kodar.net> wrote:

> Query Analyzer
>
Merlinox (Italy)
http://merlinox.splinder.it
http://www.merlinox.tk (per l'Aido)
|||Merlinox typed:

> Are there some other tools to manage remotly sql server, more fast?
Have a look to myLittleAdmin For MS SQL
More info on http://www.myLittleTools.net/mla_sql
Live demo on http://www.myLittleTools.net/livedemo/mla_sql
More products available on
http://www.microsoft.com/sql/msde/partners/default.asp
Best regards
Elian Chrebor
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin : online MS SQL manager
// http://www.mylittletools.net
// webmaster@.mylittletools.net
|||Do you tested it?
I see may download lite version.
Can't testing full version?
On Tue, 27 Apr 2004 16:33:08 +0200, el.c. - myLittleTools.net
<NOwebmasterSPAM@.mylittletools.net> wrote:

> Merlinox typed:
>
> Have a look to myLittleAdmin For MS SQL
> More info on http://www.myLittleTools.net/mla_sql
> Live demo on http://www.myLittleTools.net/livedemo/mla_sql
> More products available on
> http://www.microsoft.com/sql/msde/partners/default.asp
> Best regards
> Elian Chrebor
>
> --
> // myLittleTools.net : leading provider of web-based applications.
> // myLittleAdmin : online MS SQL manager
> // http://www.mylittletools.net
> // webmaster@.mylittletools.net
>
Merlinox (Italy)
http://merlinox.splinder.it
http://www.merlinox.tk (per l'Aido)
|||You can try SQLExecMS,
It is designed to be fast. Full version is available for download.
JS
"Merlinox" <merlinox@.dontspamhotmail.com> wrote in message
news:opr64b6au8zpbug4@.msnews.microsoft.com...
> Hi collegues,
> I've to managing some "sqlserver server" on shared hosting on CrystalTech
> structure.
> Now I use "enterprise manager 2000" but it's very slow in every operations
> also If I've a 1Mbit DSL, and I see all db in every server, not only mine
> db.
> Are there some other tools to manage remotly sql server, more fast?
> Thanks
> --
> Merlinox (Italy)
> http://merlinox.splinder.it
> http://www.merlinox.tk (per l'Aido)
> --
> Merlinox (Italy)
> http://merlinox.splinder.it
> http://www.merlinox.tk (per l'Aido)
|||Thank you John.
Just I 've 2 minutes I'll try it.
I hope is this:
http://www.laplas-soft.com/
On Tue, 27 Apr 2004 20:23:26 -0400, John Smith <wp456@.mail.ru> wrote:

> You can try SQLExecMS,
> It is designed to be fast. Full version is available for download.
> JS
>
> "Merlinox" <merlinox@.dontspamhotmail.com> wrote in message
> news:opr64b6au8zpbug4@.msnews.microsoft.com...
>
Merlinox (Italy)
http://merlinox.splinder.it
http://www.merlinox.tk (per l'Aido)
|||I try it.
It seems very fast, but there aren't any wizard to create objects.
It's like query analyzer.
And so, it isn't free.
Thank you
On Tue, 27 Apr 2004 20:23:26 -0400, John Smith <wp456@.mail.ru> wrote:

> You can try SQLExecMS,
> It is designed to be fast. Full version is available for download.
> JS
>
> "Merlinox" <merlinox@.dontspamhotmail.com> wrote in message
> news:opr64b6au8zpbug4@.msnews.microsoft.com...
>
Merlinox (Italy)
http://merlinox.splinder.it
http://www.merlinox.tk (per l'Aido)
|||Merlinox typed:
> Do you tested it?
> I see may download lite version.
> Can't testing full version?
The full version can be tested online in the live demo section.
Best regards
Elian Chrebor
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin : online MS SQL manager
// http://www.mylittletools.net
// webmaster@.mylittletools.net

Remote Manage SQL Server Agent via SSMS

When I open up SSMS from the SQL Server 2005 box itself I can see all SQL
Server Agent jobs. When I open a specific job I can see the owner and steps
etc. When I use SSMS remotely from my Vista laptop to connect to the SQL
Server 2005 instance I can see the jobs, but when I go to look at properties
it is acting like it is a new job with none of the actual owner/config
information. The account I am using to connect in both cases is the same
account and is in the sysadmin role. Any advice is appreciated.
Thanks
Adam SYou need to install SP2 or later on your client machine. I believe you have
a mismatch between client and server (a later edition has probably been
upgraded on the server). You should always try to maintain consistency
between the version of tools installed on the server and all clients that
will access it...
A
"Adam S" <Adam S@.community.nospam> wrote in message
news:7B3CEA63-4090-48D4-AFEA-70487F537E5E@.microsoft.com...
> When I open up SSMS from the SQL Server 2005 box itself I can see all SQL
> Server Agent jobs. When I open a specific job I can see the owner and
> steps
> etc. When I use SSMS remotely from my Vista laptop to connect to the SQL
> Server 2005 instance I can see the jobs, but when I go to look at
> properties
> it is acting like it is a new job with none of the actual owner/config
> information. The account I am using to connect in both cases is the same
> account and is in the sysadmin role. Any advice is appreciated.
> Thanks
> --
> Adam S

Remote Manage SQL Server Agent via SSMS

When I open up SSMS from the SQL Server 2005 box itself I can see all SQL
Server Agent jobs. When I open a specific job I can see the owner and steps
etc. When I use SSMS remotely from my Vista laptop to connect to the SQL
Server 2005 instance I can see the jobs, but when I go to look at properties
it is acting like it is a new job with none of the actual owner/config
information. The account I am using to connect in both cases is the same
account and is in the sysadmin role. Any advice is appreciated.
Thanks
Adam S
You need to install SP2 or later on your client machine. I believe you have
a mismatch between client and server (a later edition has probably been
upgraded on the server). You should always try to maintain consistency
between the version of tools installed on the server and all clients that
will access it...
A
"Adam S" <Adam S@.community.nospam> wrote in message
news:7B3CEA63-4090-48D4-AFEA-70487F537E5E@.microsoft.com...
> When I open up SSMS from the SQL Server 2005 box itself I can see all SQL
> Server Agent jobs. When I open a specific job I can see the owner and
> steps
> etc. When I use SSMS remotely from my Vista laptop to connect to the SQL
> Server 2005 instance I can see the jobs, but when I go to look at
> properties
> it is acting like it is a new job with none of the actual owner/config
> information. The account I am using to connect in both cases is the same
> account and is in the sysadmin role. Any advice is appreciated.
> Thanks
> --
> Adam S

Remote hosted database - SQLServer 2000

Hi all

We have a small database that we host on our own local server. In order to
get the information into the database I have a VB program that collates the
information from a variety of sources and then over our local internal
network writes it to the database tables.

This information is then made available over the internet using the
companies broadband connection. In order to alleviate bandwidth issues we
are looking at paying for someone else to host the database.

What I am hoping to achieve is to keep the VB software, but during the night
upload the data to the remotely hosted SQL server using say a series of
update statements. Does anyone know if this is possible, and will SQL Server
look after the integratory of the data. Is there any issues with the
relatively low speed of then Internet as compared with a local network
environment. The amount of data we are looking at moving is very little,
some where in the region of a few hundred records per night split over about
10 tables.

many thanks

Andy"aaj" <a.b@.c.com> wrote in message
news:40a09390$0$13571$afc38c87@.news.easynet.co.uk. ..
> Hi all
> We have a small database that we host on our own local server. In order to
> get the information into the database I have a VB program that collates
the
> information from a variety of sources and then over our local internal
> network writes it to the database tables.
> This information is then made available over the internet using the
> companies broadband connection. In order to alleviate bandwidth issues we
> are looking at paying for someone else to host the database.
> What I am hoping to achieve is to keep the VB software, but during the
night
> upload the data to the remotely hosted SQL server using say a series of
> update statements. Does anyone know if this is possible, and will SQL
Server
> look after the integratory of the data. Is there any issues with the
> relatively low speed of then Internet as compared with a local network
> environment. The amount of data we are looking at moving is very little,
> some where in the region of a few hundred records per night split over
about
> 10 tables.
> many thanks
> Andy

If you can connect to the server directly, then you can run INSERT/UPDATE
statements as you would normally. For a few hundred records (rows?) this
should work fine. I'm not sure what you mean by "looking after the integrity
of the data". If you want to ensure the data was not modified in
transmission, you can look at some sort of check digit or checksum.

If the amount of data grows, you might need to look at other options, such
as sending a file to the server via FTP, then loading it with bcp.exe or
DTS, but that would depend on the hosting provider's service.

Simon

Remote connections to named instances fails on SQL 2005 cluster

I have a new SQL Server 2005 cluster with multiple named instances of SQL
Server 2005 running. From any cluster machine, I can connect to any instanc
e
of SQL Server running in the cluster. From remote machines, I can connect t
o
the default instance of SQL Server, but I can not connect to any named
instances. Help?
+ SQL Browser is running on one physical machine in the cluster
+ Surface Area Configuration has "remote clients" enabled for all instances
+ Named pipes and TCP/IP are enabled
+ DTC is running on the cluster. It is configured to allow network access
on each physical machine.
+ Windows firewall is disabled. Remote machines on same subnet as cluster
machines.
+ Client machine can ping virtual servers?
After waiting a few hours, remote connections now work
?
"Bill Q" wrote:

> I have a new SQL Server 2005 cluster with multiple named instances of SQL
> Server 2005 running. From any cluster machine, I can connect to any insta
nce
> of SQL Server running in the cluster. From remote machines, I can connect
to
> the default instance of SQL Server, but I can not connect to any named
> instances. Help?
> + SQL Browser is running on one physical machine in the cluster
> + Surface Area Configuration has "remote clients" enabled for all instance
s
> + Named pipes and TCP/IP are enabled
> + DTC is running on the cluster. It is configured to allow network access
> on each physical machine.
> + Windows firewall is disabled. Remote machines on same subnet as cluster
> machines.
> + Client machine can ping virtual servers

Remote connection to SqlServer

Hello Guys
We are developing a CRM application using Delphi Front end &
Sqlserver as back end which is
residing on Windows 2000 server. I need a best possible solution,
if this CRM app fornt end is installed in different Location and
making connection to the Sqlserver which is altogether in different site...
Thanks
Chandru
There is usually no problem at all using the OLEDB SQL-Server driver over
the internet if the port 1433 is not blocked by a firewall or if you are
able to setup a proxy server. The transport layer will be totally
transparent to your application.
S. L.
"Chandru" <chandru@.knigthoodcorporate.com> wrote in message
news:%23OnHId0xEHA.1168@.TK2MSFTNGP10.phx.gbl...
> Hello Guys
> We are developing a CRM application using Delphi Front end &
> Sqlserver as back end which is
> residing on Windows 2000 server. I need a best possible solution,
> if this CRM app fornt end is installed in different Location and
> making connection to the Sqlserver which is altogether in different
> site...
>
> Thanks
> Chandru
>
>
>

Remote connection to SqlServer

Hello Guys
We are developing a CRM application using Delphi Front end &
Sqlserver as back end which is
residing on Windows 2000 server. I need a best possible solution,
if this CRM app fornt end is installed in different Location and
making connection to the Sqlserver which is altogether in different site...
Thanks
ChandruThere is usually no problem at all using the OLEDB SQL-Server driver over
the internet if the port 1433 is not blocked by a firewall or if you are
able to setup a proxy server. The transport layer will be totally
transparent to your application.
S. L.
"Chandru" <chandru@.knigthoodcorporate.com> wrote in message
news:%23OnHId0xEHA.1168@.TK2MSFTNGP10.phx.gbl...
> Hello Guys
> We are developing a CRM application using Delphi Front end &
> Sqlserver as back end which is
> residing on Windows 2000 server. I need a best possible solution,
> if this CRM app fornt end is installed in different Location and
> making connection to the Sqlserver which is altogether in different
> site...
>
> Thanks
> Chandru
>
>
>