Ok.. how do you get SQL to execute the statment I have built... the statement it is printing is correct, and runs if you copy and paste.. but this code...

Hmm that is even simplier than I thought it might be.... thanks.

Yep, that did the trick... she is now 6mb! Wahoo. Thanks for the help.

prettsons (7/25/2012)

---

First take full backup (with log), then switch the recovery model to simple, then attempt to shrinkfile the log. then switch back to full recovery model.

Take a look at...

The problem is that the following is not shrinking the log file... it does complete without errors.

USE [model]

GO

DBCC SHRINKFILE (N'modellog' , 0, TRUNCATEONLY)

GO

It returns the following:

32560065664560065664

here is the result

Name ----- log_reuse_wait_desc

=======================

model----- NOTHING

Interesting.. just tried to create a table on R2D2's...

I have data being loaded from two different companies... so the first time I use INSERT and the second I use INSERT INTO.... the first gives the error I posted...

Different server than where the stored Proc is running.

Ok.. I thought maybe I was missing something simple, sorry.

here is the error message..

Msg 117, Level 15, State 1, Line 3

The object name 'R2D2.this.that.dbo.ztb_test' contains more than the maximum number...

dwilliscp (7/16/2012)

---

Given that someone, before me, used the wrong table name... this.that, could someone please tell me why the syntax is not working for both INSERT and INSERT INTO?

insert [this.that].dbo.table_name

insert...

:w00t: :: David slaps his head:: Thanks for your help.

Thanks folks.. I did do a search, but I was looking at SQL commands... for some reason never thought to search the way you suggested, thanks Lynn. 🙂

I headed out for vacation last week, only to end up with no power... after the big storm moved through the Smokey Mountains Friday... so I am back early 🙁

.... No loops! No CURSORs! No RBAR! Hoo-uh! ...

Great!

Thanks rhythmk and dwain.c for your help...

The IF statement would have 5 nested IF's... and then the else.. I know it is...