Thanks for Inspiring me

I did

Backup log Hr_database with Truncate_only

But when I see the size still remain same???

Thanks but I am a new DBA, how don't know what you mean by checkpoint. I want to truncate the log file I mean the LDF file....how to write the...

No We don't use any replication.

This is the Error I got if from ERRORLOG

2005-09-08 15:00:00.42 spid62    Starting up database 'Prod_SRG'.

2005-09-08 15:00:00.46 spid62    Starting up database 'Micro'.

2005-09-08 15:00:00.49 spid62    Starting up...

I get BMDPROD

but when I ping it says unknown host?

I know how to add linked server but how to name the linked server...

I have linked server with IP address 1.2.3.4 every week they change the IP address I want...

Thanks for the feedback

1. One quick question how should I drop the servername if there in NULL value.

Can I do sp_dropserver 'NULL'

sp_addserver 'Local' (...

I get NULL

Thanks, Can I still able to open EM or QA after renaming and reboting the server and then change the name of the server

Nita

Thanks,

when I changed to old password back it started up

So I will try to Uncheck and let see if works....but what if some one forget the old pasword how...

Thanks, In my production its showing as 1, so 1 is default you mean.

Thanks in advance

Nita

Thanks!

I forgot to mention that I have 100 objects, how to do all this object at Once

Nita

Thanks

Nita

He has same execute permission to the other database as well!

I tried pubs and northwind and it works fine ;(

Why the above cannot?

Cross checking????

The db_one and db_two are on same server

Yes Sir,

create PROCEDURE dbo.spjobbegin AS

BEGIN

 DECLARE @jobId VARCHAR(36),

 DECLARE @jobTotal INT

 SET @Jobtotal = 0

 SELECT @JobTotal = count(*) FROM db_one.dbo.job_tbl

  WHERE jobID = @jobID

 UPDATE db_one.dbo.job_tbl SET jobTotal=@jobTotal

  WHERE jobID = @jobID

 IF @jobTotal >...