Oops, sorry. I just realized that this is not the SQL 2005 section.

You can do this with Service Broker.

Try something like this:

SELECT ITEMNAME

FROM ITEMS

WHERE ITEMNAME LIKE '%' + Replace(@StringThatUsersUseToFind, ' ', ' % ') + '%'

Just remember, your boss is probably having a bad day too.

You might want to look at the new features in SQL Server 2008.

Yes, they all should work. What errors are you getting.

RayMilhon (5/5/2008)

---

Drop Failed for User 'bbch\jsmith'. (Microsoft.sqlServer.Express.Smo)

Additional Information:

An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.Express.ConnectionInfo)

The database principal owns a schema in the database, and connot be dropped. (Microsoft...

Just add PurpleLady's Step 2 above, as the last step of your first job.

This is not the right forum for this post. I suggest that you move it to the "SS2K5 Replication" forum.

"Hey, Mr. Tally Man, tally my big table. Daylight's gone and I wanna go home..."

I would suggest having a separate table that just holds the profile information that needs to be available to all servers and the set that table up as a...

OK, I was able to find one last SQL 2000 server that I can access from here (being shut down at the end of the month). You can get...

Heh. I thought that you were comparing QA to production, as in QA="Quality Assurance" server vs. your Production server. I forgot that here QA="Query Analyzer".

I think that the...

The first thing that you should do is to compare the QA query plan to your Production system's query plan.

Cores do not count as processors for licensing purposes.