I think it is a homework question. You may want to set up  a separte table for languages with canditate id or set up a check constraint for langauge column and...

Try this

Declare @Errcounter INT

Blah blah blah

IF @@error <> 0 GOTO ErrorHandler

ErrorHandler:

If @@error = 1205 AND @ErrCounter = 4

BEGIN

WAITFOR DELAY '00:00:00.30'

 SET @ErrCounter = @ErrCounter + 1

GOTO SelectInit

END

Yes, there is a way to create a schema and save that...and you can basically do for all database objects..

Right click on DB from enterprise manager. click on "all tasks"...

You are asking very large question in a very small place. I can tell you this from experience that that there is no text book answer to this question. Yes,...

That is nuts...so what do we do when we have 135GB database. What are some of the strategies we can use to reindex the large tables??Any suggestions??/

Good idea...I would have given that a shot..But I am back from my assignment. Will pass it on and see how it works..

The error is saying that production DB log is getting full. I am not sure about the tempDB part..Can u please elaborate..but I will read on it too..Sometime explaining work better.

thanks

I had to struggle with the same issue about two years back. And the best solution I found was to add dbo prefix. I made this part of database documentation.

If...

dbo will show if the owner of the database creates a sp or any object. If you want to forcefully show the dbo then Create objects like this.

Create table dbo.tablename

create...

Are you running anything else with your maintenance plans. Like Backups or integrity checks. Remember Transaction log, records any changes to the Database.

Try also backing up the transaction log...

 SQL COMPARE BUNDLE  from REDGATE Software for comparing.

For inserting you would probably have to write your own scripts.

Ideally very minimal. But Hey, this world is not ideal. Thanks to Mr. Bill Gates.

The fact remains whenever we cant find a solution to a problem we fall back on...

I also ran it on my machine and I have  identical info..only with an exception of service pack.

Did you load both test and production with same CD?

Also did you upgraded...

try select @@version and see what it says...

dbo in the database is not a user. Its a Alias. Whoever is the database owner his login will deafult to dbo until and unless you change the Alias by...