souldn't the data be ('04/04/2011...

or the pattern be M/D/YYYY...

like this: just tested it:

select * from

(

select definition,myf.* from sys.sql_modules

cross apply dbo.DelimitedSplit8K(definition,' ') myf

where definition like '%[A-Z]@_%'

) myAlias

where Item like '%[A-Z]@_%'

well as a start, you could limit it to only procs/functions/triggers that have strings that might be an email;

this certainly found the two objects i have that have a hardcoded...

for addresses, there are a number of services that will standardize your address info for a fee;

if your cheap or just like a challenge (like me) what I've done is...

the SQL statement is wrong.

if you are going to use double dots, which tells the linked server to get the default object, it is like this:

it has to be Select...

think about it: how many unique employees receive two salaries? i doubt any in this table.

maybe you need to join to a different table, say the payroll table, so you...

I think David nailed it, unless an EmpId appears more...

Sounds pretty wierd; can you script the linked server command out so we can see it? that woudl be most helpful in the diagnosis; you are of course sure you...

When SQL server runs out of disk space, it stops and tells you it ran out of disk space...it doesn't automatically disable CDC, trace, jobs or any other service from...

can you change things like the connection string of the web application?

if you could get the web application to change the Application Name attribute on a per-page basis, you'd have...

you had previously said you had this setting "Be made using login's current security context" set."

The typical issues for linked servers tend to be related to which security context you...

Steve how good are you with programming?

I use this function as part of a larger ETL program i wrote; once I have a datatable, i can pass it to this...

if not too much time has passed, the default trace keeps track of DDL(CREATE/ALTER/DROP object changes)

the easiest way is with a report that exists in SSMS:

any chance of changing the schema? at least adding a column to be removed after the data transfer?

whenever I've done a data migration like this, I've always added a column...

what you want to do is wrap this up into a stored procedure, and use parameters;

here's an example of the code, and then how to call it: note the procedure...