Thanks for the responces. I was able to resolve the issue.

Why would you want to modify the create date of an object unless you were trying to hide something???

Let me try and answer some of the questions.

The Id IS the primary key and yes the ineserst are date based. So the ID as PK and a clustered on...

Hi there,

To place your database in emergency mode, use the following command:

SP_CONFIGURE 'allow updates', 1

RECONFIGURE WITH OVERRIDE

GO

UPDATE master..sysdatabases set status = -32768 WHERE name = 'pubs'

GO

SP_CONFIGURE 'allow updates', 0

RECONFIGURE...

I am the Senior DBA (nice title) at one of the major banks in Australia and they do pay for traing for us. There is a budget allocated yearly per...

I would also check the I/O of the second more powerful server and make sure that the hardware is all ok. You could have faulty hardware resulting in the bad...

Henry,

I would ask the DBA to do this for you. It seems that you might not be 100% sure of what you are dealing with.

Thanks

AB

Once you have shrunk the database you will need to shink the file to free up the space

dbcc shrinkfile (<t-log>, 500) -- shinks the t-log to 500Meg in sise

You could try putting your database into emergency mode this will then allow you to bcp your data out and you can then re create the database and bcp the...

You sure this is not some school assignemt your dont really feel like spending the time doing yourself ?

AWE is not enabled for 4GB or less.....you just use the /3GB switch in the boot.ini

The purpose is to test why an exe would not fire uop in CmdExec. I have an exe that fires up and prompts you for a user name and password....

Thanks both for your responces.

Try using only one #

CREATE TABLE #temptable (...)

  INSERT #temptable  

  VALUES(...)

  SET @Err = @@ERROR  

IF @Err <> 0   

  BEGIN  

    ...

    ROLLBACK

    RETURN

  END

COMMIT

sushila THANK YOU