Here to be exact :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=195400

That could be correct :

(LinkedServer).(Db).(Owner).(Table).Column = 4 prefixes .

Cool. Could you please provide the required information next time so that we don't have to guess again? That way we can provide a tested solution in far...

French/Enlish/ (vb + C++ + sql server).

Easy to get mixed up between percent and pourcent and % at this stage .

The poster(tress!?) talked...

Then there definitly is an object in master named Test1, what query did you run to try to find it?

Check this out :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=193680#bm193725

Why do you want to run the job so often?

HTH. But I'll be out for 3 days after tomorrow. You might not get fast answers on my part .

thgamble1, did you intent to index the computed column so that you have a quicker range search?

You could create index on the computed column and the state so that the...

Il'l trie two bee moer caerfule .

Also speaking about typos... : "automtically "??????

You try writing things in 3 different languages without making a translation mistake once in a while... The strange thing is that it checked out without error in QA (errors...

"Please tell me you didn't just post something that said the same thing!"

Might I remind you that you are the one repeating after me... not the other way around.

If there's no object in master, then maybe it is create twice in the same transaction... are you sure you got everything statement in that batch?

Then this is your friend :

Select top 25 percent Telephone from dbo.YourTable order by NewId()

Can't be simpler than that.

Anything wrong with that?

No he wants Select into. Insert would do fine but he doesn't want to have to create the table first.