I could think of simple option here is-

Declare @name varchar(100)

set @name = 'count'

SELECT c1

FROM mytbl2

WHERE

c1 LIKE '% '+@name

or

c1 LIKE @name+' %'

or

c1 LIKE '% '+@name+'...

This is interesting one.

Its working fine at my end. Please check you created function in the same database.

Yes collate clause is required if user database collation is different than server collation.

Tempdb database follows the same collation as server collation. If some query operation uses tempdb then.....

SCPTXFR.EXE utility was available in SQL Server 2000. It is not available in 2005/2008. :hehe:

Best normalized form could be

TABLE 1 {This is product code master}

Product Codes | Item Number

TABLE 2 {This is product group master}

Product Group ID | Product Group

TABLE 3 ...

Execution plan is prepared based on indexes on table. It depends on the memory availability whether it will keep in memory or not.

If the plan is cached in memory execution...

If you disable primary key of unique index to which foreign key references; foreign key will get disabled. Not sure this will allow you to use TRUNCATE command.

Alternately-

You...

Its issue of parameter sniffing

You can explore with RECOMPILE option.

Yes second option is correct. it will keep on incrementing from the last IDENTITY value.

If server reboot also did not solve your problem means there is some issue with the processes running on the server or with in the database which are consuming more...

Its not issue of 32 or 64 bit.

You can not restore 2008 database on 2005 server.

You can try doing one thing-

Change database compatibility level to 2005, then...

Please read from SQL Server books online. Both are totally different.

:hehe:

Hi Tarvin,

Thanks for the info.

Will get back if i come across any doubts on this.

Thanks again !!

can you please elaborate on what exactly you are trying to do?