Mmm, terminology is getting in my way for this one. My definition for parity (rightly or wrongly) applies at the byte level (Parity Bit).

For RAID 5, I...

you need to group by the stuff in the case statement...

select YEAR, '2', activity_id, CASE [function]

WHEN 'OTH_LAB' THEN 'OLB'

WHEN 'ENG' THEN 'ENG'

WHEN 'MFG' THEN 'MFG'

WHEN 'IWA' THEN 'NLB'

WHEN 'CWA' THEN...

All I can think of that there is a permission problem. What credentials are being used when connecting to the linked server from each of the 3 servers ?

If you mean restore a backup from another environment (e.g. PROD), then yes you will need to update the synonym.

Database compatability does not have any affect on the way SQL Server stores data. It only influences how the query optimiser handle the T-SQL queries. Hence, you can...

You could create a synonym that points to the table and use that synonym in your stored proc. The only change required between dev and prod is the synonym...

The query

SELECT

regions_id,

region_description

FROM mydatabase.dbo.regions

does not use a linked server. The queries that work must actually be getting the data from a...

As the error message says, use "'MYSERVER\MYINSTANCE'", not "'MYSERVER.domain.com\MYINSTANCE'" for each of the instances involved with replication.

Generally, it is easiest to get replication working if you have very server registered...

Using Execute SQL tasks to run sp_start_job will not actually achieve that. sp_start_job will start a job and then finish - it does NOT wait for the job to...

Yeah - I think we all have days like that. We just hope that they don't happen too often

What have you been trying ?

EXCEPT is conceptually quite simple - give me a set of ... everything in one set except for those members in a second...

As Gift said, if they can see it, they can delete it. That is true.

By default, the Browser role has a permission called "Manage individual subscriptions" enabled. This is...

Not that this will necessarilly help you with your particular problem but TRUNCATE TABLE is logged but not at the same level of detail as DELETE statements.

What is logged is...

Starting a job from a trigger may get a little tricky. You need to check whether it is already running. You need to grant permission to start the...

I have just finished a data warehouse project where the design was completed and signed off my the users responsible for the business areas involved. The key point was...