does sqlserver install auto w/Small Bus Srv 2003

Does SQL server install automatically with SBS?
I did an install last night for a client, not at server
at this time.
Did this install auto?I do not believe that it is part of the automated setup.
Rand
This posting is provided "as is" with no warranties and confers no rights.

does sqlserver install auto w/Small Bus Srv 2003

Does SQL server install automatically with SBS?
I did an install last night for a client, not at server
at this time.
Did this install auto?I do not believe that it is part of the automated setup.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Does SQL Server 2005 Express support Web/Internet Replication to other SQL Server Express Client

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

Shabby wrote:

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

You have to sync to a SS2005 with IIS. Replication doesn't support sync between sql express.

Shabby wrote:

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

No Sql 2005 express cannot sync with sql 2005 express directly.

|||

SQL Server 2005 Express Edition supports being a replication subscriber only. See http://msdn2.microsoft.com/en-us/library/ms165700.aspx The publisher and distributor must be higher SKUs of SQL Server 2005. i.e. Enterprise, Standard, Workgroup. As for synching via IIS over the internet with merge replication, this is supported by the SQL Server 2005 Express client.

Hope this helps,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

|||

Peng Song wrote:

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

does the client (subscriber) running on sql server express has to have IIS or only the publishing pc? thanks

sql

Does Sql 2000 Cluster require DTC?

Hello,
Currently I need to deploy a cluster environment for my client. I've
found many topics discussing about whether Sql 2000 cluster requires
DTC to operate, but still see no final answer for it. Can someone
please help me answer this question?
Thanks,
BN
SQL does not require it, but Exchange does. We have dozens of SQL Clusters
running nicely without MSDTC.
You might need it for your applications to use SQL though, check with your
software vendors.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
<buunguyen@.psv.com.vn> wrote in message
news:1128374943.452421.139090@.f14g2000cwb.googlegr oups.com...
> Hello,
> Currently I need to deploy a cluster environment for my client. I've
> found many topics discussing about whether Sql 2000 cluster requires
> DTC to operate, but still see no final answer for it. Can someone
> please help me answer this question?
> Thanks,
> BN
>
|||Thanks so much for your answer and proof ;-) Rod.
Regards,
Nguyen

Does SP4 client work OK with SP3a server?

Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
We are planning on updating all the client pcs to SP4 before we upgrade the
servers.
Thanks
Rondid you hear examnotes <Ron@.discussions.microsoft.com> say in
news:0D2D4D7E-7BAF-4600-A545-0B2FB6E82291@.microsoft.com:

> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a
> server? We are planning on updating all the client pcs to SP4 before
> we upgrade the servers.
> Thanks
> Ron
I have a mix of 3a and 4 and my client db libs are 4. you should be ok.
(My 2)
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||You won't be able to use Query Analyzer's debugger against the SP3a
servers. In SP4, Microsoft upgraded the debugger to use the .NET
framework. Other than that, there should be no problems.
Josh
Ron wrote:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server
?
> We are planning on updating all the client pcs to SP4 before we upgrade th
e
> servers.
> Thanks
> Ronsql

Does SP4 client work OK with SP3a server?

Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
We are planning on updating all the client pcs to SP4 before we upgrade the
servers.
Thanks
Rondid you hear =?Utf-8?B?Um9u?= <Ron@.discussions.microsoft.com> say in
news:0D2D4D7E-7BAF-4600-A545-0B2FB6E82291@.microsoft.com:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a
> server? We are planning on updating all the client pcs to SP4 before
> we upgrade the servers.
> Thanks
> Ron
I have a mix of 3a and 4 and my client db libs are 4. you should be ok.
(My 2¢)
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||You won't be able to use Query Analyzer's debugger against the SP3a
servers. In SP4, Microsoft upgraded the debugger to use the .NET
framework. Other than that, there should be no problems.
Josh
Ron wrote:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
> We are planning on updating all the client pcs to SP4 before we upgrade the
> servers.
> Thanks
> Ron

Does Service Pack 2 affect Client Tools?

Hello,

Does Service Pack 2 affect client tools? In other words, if you have a client machine with just the tools installed (management studio, BIDS, etc) do I need to run the SP2 package on this client as well?

Regards, Jeroen

YES. Always update ALL clients to the same SP as the servers.

|||thnx Tom...sql

Does RS support to change the report size automatically?-URGENT!!!

I will use MSRS to create reports in a .Net Smart Client project later.

For some kinds of report, there are some customized columns which may be displayed or not. I design these reports like this: first create all the columns, then set the "Visibility-Hidden" property of those customized columns using expression which including some report parameters.Thus, these customized columns can be displayed or hidden by setting the value of the report parameters at the runtime. But another problem emerged.The size of report backgroud can not changed automatically along with the length of DataTable.So if there are some columns be hidden, there will be some margin on the right of the report and the Title of report was still in the center of the original report,not changed to the center of the new one. Due to the "Size " property of report and the "Size"&"Location"properties of textbox does not support expression.

Is there any one can give me some solution?

I am not sure whether the current version of MSRS support such kind of requirement?If not,will the MSRS final release comes out on November 7 support it?

Thanks!

Hi!

I also have this problem! I am building subreports that are getting more and more generic, but now I have noticed that the (optionally) hidden rows in the subreport's table is showing up as blank space on the main report. That makes this useful way of making the subreports nothing more than useless.

I have found no way to set the size of the subreport "background" or rectangle smaller than the designed area.

The reporting services seems more and more tied down to me. It has to have much more abilities than it currently has to survive. At the moment automation of Word seems much more flexible, but is client based. Still, in many situations the current RS will not deliver enough to fulfill the requirements. I hope this will change soon.

/Michael

|||The report never shrinks the size of the body so hiding a bunch of columns won't help your report. If you want a title to span the items in a table, put it in the table header, similar to how this matrix report was done: http://blogs.msdn.com/bwelcker/archive/2005/05/11/416720.aspx.|||But I am using a "table" as a way of displaying different checkboxes and texts, as a form, and sometimes one or more of the rows in these (generic) subreports are not to be used and I hide them (that's what makes it more generic).

I am not using it to show a list of information but as a way of showing a dynamic one-page form.

When I hide a row it shows up as approximately half a row of blank space on the main report. In this case the Visiblity setting is useless since there is too much space between subreports on the main report.

Does RS support to change the report size automatically?-URGENT!!!

I will use MSRS to create reports in a .Net Smart Client project later.

For some kinds of report, there are some customized columns which may be displayed or not. I design these reports like this: first create all the columns, then set the "Visibility-Hidden" property of those customized columns using expression which including some report parameters.Thus, these customized columns can be displayed or hidden by setting the value of the report parameters at the runtime. But another problem emerged.The size of report backgroud can not changed automatically along with the length of DataTable.So if there are some columns be hidden, there will be some margin on the right of the report and the Title of report was still in the center of the original report,not changed to the center of the new one. Due to the "Size " property of report and the "Size"&"Location"properties of textbox does not support expression.

Is there any one can give me some solution?

I am not sure whether the current version of MSRS support such kind of requirement?If not,will the MSRS final release comes out on November 7 support it?

Thanks!

Hi!

I also have this problem! I am building subreports that are getting more and more generic, but now I have noticed that the (optionally) hidden rows in the subreport's table is showing up as blank space on the main report. That makes this useful way of making the subreports nothing more than useless.

I have found no way to set the size of the subreport "background" or rectangle smaller than the designed area.

The reporting services seems more and more tied down to me. It has to have much more abilities than it currently has to survive. At the moment automation of Word seems much more flexible, but is client based. Still, in many situations the current RS will not deliver enough to fulfill the requirements. I hope this will change soon.

/Michael

|||The report never shrinks the size of the body so hiding a bunch of columns won't help your report. If you want a title to span the items in a table, put it in the table header, similar to how this matrix report was done: http://blogs.msdn.com/bwelcker/archive/2005/05/11/416720.aspx.|||But I am using a "table" as a way of displaying different checkboxes and texts, as a form, and sometimes one or more of the rows in these (generic) subreports are not to be used and I hide them (that's what makes it more generic).

I am not using it to show a list of information but as a way of showing a dynamic one-page form.

When I hide a row it shows up as approximately half a row of blank space on the main report. In this case the Visiblity setting is useless since there is too much space between subreports on the main report.sql

Does it possibile use SQL Client 2000 and connect to the SQL7?

I'd like to know if SQL 2000 client and SQL 7 Server are compatible.
I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as
you it is not possibile to install SQL 7.0 Client on the Windows server2003.
Tx
Suzana
Hi
Yes it is. SQL Server 2000 components are backward compatible with SQL
Server 7.0
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suzan" <Suzan@.discussions.microsoft.com> wrote in message
news:D5D97C69-033D-4AF6-9343-22C11FA7F625@.microsoft.com...
> I'd like to know if SQL 2000 client and SQL 7 Server are compatible.
> I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as
> you it is not possibile to install SQL 7.0 Client on the Windows
> server2003.
> Tx
> Suzana
>
|||Could you please tell me where can I find more information about
compatibility between SQL Client2000 and SQL server 7.0.
I found some information about how to connect a SQL Server 7.0 client to a
SQL Server 2000 but not vice versa
Thanks,
Suzan
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Yes it is. SQL Server 2000 components are backward compatible with SQL
> Server 7.0
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Suzan" <Suzan@.discussions.microsoft.com> wrote in message
> news:D5D97C69-033D-4AF6-9343-22C11FA7F625@.microsoft.com...
>
>
|||Hi
This is all I found:
http://msdn.microsoft.com/library/de...bckwd_3vlc.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suzan" <Suzan@.discussions.microsoft.com> wrote in message
news:90E6271F-C04C-40F6-B0CC-E9D66D9A800F@.microsoft.com...[vbcol=seagreen]
> Could you please tell me where can I find more information about
> compatibility between SQL Client2000 and SQL server 7.0.
> I found some information about how to connect a SQL Server 7.0 client to a
> SQL Server 2000 but not vice versa
> Thanks,
> Suzan
>
> "Mike Epprecht (SQL MVP)" wrote:

Does Force Protocol Encryption on Server Require Certificate to be Installed on Client?

So I was able to enable the option to Force Protocol Encryption using
SQL. However, I was still able to connect to this instance of SQL
using the Query Analyzer tool from a machine without the certificate
(public key) installed.
This leads me to believe that the client connected to the server w/out
encrypting communications or that the client doesnt require a
certificate in order to connect (encrypted) to the instance of SQL now
configured to force protocol encryption. As a result, I have the
following question.
Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
What does it mean when I connect to the instance of SQL from a machine
w/out the certificate? How is this working? Are communications still
encrypted from client to server?
Thanks in advance for any help/direction.
If found a good article.
http://msdn.microsoft.com/library/de...SecNetHT19.asp
"Note that, in all cases, SQL Server sends its server authentication
certificate in the clear to the client at the beginning of the
communication sequence. This is part of the SSL protocol. Note that
this occurs even when neither the server nor the client requires
encryption."
nasteric@.yahoo.com (nasteric) wrote in message news:<e651d8ae.0406012052.5e1c2f41@.posting.google. com>...
> So I was able to enable the option to Force Protocol Encryption using
> SQL. However, I was still able to connect to this instance of SQL
> using the Query Analyzer tool from a machine without the certificate
> (public key) installed.
> This leads me to believe that the client connected to the server w/out
> encrypting communications or that the client doesnt require a
> certificate in order to connect (encrypted) to the instance of SQL now
> configured to force protocol encryption. As a result, I have the
> following question.
> Once protocol encryption is enabled on the server using the SQL Server
> Network Utility, must the certificate (public key) be installed on the
> client in order to access SQL on the server (now configured to force
> protocol encryption)?
> What does it mean when I connect to the instance of SQL from a machine
> w/out the certificate? How is this working? Are communications still
> encrypted from client to server?
> Thanks in advance for any help/direction.

Does Force Protocol Encryption on Server Require Certificate to be Installed on Client?

So I was able to enable the option to Force Protocol Encryption using
SQL. However, I was still able to connect to this instance of SQL
using the Query Analyzer tool from a machine without the certificate
(public key) installed.
This leads me to believe that the client connected to the server w/out
encrypting communications or that the client doesnt require a
certificate in order to connect (encrypted) to the instance of SQL now
configured to force protocol encryption. As a result, I have the
following question.
Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
What does it mean when I connect to the instance of SQL from a machine
w/out the certificate? How is this working? Are communications still
encrypted from client to server?
Thanks in advance for any help/direction.If found a good article.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT19.asp
"Note that, in all cases, SQL Server sends its server authentication
certificate in the clear to the client at the beginning of the
communication sequence. This is part of the SSL protocol. Note that
this occurs even when neither the server nor the client requires
encryption."
nasteric@.yahoo.com (nasteric) wrote in message news:<e651d8ae.0406012052.5e1c2f41@.posting.google.com>...
> So I was able to enable the option to Force Protocol Encryption using
> SQL. However, I was still able to connect to this instance of SQL
> using the Query Analyzer tool from a machine without the certificate
> (public key) installed.
> This leads me to believe that the client connected to the server w/out
> encrypting communications or that the client doesnt require a
> certificate in order to connect (encrypted) to the instance of SQL now
> configured to force protocol encryption. As a result, I have the
> following question.
> Once protocol encryption is enabled on the server using the SQL Server
> Network Utility, must the certificate (public key) be installed on the
> client in order to access SQL on the server (now configured to force
> protocol encryption)?
> What does it mean when I connect to the instance of SQL from a machine
> w/out the certificate? How is this working? Are communications still
> encrypted from client to server?
> Thanks in advance for any help/direction.

Does Force Protocol Encryption on Server Require Certificate to be Installed on Client

So I was able to enable the option to Force Protocol Encryption using
SQL. However, I was still able to connect to this instance of SQL
using the Query Analyzer tool from a machine without the certificate
(public key) installed.
This leads me to believe that the client connected to the server w/out
encrypting communications or that the client doesnt require a
certificate in order to connect (encrypted) to the instance of SQL now
configured to force protocol encryption. As a result, I have the
following question.
Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
What does it mean when I connect to the instance of SQL from a machine
w/out the certificate? How is this working? Are communications still
encrypted from client to server?
Thanks in advance for any help/direction.If you have a certificate on the Server and Force Protocol Encryption
turned on then the traffic is encrypted to and from all clients. The client
does not need a certificate.
Look at the following article:
HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft Management
Console
http://support.microsoft.com/?id=316898
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Previous post:
"Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
"
The client only requires that the Trusted Root is updated if you enable
protocol encryption from the client.
If it is enabled via Server Network Utility, then the client doesn't need
to Trust the same Root Authority.
Essentially, all you need is a valid certificate on the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||If found a good article.
NetHT19.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
NetHT19.asp
"Note that, in all cases, SQL Server sends its server authentication
certificate in the clear to the client at the beginning of the
communication sequence. This is part of the SSL protocol. Note that
this occurs even when neither the server nor the client requires
encryption."
nasteric@.yahoo.com (nasteric) wrote in message news:<e651d8ae.0406012052.5e1c2f41@.posting.go
ogle.com>...
> So I was able to enable the option to Force Protocol Encryption using
> SQL. However, I was still able to connect to this instance of SQL
> using the Query Analyzer tool from a machine without the certificate
> (public key) installed.
> This leads me to believe that the client connected to the server w/out
> encrypting communications or that the client doesnt require a
> certificate in order to connect (encrypted) to the instance of SQL now
> configured to force protocol encryption. As a result, I have the
> following question.
> Once protocol encryption is enabled on the server using the SQL Server
> Network Utility, must the certificate (public key) be installed on the
> client in order to access SQL on the server (now configured to force
> protocol encryption)?
> What does it mean when I connect to the instance of SQL from a machine
> w/out the certificate? How is this working? Are communications still
> encrypted from client to server?
> Thanks in advance for any help/direction.

Does Force Protocol Encryption on Server Require Certificate to be Installed on Client

So I was able to enable the option to Force Protocol Encryption using
SQL. However, I was still able to connect to this instance of SQL
using the Query Analyzer tool from a machine without the certificate
(public key) installed.
This leads me to believe that the client connected to the server w/out
encrypting communications or that the client doesnt require a
certificate in order to connect (encrypted) to the instance of SQL now
configured to force protocol encryption. As a result, I have the
following question.
Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
What does it mean when I connect to the instance of SQL from a machine
w/out the certificate? How is this working? Are communications still
encrypted from client to server?
Thanks in advance for any help/direction.If found a good article.
NetHT19.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
NetHT19.asp
"Note that, in all cases, SQL Server sends its server authentication
certificate in the clear to the client at the beginning of the
communication sequence. This is part of the SSL protocol. Note that
this occurs even when neither the server nor the client requires
encryption."
nasteric@.yahoo.com (nasteric) wrote in message news:<e651d8ae.0406012052.5e1c2f41@.posting.go
ogle.com>...
> So I was able to enable the option to Force Protocol Encryption using
> SQL. However, I was still able to connect to this instance of SQL
> using the Query Analyzer tool from a machine without the certificate
> (public key) installed.
> This leads me to believe that the client connected to the server w/out
> encrypting communications or that the client doesnt require a
> certificate in order to connect (encrypted) to the instance of SQL now
> configured to force protocol encryption. As a result, I have the
> following question.
> Once protocol encryption is enabled on the server using the SQL Server
> Network Utility, must the certificate (public key) be installed on the
> client in order to access SQL on the server (now configured to force
> protocol encryption)?
> What does it mean when I connect to the instance of SQL from a machine
> w/out the certificate? How is this working? Are communications still
> encrypted from client to server?
> Thanks in advance for any help/direction.

Does a trigger fire once for a set statement

Does a trigger fire once for a set statement, or for every row affected? I
presume that using a client like Access and doing a line by line manual
adjustment, would fire a trigger for each transaction, but does a set
statement (like below) fire the trigger once?
eg
Table_A (column_a, column_b) with these values:
aa, 0.00
aa, 0.00
bb, 0.00
bb, 0.00
Trigger for update, insert on Table_A
if update(column_a)
update Table_A
set
column_b = 1
If I then run a sql statement to update Table_A, will the trigger fire after
each affected row, or simply fire once for the set statement below?
update table_A
set
colum_a = cc
where column_a = 'aa'
Would the trigger update the whole table once, or would it update all of
column_b twice, because of the two aa's.?
I've googled, but not very well as I haven't hit the answer yet...Any
knowledge on this?
Many thanks.
Steve.Steve'o wrote:
> Does a trigger fire once for a set statement, or for every row affected?
The trigger is fired once for each statement. This means that if your
statement affects multiple rows it is still only executed one time.
For more information look at the "CREATE TRIGGER" documentation in Books
Online.
http://msdn.microsoft.com/library/e...reate2_7eeq.asp
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/|||Hi
Also, look at the virtual tables INSERTED and DELETED to see which rows are
affected by your update.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Aaron Weiker" <aaron@.sqlprogrammer.org> wrote in message
news:O$vefqgDFHA.3648@.TK2MSFTNGP10.phx.gbl...
> Steve'o wrote:
> The trigger is fired once for each statement. This means that if your
> statement affects multiple rows it is still only executed one time.
> For more information look at the "CREATE TRIGGER" documentation in Books
> Online.
> http://msdn.microsoft.com/library/e...reate2_7eeq.asp
> --
> Aaron Weiker
> http://aaronweiker.com/
> http://www.sqlprogrammer.org/|||Many thanks, I think I may need to use a curosr then...
I have a table which stores a alpha+numeric sequence number. When a column
in another table is set to true, it fires a trigger to retrive the next
sequence number, then update the sequences table.
I kept it in a sequence table because there are several different sequences,
and this allows a bit of central control.
When updating a row at a time, this will work fine, but if I do a mass
update with a update table statement which affects many rows, the trigger
will only fire once... Hence why Im assuming a cursor is the way forward,
a
bit more reading to do ;)
Thanks for the link.
PS. Already using inserted and deleted in some triggers, just wasn't sure if
they fired for every line, thanks again to both replies.
"Aaron Weiker" wrote:

> Steve'o wrote:
> The trigger is fired once for each statement. This means that if your
> statement affects multiple rows it is still only executed one time.
> For more information look at the "CREATE TRIGGER" documentation in Books
> Online.
> http://msdn.microsoft.com/library/e...reate2_7eeq.asp
> --
> Aaron Weiker
> http://aaronweiker.com/
> http://www.sqlprogrammer.org/
>

Document Management Systems

I have a client that would like to archive all of the documents .word, .xls, .pdf, .jpg, email coorespondance, etc. into some sort of database so in the near future when the project starts up again all of the information is in a clear consise format. I was hoping that this forum could provide some guidance in selecting a software package and a discussion on how to proceed.

I have 6 gigs of documents in a folder on our server.
I was planning on delivering the organized data on a external hard drive after putting the data into some sort of database.
I would like to include metadata about each particular document.
like
who created the document,
Key words about the document's purpose,
time frame the document is revelant for,
and so on.

I would like to use a database structure and possibly hot link the document to the DB.
I would like to use xml (if possible) for the metadata.

any help is greatly appreciated on this
I can be reached at

khively at maximusa dot com

for any additional questionsResponding via email is considered a consulting arrangement by my company. I don't think that's what you had in mind. ;)

Would you like to discuss the idea here in the forum?

-PatP|||Yes I would like to discuss document management software options inside this forum.
Also I might add that I have mimimial database experience. I can run queries in access. That is about it.

thanks in advance

Khively|||Have you considered Microsoft SharePoint? That is a pre-packaged solution that delivers what you've asked for so far.

-PatP

do you need the clients

If i use sql server as my backend and microsoft access as my frontend do i need to purchase client access lisences??yes,

have a look at the following

http://www.microsoft.com/windows2000/en/server/help/default.asp?url=/windows2000/en/server/help/sag_LICEconcepts_121.htm

http://www.microsoft.com/windows2000/en/server/help/default.asp?url=/windows2000/en/server/help/sag_LICEconcepts_122.htm

Cheers

do you have to recreate ODBC after installing MDAC 2.8

Hello:
I just want to ask a quick question just for my future reference. There's
no emergency or anything. Take this scenario.
Client workstations have an ODBC connection, and the Terminal Services box
has an ODBC connection. The versions of the ODBC driver are different, and
you want to make them the same.
So, you download and install MDAC 2.8 on the client workstations and the
Terminal Services box. The version of the ODBC driver, unfortunately, does
not change.
In order to get the versions updated, do the ODBC connections themselves
need to be recreated?
Thanks!
childofthe1980s
No...not necessarily. The only problems I've seen have been
just the general install issues on Terminal Server.
The driver version change doesn't change on which - TS or
the workstations? Did you verify with Component Checker? Did
you reboot? There are some different steps for installing
MDAC on TS - did you follow those?
How to Install ODBC or MDAC on Terminal Server
http://support.microsoft.com/?id=216149
-Sue
On Sun, 14 Jan 2007 09:59:00 -0800, childofthe1980s
<childofthe1980s@.discussions.microsoft.com> wrote:

>Hello:
>I just want to ask a quick question just for my future reference. There's
>no emergency or anything. Take this scenario.
>Client workstations have an ODBC connection, and the Terminal Services box
>has an ODBC connection. The versions of the ODBC driver are different, and
>you want to make them the same.
>So, you download and install MDAC 2.8 on the client workstations and the
>Terminal Services box. The version of the ODBC driver, unfortunately, does
>not change.
>In order to get the versions updated, do the ODBC connections themselves
>need to be recreated?
>Thanks!
>childofthe1980s