Full text search will work. But you have to create a full text index first.

http://msdn.microsoft.com/en-us/library/ms142547.aspx

I guess I don't understand the problem. I used the following and inserted two rows into the second (services) table.

INSERT INTO Services(ID, ServiceID, ServiceName)

VALUES(100, 1, 'Cleaning'),

(101, 2, 'Repair')

As far...

OK, so not for initial load then?

Umm, remove the PK or FK and populate the table. Then restore the original PK or FK attributes.

I can think of two possible issues here. Both could be present.

First off, you can't connect to SQL Server 2008 using SSMS for 2005. But you can connect...

First off, if you are going to use sa to access the server you will need to login as the domain admin and enable the sa account. This is...

You really need to look at each DB separately as to resource usage and maybe size.

Then you have to ask which consolidation method is best for the DB.

If the DBs...

I like Jack's answer best. SET ROWCOUNT 100 will limit results system wide to 100 rows until it is set back to 0. If you do use...

There is no difference. Both share compatibility level of 100.

SELECT ALL * and SELECT DISTINCT * are on the same order. DISTINCT excludes duplicates from a result set while ALL (the implied default if DISTINCT is not specified)...

You can do either.

Installing a full Standard version of SQL Server 2008 R2 on the same machine will work fine. You will have two instances and each will behave...

Only cast the overall result.

Try this:

CAST(

SUM(CASE WHEN STAT_PRODUCTIVITY.Action != 'Folder'

...

Wow! The ddl_SchemaModified one is a database trigger. Good call!

Thanks for the help.

Jerry

I will look into that. Inherited the db a couple of months ago and haven't found everything yet.

Thansk!

Jerry

You need to CAST the result not each part of the equation.

CAST( number1/number2 AS DECIMAL(18,2)

Should work better. Casting each part separately only guarantees that the numbers in the equation...