Are you saying That the job does not show on the job list on EM ?

Yuri,

When you restore a db specially from another server. The SID of the logins in the master db are probaly not going to match those of the db and therefore you will...

EM uses that procedure to refresh the Replication Monitor Folders

If you are the DBA you should be giving the access to others

Daniel,

If your app is coded using normaly employed optimistic concurrency you still are going to have the problem of two users could try to change the same data at the...

Are you looking at the monitor or at the jobs?

If it is at the jobs and they are set up to run continuously then that's expected

 http://download.microsoft.com/download/SQLSVR2000/sysmap/2000/WIN98MeXP/EN-US/systbl.chm

hth

Do you have the replication monitor Enabled?

...

Do While Number > 0

Number = 12

Dim cmdEnter As New SqlCommand("PaymentSchedule", GlobalConnection)

cmdEnter.CommandType = CommandType.StoredProcedure

cmdEnter.Parameters.Add("@UserID", 208466)

cmdEnter.Parameters.Add("@SPaymentAmount", Double.Parse(txtSpaymentAmount.Text))

cmdEnter.Parameters.Add("@SPaymentDate", txtPaymentDate.Text)

Enter = cmdEnter.ExecuteNonQuery()

Loop

...

Use indentation so that you can see better:

Number = 12

Do While Number...

joe joe, is an inner join. With the data you posted

here is what I get:

 select    a.StreetCode

 , a.HouseNumber

 , a.Equal_Unequal_HouseNumbers

 , a.AreaCode1

 , b.Areacode2

from

 TableA a

 join

 TableB b

 on a.StreetCode = b.StreetCode

    and a.HouseNumber >= b.HouseNumber_From...

>>How do we see the records? I don't want to use NOLOCK. <<

[edit:] I thought that nolock  will let you do that but I was mistaken. It does not

Why do...

There is another way to solve this!

Declare @dbname1 varchar(20), @dbname2 varchar(20), @spname varchar(128), @retval int

select @dbname1 = 'FirstDBNAME', @dbname2 ='SECONDDBNAME'

-- call proc on db1

set @spname = @dbname1 +'.dbo.procedurename'

exec @retval...

Dave,

The Global setting your DBA is talking about is maybe

sp_configure 'user options' ,...

but that affects everything new and it does simplify the life of your DBA

Remi,

You are correct in that the plan may be a little different but then again all those are very specific for data amount, skew in it and index presence.

As of ...

Michael,

The Expression:

 Select ... From Table1,Table2

without a where clause is a cross join!

Therefore it should be exactly the same as the one posted by Carl with less typing...