Showing posts with label urgent. Show all posts
Showing posts with label urgent. Show all posts

Friday, February 24, 2012

Database Mail Configuration? Very Urgent

Hi!!!!

I'm a hobbyist Developer....

I'm would like to know how to send mails from Database Mail option in SQL Server 2005. I wil be glad if i can get a step-by-step procedure or any KB....

Moreover what i did was,

i tried to setup the database and i got the error message when i tried to send DB mails....

"An attempt was made to send an email when no email session has been established"

wil be thankful if i get help ASAP.

Thanks,

Jeffrey

Hi all....Why am i not getting any help? Seems that not even a single expert is having a look at this question.....

Please help me ASAP.......

TIA

Jeffrey

|||

I'm no expert; but, did you set up your email configuration?

I've set up my account / configuration; but, I'm getting the following error:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-06-22T02:27:43). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: authentication required - for help go to http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-11.html). )

SBCGlobal (my ISP) says they don't support SQL Server 2005 DB Mail?

Anyone else have this problem?

|||

Hi Steve,

I'm getting the same message as you are - sure would like to know what it means!!

Dave

|||

I got hung up on this one too, and what I found was when I set up the mail account to send mail in SQL Server I had used the wrong name for the Account Name and Display Name. Many e-mail accounts have an "Alias" name to them and they may not be what the actual e-mail address looks like. So if your mail account address looks like SVCMail@.myISP.com, it may have an alias name of SVCSQLMail. It is critical that the alias name is right otherwise it won't work.

You can also try right clicking Database Mail/Send Test Message to see if the mail works at all. I have found that the mail does work quite often by using this method but then a job will fail to send mail if you try to set an alert for a job. That is pretty much how I discovered that if the Description and Alias name is wrong, it will fail to send mail under a job.

As far as the ISP not supporting SQL 2005 mail, it is probably not an issue because SQL 2005 just uses SMTP mail. There is also SQL Mail which uses the Outlook Client but that should not be an issue either as long as it is configured correctly.

Database Mail Configuration? Very Urgent

Hi!!!!

I'm a hobbyist Developer....

I'm would like to know how to send mails from Database Mail option in SQL Server 2005. I wil be glad if i can get a step-by-step procedure or any KB....

Moreover what i did was,

i tried to setup the database and i got the error message when i tried to send DB mails....

"An attempt was made to send an email when no email session has been established"

wil be thankful if i get help ASAP.

Thanks,

Jeffrey

Hi all....Why am i not getting any help? Seems that not even a single expert is having a look at this question.....

Please help me ASAP.......

TIA

Jeffrey

|||

I'm no expert; but, did you set up your email configuration?

I've set up my account / configuration; but, I'm getting the following error:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-06-22T02:27:43). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: authentication required - for help go to http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-11.html). )

SBCGlobal (my ISP) says they don't support SQL Server 2005 DB Mail?

Anyone else have this problem?

|||

Hi Steve,

I'm getting the same message as you are - sure would like to know what it means!!

Dave

|||

I got hung up on this one too, and what I found was when I set up the mail account to send mail in SQL Server I had used the wrong name for the Account Name and Display Name. Many e-mail accounts have an "Alias" name to them and they may not be what the actual e-mail address looks like. So if your mail account address looks like SVCMail@.myISP.com, it may have an alias name of SVCSQLMail. It is critical that the alias name is right otherwise it won't work.

You can also try right clicking Database Mail/Send Test Message to see if the mail works at all. I have found that the mail does work quite often by using this method but then a job will fail to send mail if you try to set an alert for a job. That is pretty much how I discovered that if the Description and Alias name is wrong, it will fail to send mail under a job.

As far as the ISP not supporting SQL 2005 mail, it is probably not an issue because SQL 2005 just uses SMTP mail. There is also SQL Mail which uses the Outlook Client but that should not be an issue either as long as it is configured correctly.

Database Mail Configuration? Very Urgent

Hi!!!!

I'm a hobbyist Developer....

I'm would like to know how to send mails from Database Mail option in SQL Server 2005. I wil be glad if i can get a step-by-step procedure or any KB....

Moreover what i did was,

i tried to setup the database and i got the error message when i tried to send DB mails....

"An attempt was made to send an email when no email session has been established"

wil be thankful if i get help ASAP.

Thanks,

Jeffrey

Hi all....Why am i not getting any help? Seems that not even a single expert is having a look at this question.....

Please help me ASAP.......

TIA

Jeffrey

|||

I'm no expert; but, did you set up your email configuration?

I've set up my account / configuration; but, I'm getting the following error:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-06-22T02:27:43). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: authentication required - for help go to http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-11.html). )

SBCGlobal (my ISP) says they don't support SQL Server 2005 DB Mail?

Anyone else have this problem?

|||

Hi Steve,

I'm getting the same message as you are - sure would like to know what it means!!

Dave

|||

I got hung up on this one too, and what I found was when I set up the mail account to send mail in SQL Server I had used the wrong name for the Account Name and Display Name. Many e-mail accounts have an "Alias" name to them and they may not be what the actual e-mail address looks like. So if your mail account address looks like SVCMail@.myISP.com, it may have an alias name of SVCSQLMail. It is critical that the alias name is right otherwise it won't work.

You can also try right clicking Database Mail/Send Test Message to see if the mail works at all. I have found that the mail does work quite often by using this method but then a job will fail to send mail if you try to set an alert for a job. That is pretty much how I discovered that if the Description and Alias name is wrong, it will fail to send mail under a job.

As far as the ISP not supporting SQL 2005 mail, it is probably not an issue because SQL 2005 just uses SMTP mail. There is also SQL Mail which uses the Outlook Client but that should not be an issue either as long as it is configured correctly.

Friday, February 17, 2012

Database Lock! Urgent Please!

Hello folks!
I'm with two locks on a database and I can't access others databases too, except the master.

I've tryed to kill the lock, but I didn't have sucess.

Please help me!!!
Cheers!
Rafael

SPID DBID OBJID INDID TYPE MODE STATUS
9 5 0 0 DB S GRANT
9 5 0 0 DB X GRANT
51 1 85575343 0 TAB IS GRANTWhat are the spids doing?

Are they yours?

Are you blocking yourself?

Did you look at sp_lock?|||Yes, this spid 9 is me.
But I'm not getting access. I've already disconected.
Take a look on the screenshot|||What do you mean when you say that you can't access other databases?|||I mean that I can't.

When I try to access a database via Entreprise, Query Analyser, etc..
like USE DB_Emplacamentos, DB_Cadastro, whatever, any database on server, my command or my screen keeps trying to connect to the database for the enternity.

I dunno why this is happing. I saw my SQL Server Logs and some erros like this was found:

* Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
* Skipping startup of clean database id 6
* Skipping startup of clean database id 7
* Skipping startup of clean database id 8
* Skipping startup of clean database id 9
* Skipping startup of clean database id 10
* Analysis of database 'DB_Emplacamentos' (5) is 3% complete (approximately 1726 more seconds)

Man, I'm thinking to reinstall the instance of SQL Server and try to restore the database. It is really, really strange.

Cheers!
Rafael|||OK. This looks like SQL 2000. If that is the case, then SPID 9 is not you. Any spid under 50 is a system process. It appears you have just rebooted this machine, and have the "long transaction blues". DB_Emplacamentos will need 20 minutes for just the analysis portion of recovery. Rolling forward, and rolling back could take a bit of time, too. This can happen when you do a lot of re-indexing, then reboot the server (only index creation statements and page allocations, and not all the page changes are recorded in the logs), or if you have an immense transaction that was halfway done when you rebooted. Out of curiosity, how but is DB_Emplacamentos?|||Oh, I imagine you are getting login errors something like "Can not open default database"?|||This database name is like DB_CarIDs.
I have a table with aprox. 45 million rows. It's a little bit big.LOL
The datafiles are around 20GB.

Well, I'll leave the database trying to restabish until tomorrow. If not, I'll start the McGiver's process of reastabilish a 20GB backup.LOL

Thank's for your help. I really appreciate that.

Rafael|||ROLLBACK is like a DOG, always know the way to comeback home!

My databases are allset now!!!
Yeaaah!!!;)

Tks all!

Cheers
Rafael

Tuesday, February 14, 2012

Database keeps loading - urgent !

I'm trying to restore a set of 4 different databases. 2 of them went ok but
the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
option). When I try the RECOVER option I get this message
Server: Msg 3624, Level 20, State 1, Line 1
Location: filemgr.cpp:1749
Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
saflStatus)
SPID: 57
Process ID: 1604
Connection Broken
What can I do to resolve this problem ? I really need this data !Freddy
Drop the loading database and restore a new one with RECOVERY option
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> I'm trying to restore a set of 4 different databases. 2 of them went ok
but
> the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
> option). When I try the RECOVER option I get this message
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: filemgr.cpp:1749
> Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
> saflStatus)
> SPID: 57
> Process ID: 1604
> Connection Broken
> What can I do to resolve this problem ? I really need this data !|||I tried it with option RECOVER and that is when I get the error message
mentioned in my first question. Other options ?
Thanks
"Uri Dimant" wrote:
> Freddy
> Drop the loading database and restore a new one with RECOVERY option
>
> "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> > I'm trying to restore a set of 4 different databases. 2 of them went ok
> but
> > the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
> > option). When I try the RECOVER option I get this message
> > Server: Msg 3624, Level 20, State 1, Line 1
> >
> > Location: filemgr.cpp:1749
> > Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
> > saflStatus)
> > SPID: 57
> > Process ID: 1604
> >
> > Connection Broken
> >
> > What can I do to resolve this problem ? I really need this data !
>
>|||Hi
Is it something that someone removed the log file ?
Try detach the database and then attach it with single file option. (see
BOL)
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...
> I tried it with option RECOVER and that is when I get the error message
> mentioned in my first question. Other options ?
> Thanks
> "Uri Dimant" wrote:
> > Freddy
> > Drop the loading database and restore a new one with RECOVERY option
> >
> >
> >
> > "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> > message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> > > I'm trying to restore a set of 4 different databases. 2 of them went
ok
> > but
> > > the 2 others keep 'loading' after a succesfull restore ( with
NORECOVERY
> > > option). When I try the RECOVER option I get this message
> > > Server: Msg 3624, Level 20, State 1, Line 1
> > >
> > > Location: filemgr.cpp:1749
> > > Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
> > > saflStatus)
> > > SPID: 57
> > > Process ID: 1604
> > >
> > > Connection Broken
> > >
> > > What can I do to resolve this problem ? I really need this data !
> >
> >
> >|||The log file is there. I tried to attach the file like you said and got this
error
Server: Msg 9003, Level 20, State 6, Line 1
The LSN (1514:1035:8) passed to log scan in database 'BPW_Repository' is
invalid.
Connection Broken
"Uri Dimant" wrote:
> Hi
> Is it something that someone removed the log file ?
> Try detach the database and then attach it with single file option. (see
> BOL)
>
>
> "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...
> > I tried it with option RECOVER and that is when I get the error message
> > mentioned in my first question. Other options ?
> > Thanks
> >
> > "Uri Dimant" wrote:
> >
> > > Freddy
> > > Drop the loading database and restore a new one with RECOVERY option
> > >
> > >
> > >
> > > "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> > > message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> > > > I'm trying to restore a set of 4 different databases. 2 of them went
> ok
> > > but
> > > > the 2 others keep 'loading' after a succesfull restore ( with
> NORECOVERY
> > > > option). When I try the RECOVER option I get this message
> > > > Server: Msg 3624, Level 20, State 1, Line 1
> > > >
> > > > Location: filemgr.cpp:1749
> > > > Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
> > > > saflStatus)
> > > > SPID: 57
> > > > Process ID: 1604
> > > >
> > > > Connection Broken
> > > >
> > > > What can I do to resolve this problem ? I really need this data !
> > >
> > >
> > >
>
>|||Freddy
Look at this article
http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:2C86E47A-E4B1-46CB-813B-AE6457E71EDF@.microsoft.com...
> The log file is there. I tried to attach the file like you said and got
this
> error
> Server: Msg 9003, Level 20, State 6, Line 1
> The LSN (1514:1035:8) passed to log scan in database 'BPW_Repository' is
> invalid.
> Connection Broken
>
> "Uri Dimant" wrote:
> > Hi
> > Is it something that someone removed the log file ?
> >
> > Try detach the database and then attach it with single file option. (see
> > BOL)
> >
> >
> >
> >
> >
> > "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> > message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...
> > > I tried it with option RECOVER and that is when I get the error
message
> > > mentioned in my first question. Other options ?
> > > Thanks
> > >
> > > "Uri Dimant" wrote:
> > >
> > > > Freddy
> > > > Drop the loading database and restore a new one with RECOVERY option
> > > >
> > > >
> > > >
> > > > "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote
in
> > > > message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> > > > > I'm trying to restore a set of 4 different databases. 2 of them
went
> > ok
> > > > but
> > > > > the 2 others keep 'loading' after a succesfull restore ( with
> > NORECOVERY
> > > > > option). When I try the RECOVER option I get this message
> > > > > Server: Msg 3624, Level 20, State 1, Line 1
> > > > >
> > > > > Location: filemgr.cpp:1749
> > > > > Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON
(FCB_DROPPED,
> > > > > saflStatus)
> > > > > SPID: 57
> > > > > Process ID: 1604
> > > > >
> > > > > Connection Broken
> > > > >
> > > > > What can I do to resolve this problem ? I really need this data !
> > > >
> > > >
> > > >
> >
> >
> >

Database keeps loading - urgent !

I'm trying to restore a set of 4 different databases. 2 of them went ok but
the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
option). When I try the RECOVER option I get this message
Server: Msg 3624, Level 20, State 1, Line 1
Location: filemgr.cpp:1749
Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
saflStatus)
SPID: 57
Process ID: 1604
Connection Broken
What can I do to resolve this problem ? I really need this data !
Freddy
Drop the loading database and restore a new one with RECOVERY option
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> I'm trying to restore a set of 4 different databases. 2 of them went ok
but
> the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
> option). When I try the RECOVER option I get this message
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: filemgr.cpp:1749
> Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
> saflStatus)
> SPID: 57
> Process ID: 1604
> Connection Broken
> What can I do to resolve this problem ? I really need this data !
|||I tried it with option RECOVER and that is when I get the error message
mentioned in my first question. Other options ?
Thanks
"Uri Dimant" wrote:

> Freddy
> Drop the loading database and restore a new one with RECOVERY option
>
> "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> but
>
>
|||Hi
Is it something that someone removed the log file ?
Try detach the database and then attach it with single file option. (see
BOL)
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...[vbcol=seagreen]
> I tried it with option RECOVER and that is when I get the error message
> mentioned in my first question. Other options ?
> Thanks
> "Uri Dimant" wrote:
ok[vbcol=seagreen]
NORECOVERY[vbcol=seagreen]
|||The log file is there. I tried to attach the file like you said and got this
error
Server: Msg 9003, Level 20, State 6, Line 1
The LSN (1514:1035:8) passed to log scan in database 'BPW_Repository' is
invalid.
Connection Broken
"Uri Dimant" wrote:

> Hi
> Is it something that someone removed the log file ?
> Try detach the database and then attach it with single file option. (see
> BOL)
>
>
> "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...
> ok
> NORECOVERY
>
>
|||Freddy
Look at this article
http://www.karaszi.com/sqlserver/inf...suspect_db.asp
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:2C86E47A-E4B1-46CB-813B-AE6457E71EDF@.microsoft.com...
> The log file is there. I tried to attach the file like you said and got
this[vbcol=seagreen]
> error
> Server: Msg 9003, Level 20, State 6, Line 1
> The LSN (1514:1035:8) passed to log scan in database 'BPW_Repository' is
> invalid.
> Connection Broken
>
> "Uri Dimant" wrote:
message[vbcol=seagreen]
in[vbcol=seagreen]
went[vbcol=seagreen]
(FCB_DROPPED,[vbcol=seagreen]

Database keeps loading - urgent !

I'm trying to restore a set of 4 different databases. 2 of them went ok but
the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
option). When I try the RECOVER option I get this message
Server: Msg 3624, Level 20, State 1, Line 1
Location: filemgr.cpp:1749
Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
saflStatus)
SPID: 57
Process ID: 1604
Connection Broken
What can I do to resolve this problem ? I really need this data !Freddy
Drop the loading database and restore a new one with RECOVERY option
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> I'm trying to restore a set of 4 different databases. 2 of them went ok
but
> the 2 others keep 'loading' after a succesfull restore ( with NORECOVERY
> option). When I try the RECOVER option I get this message
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: filemgr.cpp:1749
> Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED,
> saflStatus)
> SPID: 57
> Process ID: 1604
> Connection Broken
> What can I do to resolve this problem ? I really need this data !|||I tried it with option RECOVER and that is when I get the error message
mentioned in my first question. Other options ?
Thanks
"Uri Dimant" wrote:

> Freddy
> Drop the loading database and restore a new one with RECOVERY option
>
> "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> message news:D694FB64-05DE-460B-A73C-37AAF856D1F7@.microsoft.com...
> but
>
>|||Hi
Is it something that someone removed the log file ?
Try detach the database and then attach it with single file option. (see
BOL)
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...[vbcol=seagreen]
> I tried it with option RECOVER and that is when I get the error message
> mentioned in my first question. Other options ?
> Thanks
> "Uri Dimant" wrote:
>
ok[vbcol=seagreen]
NORECOVERY[vbcol=seagreen]|||The log file is there. I tried to attach the file like you said and got this
error
Server: Msg 9003, Level 20, State 6, Line 1
The LSN (1514:1035:8) passed to log scan in database 'BPW_Repository' is
invalid.
Connection Broken
"Uri Dimant" wrote:

> Hi
> Is it something that someone removed the log file ?
> Try detach the database and then attach it with single file option. (see
> BOL)
>
>
> "Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
> message news:53DA351E-5EF0-484A-94D9-4424B14B9CE9@.microsoft.com...
> ok
> NORECOVERY
>
>|||Freddy
Look at this article
http://www.karaszi.com/sqlserver/in..._suspect_db.asp
"Freddy Lallemand" <FreddyLallemand@.discussions.microsoft.com> wrote in
message news:2C86E47A-E4B1-46CB-813B-AE6457E71EDF@.microsoft.com...
> The log file is there. I tried to attach the file like you said and got
this[vbcol=seagreen]
> error
> Server: Msg 9003, Level 20, State 6, Line 1
> The LSN (1514:1035:8) passed to log scan in database 'BPW_Repository' is
> invalid.
> Connection Broken
>
> "Uri Dimant" wrote:
>
message[vbcol=seagreen]
in[vbcol=seagreen]
went[vbcol=seagreen]
(FCB_DROPPED,[vbcol=seagreen]