That was simple.

Thank You

Derek

You could use linked servers and then make a script with the fully qualified name

Here is the execution plan for insert

StmtText

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

INSERT INTO [TrackRawWeb].[dbo].[EventTransactions]

([DomainId]

...

Run DUMP TRANSACTION [db name] WITH NO_LOG and shrink it. It will still grow and large as the biggest transaction that uses the log so be careful of transaction that...

I archived out 500 gb worth of notes from sql to text files. I used built in zip that comes with Windows 2003 and it compressed a 11 gb folder...

Im not quite clear on what your looking for but here is how I navigate dates for KPI's and stuff

Case When [Date].[Date Time].CurrentMember.Level.Ordinal = 3 Then //month level

{([Measures].[Order Count])- ([Date].[Date...

The order is the identity. Thanks.