We just get a connection.txt file from another organization that should be
useful for my company.

I am new to SQL connection and would like to seek your advice on what does
it mean.

packet size=4096;user id=HRprocess;pwd=process;data source=DA16\B1;persist
security info=False;initial catalog=hrprod
SELECT HR_CHART.ACCNUM AS DEBTORNOID ..... FROM ..... WHERE ......

1) Can we tell the connection is for SQL Server 2000 or SQL Server 2005 ?
This is because we are using SQL Server 2005 for this particular application
?
2) If we have a database user named "HRProd" and password "HRpass" for the
database "hrprod", does it mean that we should use "packet size=4096;user
id=HRProd;pwd=HRpass" ?
3) If the server name is Sydney, does it mean that we use "data
source=Sydney" ?
4) The connection.txt file only contains the SQL Server Connection and SQL
Script, how do we usually use it ?

Thanks

[quoted text, click to view]

No, a connection string is not version-specific.

[quoted text, click to view]

Well, I would use password = not pwd = , but yes.

[quoted text, click to view]

Yes.

[quoted text, click to view]

That's hard to say. What kind of application(s) are you writing?

--
Aaron Bertrand
SQL Server MVP