My test indicates recompile parent proc will NOT recompile the child proc even in the same database.

The following tests may illustrate my point, the first one should fail while the second should be ok.

SET LANGUAGE us_english

declare @test-2 table (c1 datetime)

insert @test-2 (c1) values('13-1-2004')

select * from @test-2

go

SET...

declare @Area, @Age, @Sex, @Title

declare @i int

declare group_cursor cursor for select distinct Area, Age, Sex, Title from table

open group_cursor

Fetch next from group_cursor into @Area, @Age, @Sex, @Title

while @@fetch_status = 0

begin

 set...

It would not be too hard to write script for generating triggers base on table schema info.

You do not have to change regional settings to solve the problem.

The accepted dateformat depends on user default language. Simply change user default language to 'British' (dmy) should do.

sp_helplanguage lists...

Yes, you can remote access sql server via EM use windows trusted connection.

For detail setup info, check book online 'Managing Security'.

script the ftp upload and call the script from DTS.

declare @db SYSNAME

set @db =

(select TOP 1 Name from dbo.sysdatabases

where name like 'CCM%'

order by crdate DESC )

exec ('USE '+@db+';select * from [dbo].[device]')

Sample case from MS.

http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp

As table name is static, so as column name, you can use case statement to access old, new value for a column depends on column position (column id).

For example, in...

It sounds like you use windows trusted connection to SQL Server. If that is the case, you do nothing.

SELECT tbParents.*, count(tbPcodes.pcMyZips) FROM tbParents, tbPcodes

WHERE tbParents.pZipCode = tbPcodes.pcMyZips  AND tbPcodes.bsID > MMColParam  AND tbPcodes.bsID < MMColParam2

group by tbParents.*

ORDER BY pUserID DESC

You may have to expand tbParents.* to each individual...

Convert and string concatenation can help you.

SELECT distinct tbParents.* FROM tbParents, tbPcodes

WHERE tbParents.pZipCode = tbPcodes.pcMyZips  AND tbPcodes.bsID > MMColParam  AND tbPcodes.bsID < MMColParam2

ORDER BY pUserID DESC

tbPcodes.* has to go because they are different against the...

I do see application like that. The select statements are not dynamic. They are static for the particular copy which may differ from another sold copy.

As you mentioned, the core...