i just had a very similar question in a different thread...it was to scan all columns in a table where for all three search terms occurs

basically, i just did a...

Narayana Vyas Kondreddi wrote a really good proc over at http://vyaskn.tripod.com called sp_generate_inserts, which dumps the table's contents out to INSERT statements.

i use it all the time and have used...

i don't think replication is a single setting...you can have different replications going for each database...and i think you can have different replication types going on even a single database...you...

just a syntax error...you left out the FROM! if you are going to update one table from another, you have to include that table in the from statement:

UPDATE HouseKeeping

...

sorry if my post bothered you dev, we get a lot of new posters who ask for help on their homework, without putting any effort in themselves.

For your issue, I've...

interesting...

there must be a business reason why you are going thru each file, instead of just using the last backup...You basically need the history of changes(if any) between backups, right?

this...

your example shows 4 columns, none of which intuitively seem to be the PK...

Is the PK of each table ALWAYS an identity field, or is always the first column of...

pretty much every db reporting tool out there...from freebies written in Delphi , to crystal reports, etc, all have an RTF object that you just point to the field in...

typically, you might pass a comma delimited string to the procedure, and the proc then uses one of the many SPLIT functions in the Scripts section here on SSC to...

for varchar strings, the = comparison operator strips out ending whitespace.

that is different fromt eh LIKE operator...if you do LIKE 'phrase %', that would not find the item because of...

compatibility level just decides which syntax rules will be applied against any queries hitting the database...it does not change the behind-the-scenes way the database is stored/saved.

that's why you can switch...

all minor syntax stuff; i found three things:

the higher case statement for a.staff said case a.staff andf then had WHEN a.staff...; should be one syntax or the other...

second...

it'd be something like this:

--kick everyone off no matter what!

ALTER DATABASE [YOURDATABASENAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

--make sure it's really just for me

ALTER DATABASE [YOURDATABASENAME] SET SINGLE_USER

GO

--do...

your question reads like it came straight from a problem in a textbook...telling us what the required results are...are we doing your homework?

what have you tried so far?

I can tell...

i'd just set the database to single user mode, do my work, and then change it back to multi user;

no fiddling with groups, and you'll know you are the only...