yes, it'll be a bit slow, because you'll have to convert the TEXT field to a varchar(8000);

here's an examplei put together, note how i made a searchterm in a subquery,...

provide to a user ?!?! every varchar/char/nvarchar/nchar column in the database?

unless this is for a developer to fix some code, as already suggested, you really need to use full...

yes that's correct...but it depends on your data as to whether it will be blank or find a value...i assumeed one space between each ite,.

if there are TWO spaces between...

originally you had posted that you had a table dbo.NEWDUNDD_SEACX with a column f1

because you had no CREATE TABLE or INSERT INTO scripts, i created my own table wth...

in Win7 and Vista, security is a little tighter...you don't get added automatically to the instance you are installing. One of the steps during the install is to add yourself...

is it really string manipulation?

if it's a float/decimal, you could subtract the FLOOR() of the value from itself to get the remainder:

declare @val float

set @val = 10.8061111111111

SELECT @val - floor(@val)--returns...

noone answered your post for a long time because you didn't provide the esentials...the CREATE TABLE definitions of your tables.

here is an example, but it's based on wild guesses as...

wow, formatting really makes it readable:

i think this is what you are after.

because they are all inner joins, it doesn't matter whether there are a zillion nested parenthesis or not.

the...

try this: this(in theory) should show you your username/context when on the remote /linked server, assuming the linked server is a SQL server:

select * from openquery

(YourLinkedServer,'select

user_name() ...

well the error is telling you you have to explicitly list the column names:

TRUNCATE TABLE [tablename]

SET IDENTITY_INSERT [tablename] ON

INSERT INTO [tablename](COLUMN1,COLUMN2,COLUMN3....)SELECT [ID],

[VENDOR_ID]

,[TAX_ID]

,[PYMT_NO]

,[NAME]

,[ADDR]

....

well here's an example from visual studio:

the dataset is used to strongly type the column data types, and a query is used to fill the dataset.

the easiest way to add...

david my knee jerk reaction is the same as yours; i'd be checking whether there is there a primary key or not on the base table.

i've seen query builders...

backup the database, then restore the backup on the remote server. that is the...

throwing in my two cents here; if you really want to capture a full trace of everything, you can simply turn on C2 auditing; C2 auditing is actually just another...

i once worked in a shop where the original sa login was renamed and a new cripped sa login was created as a honey trap for developers who shouldn't be...