You guys did a amazing work.

Keep it up

DECLARE @string VARCHAR(8000)

SET @string =''

SELECT @string = @string + <ColumnName> FROM <TableName>

The best way to deal with orhpaned user is to create the user with same SID in test environment. This will resolve the problem for good. Let us know if...

You have to use some kind of loop, whether in form of cursor or loop

my experience loop are faster than cursors. You can also use case instead of using right...

Can you send your proc

I think answer to question "How can I tell how much of the memory the server has (2GB) is being used by each database?" is "not possible" and I am not aware...

I am not asking anyone to move to India. I am looking for a developer who is in India. Secondly though there may be lot of IT developers in India...

He may be correct in saying that the agent may not start but it is not a good enough reason for not restaring the agent.

If someone is suspicious that the...

I do not think there should be any problem by restarting the Agent service if none of the jobs were running or were schedule to run in between the time...

This article may be a good start

http://www.sql-server-performance.com/sk_connection_pooling_myths.asp

Use datediff function to determine the result set

DATEDIFF ( dd , '3/2/2006' ,PickupDate )  > 0

kill Dtsrun.exe on the server

You will find equal number of people supporting both side of the equation. Coming to your question  "would have a huge impact on a database of less than 1 million rows?"...

When you move your database. View will be automatically tranfers. Views are in database.

Full text search in SQL Server will only work if SQL Server is running in the System account