Instead of using maintenance plan, create a Backup device and also a job

for backup. This way you always having one physical file whose logical name

is your backup device name.

This is how you can resolve your problem

declare @body1 varchar(100)

set @body1 = 'Welcome..'

select top 1 @body1=@body1 + char(10) + au_lname  from pubs..authors

select @body1

select top 1 @body1=@body1 + char(10) + au_fname ...

It will be better if you provide more detailed info. here

you  are talking of Sql server Error Log and size 0  is the problem with current log file or Archived log...

In stored Proc why you need to select temp. variable and then allias that.

Are this variable @PB, @Term ..  input parameters to SP ?

If so then also it is hard to find any good reason for...

Here you need to take note of one additional Information.

If table is populated with Rows then

Add Constraint is not going to change the null data

values from the previously populated rows.

can you please provide more specific information on this problem.            [Error number /complete error message]

If its Sql 2000  and dynamic memeory settings are in place then there is no question...

If you are using sql server 2000 standard edition then

memory max is 2 GB. only 2 GB of your 8 GB will be of use for sql server.

Dynamic memory...

Hi RJR'us

This is not SQl question , but question out of curiosity

What are the bases for title here Grashooper,Veteran, SSC ertifiable etc.

Thanks,

EXEC sp_attach_db @dbname= 'yourdatabasename',

@filename1 = N'MSSQL\Data\yourdatabasename_data.mdf'

In Query Analyzer, enter  code to reveal query causing the blocking lock:

DBCC INPUTBUFFER (<spid&gt

other option is to use the Profiler, begin a trace, duplicate the...

There is a Risk of loosing log data associated with

Detach--Delete Log -- Attach Datafile approach.

Think, once you Attach mdf and have fresh ldf

before next full db backup if...

Hi Parag,

I have some suggestions to your questions

a) What is inside this Production_Log file

b)...

Helan,

Have you received any response from Asha ?

This problem is due to parallel query execution, blocking resources.

I have gone through this and recommend you to find the query.

In my case it was one Stored Proc. where I have...

I don't have exact solution to your problem at this point of time,

will probably come out solution but for while can suggest you to refer

http://www.replicationanswers.com/Merge.asp 

or articles by Alexender chigrik in database...