Please suggest links, docs as to how should I transfer data, user
information from SQL server on Winnt to SQL on Windows 2000 server.


Thanks Pradeep

Hi
http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q224071-------
Moving SQL Server Databases to a New Location

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133-------- 
How To Transfer Logins and Passwords Between SQL Servers (Q246133)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#9 ----- Move
Databases between computers running by sql server







Show quoteHide quote

Thanks a lot. I'll look through thos links.

More important than the operating system version is the SQL Server version.

DTS could help to transfer data and users between these servers. Depending
on the version you could also do backup/restore and attach/detach databases.

For example you can detach SQL Server 7 databases and attach them to SQL
Server 2000. In the same way, you can do a backup in SQL Server 7 and
restore it to a SQL Server 2000 instance. For more details see Upgrading to
SQL Server 2000 in BOL.

Ben Nevarez
MCDBA, MCP, OCP


Show quoteHide quote

Still struggling w/ LAST transaction date!!!
DISTINCT MonthName for a lot of dates....
Dynamic Stored Procedure
Dynamic WHERE & Dates
Sum() And Nulls