Emanuel,

A CD kit costs about $25 if you have a license for SW.

Login Transfer: Please, take a look at those articles.

I also have a script to transfer logings + SIDs,...

Hi,

That is exactly what I am saying with understanding that SQL Server database outside the firewall will contain only public information or take care of securing sensitive information. In this...

David,

You may also consider planning your database structure. For example, this table and its non-clustered indexes should be on different drives You don't say you have any, but you have...

You are right.

I know that ports need to be open for Windows Integrated Authentication. Here is the list what can be checked

139 - NetBios

441 - SSL

http://techrepublic.com.com/5100-6264-5054630.html#

lists also:

• UDP...

We did several domain migrations and I had no problems with downtime.

There are some other problems to pay attention to:

1. Check everything that has Windows Integrated Authentication: logins, jobs, DTS...

Hi,

I would use ODBC source. See sp_addlinkedserver Books Online topic for the syntax for using ODBC source, there are a couple. One of the examples uses Provider String parameter. You...

Hello  Embrenchia,

Did those users disconnect their Enterprise Managers and connected again after you changed their rights?

Are they able to execute sp_addlinkedserver and sp_addlinkedserverlogin from Query Analyzer?

Yelena

Hi Emanuel,

I am in the process of upgrading my last 6.5/NT4 to SQL2K/Windows 2000. I upgraded many 6.5 s and it is possible I may help you with your problems.

I...

I would run a Profiler Trace. You can configure it with a lot of events and filters to get all logon events, database batches, statements whatever is your business need.

Yelena

You may probably use escape characters. See Books Online "Like" topic:

Pattern Matching with the ESCAPE Clause

You can search for character strings that include one or more of the special wildcard...

There is one recommendation: if you select to store images as external files and you will distribute your application to other organizations do not forget to advise them what directories...

Another good tool to export/import from/to MS ACCESS is SQL Server DTS (Data Transformation Services) that you can run as a job. This is easy to implement if you have...

Hello,

I know one MS Access application where just several tables backed up by using VBA. You can use Recordset object and then export its content to a file.

Yelena

Hello Dbn,

Thanks for the advice. Could you post a short description how I should run W3DBVER.EXE?

I will look up it myself too, but any advice is welcome.

Yelena

ODBC source is a common tool for 6.5 and 2000, Query Analyzer version and Entrprise Manager version were 6.5 when connecting to 6.5 server and 2000 when connecting to 2000 server....