just alter the definition of the computed column so it includes a cast or convert;

however, since a DATE datatype doesn't have the time portion, i think you could get...

they are easy to find, you just have to realize they are not real tables...they are Views...and they are also system views, so they are in a seperate folder in...

a synonym is an alias...it can be anything, but obviously it needs to make sence to...

yes, you can create a synonym that points to the linked table.

a synonym must point ot an object...procedure,function, table view, etc.

it cannot point to part of a name.

sp_tables_ex MyLinkedserver

DROP SYNONYM...

same datatype as the column it's on....there's rare exceptions where you make an index on a persisted calculated column that is the substring of a column, so then it's the...

exactly;

I've got one table, for example, that i update every two hours during biz hours , and...

I still disacgree with this, that's not what i got from TheSLGuru's comments:

As...

it's the tablename: the table is not "testen.strasse", it is "testen" or "dbo.testen"

the code is looking for a schema testen and a table strasse, which does not exist.

ALTER INDEX strasse...

i think you'll have to have some ugly cleanups to try to find possible matches:

SELECT * FROM

(

Select PK,

REPLACE(

REPLACE(

REPLACE(

REPLACE(

REPLACE(

...

ok, as Seth identified, there's plenty of ways to script tables...GUI, SMO, lots of script contributions.

one of my articles out there is how to script a table via TSQL[/url]. by...

the why is easy; NOT IN requires it a comparison to each value in the sub-select.

really that is the same as saying :

WHERE GR.NumDoc <> 1

AND GR.NumDoc...

when you use NOT IN, you have to prevent NULLs in your dataset:

change query1 to this, and you'll get the expected resultsi think.

select GR.NumDoc As Query1 from GR Where GR.NumDoc...

sweet ! i was hoping to fiddle with that old thing after you...