Or why not use the CHARINDEX function instead of IN, this would avoid creating a temp table and avoid doing any parsing:

SELECT *

FROM carrier

WHERE CHARINDEX("'" + CARRIER +...

I agree with you iastrebov! I chose the 8GB option as I understood the question as to mean "Which is the smallest amount of memory to be installed at...

Steve,

I also agree with you. The question stated that the user was a developer and I'd assume this means not a DBA - I think the question was a...

I had a similar problem myself where the agent was shown as starting and wouldn't shutdown. Fortunately a reboot solved it.

I still don't know what caused it but sounds...

The following link discusses the problem:

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20293276.html

I believe it is a known problem in sqlmaint.exe which effects databases with computed columns??

Does anyone know of an MS tracking number for...

I'm also having this problem. (See my slightly earlier post "Maintenance plan/DBCC problem").

It might be worth having a look at a MS knowledgebase article:

http://support.microsoft.com/?kbid=301292

Although this hasn't helped...

Does anyone have any thoughts on what rights should be taken away from the public role in master?

It was mentioned above that specifying the workstation id in the connection string could affect connection pooling due to non-identical connection strings.

Please correct me if I'm wrong but the way...