can you create a couple of views that selects from each of the linked tables, and then grant the AD group select on the view?

that's how I've done it in...

each destination table needs a separate insert command... so you'll use a WHERE statement to select/filter what goes to each server, instead of a case statement

case statement in SQL is...

is that characters 10 thru 20 of the whole file, or 10 thru 20 for each row/line in the file? so if the file has 120 lines, you need a...

what specific error do you get returned?

well, here's a simple procedure that will return a table with the definitions of just the view/proc/function objects that begin with "KLL" in the correct dependancy order.

you could then...

i think you want something more like this: the field cannot be trimmed to equal whitespace, and must have at least a letter or number in it

ALTER TABLE [dbo].[IntNotes] WITH...

Synonyms might fit the task at hand, but a synonym points to an object, not a part of a name.

for example, say your proc is looking for a specific 3...

adding traces is the way to go.

the default trace captures DDL statements, but rolls nover fairly quickly.

you can add your own trace to capture all DML statements, or filter them...

Phil Brammer (11/23/2010)

---

If there is no backup strategy in place, and the database is in FULL recovery mode, the transaction log will likely be unreadable anyhow, as it will likely...

ok, i compared my snippets to your code, and the only thing i have that is different is that my code always gets the value of the context_info from a...

a whole lot of knee jerk reactions about "but it's not supported!", but since it works on SQL 2008 ( and someone reported it works all the way thru...

S_Kumar_S (11/22/2010)

---

Thanks For reply Lowell. I know we can use sp_ in any database context, but I had to use that function in a select statement(select clause), so this probably...

This situation can be tough. replication and log shipping assume some degree of access to theSQL Server itself. It sounds like you do not have access to that.

Is this shared...

in general, it depends how many rows at a time you are deleting.

SQL server will automatically create row-level locks for single row deletions, so there would not be contention with...

you can put an expression, just like you were planning, in the query, and it will appear as results int he query.

here's your specific example: note i simply added the...