I think the best you are going to do with a 20,000 character string is to save to a .SQL file, and then use OSQL to execute it.

you can't use...

Try:

UPDATE [DB].[dbo].[MWST]

SET [DB].[dbo].[MWST].MWStKlasse = Stschl.schluessel

 , [DB].[dbo].[MWST].MWSTSatz = Stschl.prozentsatz

 , [DB].[dbo].[MWST].Bezeichnung = Stschl.bezeichnung

 , [DB].[dbo].[MWST].SteuerkontoGenerell = Stschl.kontonummer

FROM [DB].[dbo].[MWST]

 INNER JOIN Stschl ON [DB].[dbo].[MWST].MWStKlasse = Stschl.schluessel

  AND [DB].[dbo].[MWST].OrgUnit_Nr = Stschl.orgunit_nr

Andy

You may find a performance increase by changing the 1st INSERT INTO query to:

SELECT Server, MSGID, RDate FROM dbo.[table_received] WHERE [RDATE] >= @LastDate And [RDATE] < @NewDate GROUP BY Server,...

What you have left out is how you run these processes, maintenance plans, or T-SQL?

The reason that your Log is large is because of the REINDEX, when coupled with BACKUP...

I am a fan of Drive Snapshot:

http://www.drivesnapshot.de/en/

Simple and inexpensive ($115 per server), runs on Windows NT+, no boot to DOS required. It does everyting I need to capture the...

Add SELECT or PRINT output to your stored procedures, use RETURN (1) and RETURN (0) so the SQL Server Agent Job can receive proper return values.

Have you tried using the...

Restore from a backup, if you have log backups you could restore to just before the "oops".

Andy

Your SP was compiled with the old statistics, recompile it to make sure. I saw this suggestion for regular maintenance:

EXEC sp_updatestats

EXEC sp_refreshview

EXEC sp_msForEachTable 'EXEC sp_recompile ''?''' 

Andy

Add the "user provided credentials" access to the trigger by adding this column to each table to be audited, populate this column from your app that should already have access...

I would perform a full backup before I started this to insure a restore method.

I suggest setting the database to Simple mode, setting the log to auto grow in a...

--Account table

INSERT INTO Account (AcctID, Name, Address)

SELECT 100, 'John Doe', '123 main'

--Billing Table

INSERT INTO Billing (AcctID, Customer, Amount)

SELECT 100, 'John Doe', 55.00

Andy

USE master

IF DB_ID('NEWTdatabase') > 0

 DROP DATABASE NEWTdatabase

IF EXISTS (SELECT loginname FROM syslogins

  WHERE loginname = 'xxxxxxxx')

 EXEC sp_droplogin 'xxxxxxxx'

GO

IF NOT EXISTS (SELECT loginname FROM syslogins

  WHERE loginname = 'xxxxxxxx')

 EXEC...

LEN will not work as expected in this situation, if you have trailing spaces in the column that is inspected, LEN will strip these out before calculating the length, you...

You can find the scripts for all of these steps already posted, they will need to be combined for your task requirements. Here is the Restore portion:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=764

Search for the...

Check these examples out:

http://support.microsoft.com/kb/186133/en-us

Andy