suedunham2 (11/24/2014)

---

Thank you for that prompt reply - it looks like there is no way of reducing the size of the first Monday tran log dump unless I change the...

Odd requirement, but whatever...

Then this will do that

CREATE TRIGGER [Test_TRG] ON CUSTOMERS

FOR UPDATE, DELETE

AS

INSERT INTO users values ('0789','Sheker','WT_WRO')

Any time any row on the customers table is updated or deleted, the...

Please don't post multiple threads for the same question.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1638528-391-1.aspx

There's no such function as DELETE()

The UPDATE() function returns true if the column was included in the update. Since DELETE affects the entire row, there would be no point in...

The first log backup on Monday is so large because it contains all the log records since Friday afternoon, including all those index rebuilds.

p.s. Stop shrinking your database!!! If you're...

Sure, here's all the catalog views, between them all you should be able to get what data you need.

http://msdn.microsoft.com/en-us/library/ms174365.aspx

INSERT INTO <data warehouse table> (<column list>)

SELECT <relevant columns transformed as necessary>

FROM <OLTP tables>

WHERE <whatever conditions are applicable>

Repeat for all DWH tables

Honestly, you may as well have just asked "Please...

AlexSQLForums (11/21/2014)

---

Replicated Transaction Information:

Oldest distributed LSN : (0:0:0)

Oldest non-distributed LSN...

No.

Firstly the DB is in simple recovery, second the problem has nothing whatsoever to do with...

They're using the same method of storing times as MSDB does. It's hell to work with unless all you want to do is display.

It's likely a case that they don't...

Because they don't understand the importance of good data types.

Because they've been taking design lessons from MSDB.

Because they don't realise that SQL 2008 has a TIME data type and don't...

Really?

Look at the massive amounts of detail that you've given us. What kind of example do you really think I can give you based on a one line question with...

You're probably better off asking this on an Oracle forum. This site is for Microsoft SQL Server.

No.

Private ignores cookies set by regular browsing, so if they've used client-side cookies to record that you've voted...

Take it step by step, first write the SQL statements to do each transform, once you've got it working then wrap it in a stored proc. Easier to debug as...