the merge command will do what you need to do

when not matched by target = insert

when not matched by source = delete

when matched and target.col1 <> source.col1 or target.col2 <>...

Merrie Melodies

roadrunner (beep beep)

No problem, happy to help as always.

Only SQL authentication accounts become "orphaned" this is due to the SID's being different on Server1 to Server2. The exception to this is if the SQL accounts have been...

It's a seperate check box on the SQL Server installation, so you will need the SQL Server media to install BIDS. Its a completly seperate program from SSMS.

The installation...

When you install SQL you have the option to install what we call BIDS (business intelligence development studio), if you dont have it installed, just simply run through the media...

You would need to build in a dynamic date call something like the below

declare @datestamp nvarchar(30), @cmd nvarchar(max)

set @datestamp = REPLACE(REPLACE(REPLACE(CONVERT(NVARCHAR,CURRENT_TIMESTAMP,120),'-',''),':',''),' ','')

set @cmd = 'BACKUP LOG db1 TO DISK =...

Something like this

DECLARE @toemail varchar(150), @jobname nvarchar(150), @short_desc nvarchar(150)

DECLARE email_cursor CURSOR FOR SELECT email, RTRIM(Job_name), RTRIM(short_desc) FROM vw_expiring_jobs

OPEN email_cursor

FETCH NEXT FROM email_cursor

INTO @toemail, @jobname, @short_desc

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT @toemail

DECLARE @body...

What is the business requirements on changing the server level collation? Is there a specific problem you are attempting to fix?

Rebuilding the master DB will result in all the...

They are stored on the machine used to develop the solution. If you have something like TFS or a source control environment, you could see if the person uploaded...

Yes your log backups are working, you can do a query on the MSDB tables to check that they are working as well.

What you are doing is appending to an...

what do you get if you remove no_output?

asylum

What error messages do you get?