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

still requires a LEFT OUTER JOIN to get the specific data: here's just one way to do it:

SELECT se.* FROM dbo.TB__Employees se

LEFT OUTER JOIN (

SELECT

sec.EmployeeID

FROM dbo.TB__EmpCourse...

i think this is what you want...a LEFT OUTER JOIN will help identify the ID's not int he realtionship table:

SELECT se.* FROM dbo.TB__Employees se

LEFT OUTER JOIN dbo.TB__EmpCourse sec

ON se.EmployeeID...

here's an example using a cvustom function CHARINDEX2, which finds the nth occurrance of a string...in your case a space...

/*

Example:

SELECT dbo.CHARINDEX2('a', 'abbabba', 3)

returns the location of the third occurrence of...

here's an example that chops up the peices for you to concatenate:

/*

--results

Years Months Days Hours Minutes ...

i think the UPDATE FROM syntax would help in this case; i took a wild guess and hoped there was a relationship between a column named entityID?!?! and your two...

if you need the total, you;ll need to declare a variable, and add them together:

declare @TotalRows int

SET @TotalRows = 0

Select top 10 * from Employee

SET @TotalRows = @TotalRows...

For Openquery to filter the results on the Linked server side, I believe the where statement needs to be inside the openquery to avoid the performance issue where the table...