What properties you are asking I don't see any properties option for TCP/IP in SAC.

Take a look the following two urls for sample code...

http://www.asp101.com/articles/gal/effectivepaging/default.asp

http://davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx

You didn't answer the question..

Is that user exists in sysusers table?

There may the another user in that db with different SID and your login SID is not matching it... so you...

Log file might have grown to the same size of data file or some one might have created with the same size...

Is all 18GB log file is used? Is there...

Are you using backup log WITH NO_TRUNCATE option?

Can you post your backup log command...

 SQL Server 2005 Connectivity Issue Troubleshooting...

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

I don't think there is any as long as uninstallation completed without any issues..

If you get into any issues you can use the following article...

How to manually remove SQL Server...

Check BOL topics

"Managing ntext, text, and image Data"

"Modifying ntext, text, or image Values"

Only if the source table has the clustered index or order by clause is specified other wise it will not maintain row order...

Creating PK with clustered index is definitely it is offline operation.

You may need to test of dev server how much time it takes to finish...

You can do it creating the...

"However the backup of the log is up to 8 GB , 10 GB at the end of the day after the final log backup."

Is your .ldf files grows to...

You can follow alzdba advise to change the password...

You can create a job to change the SA password every 5/30/60 minutes...you need to write a code for random generating sa...

You can use W switch as David mentioned but I don't understand why you are using subquery...

SELECT * FROM (SELECT RTRIM(COL1 + '|' + COL2 + '|' + COL3) FROM...

Make sure no one is in that instace...Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service...

First try to find it is internal or external attachs?

Check the security log for any useful information...and also as mentioned above work with network engineer to find what exactly going...