Is there a way to know which application on prod server is trying to connect to VM every minute..??

How to proceed?

Regards,

Sushant

There are no default jobs created when you install sql server.

You need to create them manually.

Regards,

Sushant

@ nakul

What do you mean by all users or some?

I just see the sql server logs and I find this error happeneing every minute

I also checked the aliases on both...

@ sqlbuddy

I already deleted that login. then also no difference

Regards,

Sushant

a user owning a schema cant be dropped until

you delete all the tables,objects linked with the schema.

Using the GUI in "Object Explorer" (MS SQL Management Studio) Expand the [databasename]...

@ klineandking

go to operator --> make a new operator

write the email name there and name the operator.

Then, when you go to job --> properties --> notifications, you can see...

go to job --> properties -->notifications--> choose email and the option ' when the job succeeds'

Regards,

Sushant

Hi,

I ran

dbcc errorlog.

Then the job ran successfully.

Regards,

Sushant

@ george

Thanks a lot.

Regards,

Sushant

@ derrick

That is just log shipping server for maintaning log shipped databases.

No user is on that server.

@ george

skuupgrade would do or i have to download 2005 sp3 and install

Regards,

Sushant

@ pradeep

Thanks a lot

Regards,

Sushant

@ derrick

Can you please elaborate, how to narrow down the error.. the print statements script ? and at where...

@ ashish

The error i wrote at starting the post.

It runs under...

why doesn't that error comes, when i run manually??

Regards,

Sushant

The job code is :--

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

DECLARE @subject VARCHAR(250), @message VARCHAR(4000), @query VARCHAR(4000),

@recipients VARCHAR(250)

DECLARE @ITEMNMBR VARCHAR(31),@ITEMDESC CHAR(101), @PRCLEVEL VARCHAR(25),@UOFM VARCHAR(10),

@UOMPRICE NUMERIC(19,5), @QTYBSUOM NUMERIC(19,5), @CALPRICE NUMERIC(19,5),

@ACTUALPRICE NUMERIC(19,5)

-- SELECT...

yes, i restored the database from 1 server to another , i think its case of orphaned users.

Ya that script helped... 🙂

One more question: There are less users in my...