Is there a question in here...

Brandie glad you found what you are after, and thanks for the link; I added some of those methods to my snippets.

If you get a chance, can you explain why...

misiekbest (4/7/2011)

Question is simple. What does sqlsrv engine do with table after truncate command?

Someone told me, that it just rename that table (internally?), create new one and drop renamed...

Well,...

it depends on the work to be done; SQL would evaluate the command and make a decision/plan as to whether pieces of it can be processed in multiple cores; it...

SQL is a little different;

i believe you are looking for a BACKUP of one database(to create the dump, or *.bak file) and then when it's needed to restore over...

I've used the FOR XML trick to get the data...it returns string data(varchar(800) or max

this seems to do what you asked for:

/*DocIDSkills

1DocumentNumber,Sale Date

2First Name

3Last Name,DocumentNumber

8City

10Sale Date

*/

SELECT DocID,stuff(( ...

is there a question?

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...