problem with sql mail

i have configured sql mail to send emails to outlook with exchange server
running with outlook ... but the problem iam facing is that although the
option of "sent messages to the sent items folder " is cliecked under the
sql agent mail and also in the outlook but still any mail that goes through
sql mail is delivered successfully to the recipient but does not go the sent
items folder of outlook
would appreciate any help on this thnaksIf you are running SQL Server 2000, SQL Mail for SQL Server
2000 does not save a copy of sent messages in the Sent Items
folder. If you need a copy of the messages, you need to cc:
them to an exchange account and create an Outlook message
rule that routes these message copies to the Sent Items
folder.
For more info, refer to:
INF: Common SQL Mail Problems
http://support.microsoft.com/?scid=315886
The section: Q7: Why do I not have any sent messages in the
Sent Items folder explains this issue.
-Sue
On Sun, 7 Mar 2004 15:09:13 +1100, "afsheen"
<afsheenj@.hotmial.com> wrote:

>i have configured sql mail to send emails to outlook with exchange server
>running with outlook ... but the problem iam facing is that although the
>option of "sent messages to the sent items folder " is cliecked under the
>sql agent mail and also in the outlook but still any mail that goes through
>sql mail is delivered successfully to the recipient but does not go the sen
t
>items folder of outlook
>would appreciate any help on this thnaks
>

problem with RESTORE database

Hi Friends,
I have been facing a problem while restoring a database backup from
one SQL server on Win2003Server to another SQL Server on Win2000.
The error head is
ODBC SQL STATE : 42000
Please suggest me some way to overcome this.
Thanks,
Dutt.
How exactly are you restoring the database and can you give the full error
please?
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173694572.447609.52340@.h3g2000cwc.googlegrou ps.com...
> Hi Friends,
> I have been facing a problem while restoring a database backup from
> one SQL server on Win2003Server to another SQL Server on Win2000.
> The error head is
> ODBC SQL STATE : 42000
>
> Please suggest me some way to overcome this.
> Thanks,
> Dutt.
>
|||yeah,
Its saying........
The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
SQL Server cannot process this media family.
RESTORE is terminating abnormally.
Thanks Immi,
Dutt
|||and you are getting this error from simply backing up the database, copying
to the new server and then restoring?
Are they both SQLserver 2005?
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:O7AVESJZHHA.3628@.TK2MSFTNGP02.phx.gbl...
> How exactly are you restoring the database and can you give the full error
> please?
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1173694572.447609.52340@.h3g2000cwc.googlegrou ps.com...
>
|||Dutt
Try
restore database ... from disk ='D:\Xpert_Full.bak' with file=1 ,recovery
I think you issued your backup with 'without init' option
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173697414.376193.158530@.h3g2000cwc.googlegro ups.com...
> yeah,
> Its saying........
> The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> RESTORE is terminating abnormally.
> Thanks Immi,
> Dutt
>
|||Hello,
Can you use RESTORE HEADERONLY and see if you have multiple backup files in
the same the same backup file. If yes then
try using FILE= option while restoring. If you get any errors then you may
need to contact microsoft product support to
investigate further or do a FULL database backup again from source using
BACKUP DATABASE WITH INIT option
and try restoring into destination again.
Thanks
Hari
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173697414.376193.158530@.h3g2000cwc.googlegro ups.com...
> yeah,
> Its saying........
> The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> RESTORE is terminating abnormally.
> Thanks Immi,
> Dutt
>
|||Hi,
Immy,I'm using SQL Server 2000 in both systems.
Dimant,Its showing some error.
Hari,There is only one backup with that name.
I stress again that the back up is in another server.
Thanks,
Dutt

problem with RESTORE database

Hi Friends,
I have been facing a problem while restoring a database backup from
one SQL server on Win2003Server to another SQL Server on Win2000.
The error head is
ODBC SQL STATE : 42000
Please suggest me some way to overcome this.
Thanks,
Dutt.How exactly are you restoring the database and can you give the full error
please?
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173694572.447609.52340@.h3g2000cwc.googlegroups.com...
> Hi Friends,
> I have been facing a problem while restoring a database backup from
> one SQL server on Win2003Server to another SQL Server on Win2000.
> The error head is
> ODBC SQL STATE : 42000
>
> Please suggest me some way to overcome this.
> Thanks,
> Dutt.
>|||yeah,
Its saying........
The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
SQL Server cannot process this media family.
RESTORE is terminating abnormally.
Thanks Immi,
Dutt|||and you are getting this error from simply backing up the database, copying
to the new server and then restoring?
Are they both SQLserver 2005?
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:O7AVESJZHHA.3628@.TK2MSFTNGP02.phx.gbl...
> How exactly are you restoring the database and can you give the full error
> please?
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1173694572.447609.52340@.h3g2000cwc.googlegroups.com...
>|||Dutt
Try
restore database ... from disk ='D:\Xpert_Full.bak' with file=1 ,recovery
I think you issued your backup with 'without init' option
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173697414.376193.158530@.h3g2000cwc.googlegroups.com...
> yeah,
> Its saying........
> The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> RESTORE is terminating abnormally.
> Thanks Immi,
> Dutt
>|||Hello,
Can you use RESTORE HEADERONLY and see if you have multiple backup files in
the same the same backup file. If yes then
try using FILE= option while restoring. If you get any errors then you may
need to contact microsoft product support to
investigate further or do a FULL database backup again from source using
BACKUP DATABASE WITH INIT option
and try restoring into destination again.
Thanks
Hari
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173697414.376193.158530@.h3g2000cwc.googlegroups.com...
> yeah,
> Its saying........
> The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> RESTORE is terminating abnormally.
> Thanks Immi,
> Dutt
>|||Hi,
Immy,I'm using SQL Server 2000 in both systems.
Dimant,Its showing some error.
Hari,There is only one backup with that name.
I stress again that the back up is in another server.
Thanks,
Dutt|||Dutt wrote:
> Hi,
> Immy,I'm using SQL Server 2000 in both systems.
> Dimant,Its showing some error.
> Hari,There is only one backup with that name.
> I stress again that the back up is in another server.
> Thanks,
> Dutt
>
Could you show us the full statement you are running?
You could also try to look up the RESTORE FILELISTONLY and RESTORE
HEADERONLY commands in Books On Line to see what the reveal. An option
could also be to run the RESTORE VERIFYONLY command to check if the
backup file is corrupt or not.
Regards
Steen Schlter Persson
Database Administrator / System Administrator

problem with RESTORE database

Hi Friends,
I have been facing a problem while restoring a database backup from
one SQL server on Win2003Server to another SQL Server on Win2000.
The error head is
ODBC SQL STATE : 42000
Please suggest me some way to overcome this.
Thanks,
Dutt.How exactly are you restoring the database and can you give the full error
please?
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173694572.447609.52340@.h3g2000cwc.googlegroups.com...
> Hi Friends,
> I have been facing a problem while restoring a database backup from
> one SQL server on Win2003Server to another SQL Server on Win2000.
> The error head is
> ODBC SQL STATE : 42000
>
> Please suggest me some way to overcome this.
> Thanks,
> Dutt.
>|||yeah,
Its saying........
The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
SQL Server cannot process this media family.
RESTORE is terminating abnormally.
Thanks Immi,
Dutt|||and you are getting this error from simply backing up the database, copying
to the new server and then restoring?
Are they both SQLserver 2005?
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:O7AVESJZHHA.3628@.TK2MSFTNGP02.phx.gbl...
> How exactly are you restoring the database and can you give the full error
> please?
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1173694572.447609.52340@.h3g2000cwc.googlegroups.com...
>> Hi Friends,
>> I have been facing a problem while restoring a database backup from
>> one SQL server on Win2003Server to another SQL Server on Win2000.
>> The error head is
>> ODBC SQL STATE : 42000
>>
>> Please suggest me some way to overcome this.
>> Thanks,
>> Dutt.
>|||Dutt
Try
restore database ... from disk ='D:\Xpert_Full.bak' with file=1 ,recovery
I think you issued your backup with 'without init' option
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173697414.376193.158530@.h3g2000cwc.googlegroups.com...
> yeah,
> Its saying........
> The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> RESTORE is terminating abnormally.
> Thanks Immi,
> Dutt
>|||Hello,
Can you use RESTORE HEADERONLY and see if you have multiple backup files in
the same the same backup file. If yes then
try using FILE= option while restoring. If you get any errors then you may
need to contact microsoft product support to
investigate further or do a FULL database backup again from source using
BACKUP DATABASE WITH INIT option
and try restoring into destination again.
Thanks
Hari
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173697414.376193.158530@.h3g2000cwc.googlegroups.com...
> yeah,
> Its saying........
> The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> RESTORE is terminating abnormally.
> Thanks Immi,
> Dutt
>|||Hi,
Immy,I'm using SQL Server 2000 in both systems.
Dimant,Its showing some error.
Hari,There is only one backup with that name.
I stress again that the back up is in another server.
Thanks,
Dutt|||Dutt wrote:
> Hi,
> Immy,I'm using SQL Server 2000 in both systems.
> Dimant,Its showing some error.
> Hari,There is only one backup with that name.
> I stress again that the back up is in another server.
> Thanks,
> Dutt
>
Could you show us the full statement you are running?
You could also try to look up the RESTORE FILELISTONLY and RESTORE
HEADERONLY commands in Books On Line to see what the reveal. An option
could also be to run the RESTORE VERIFYONLY command to check if the
backup file is corrupt or not.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

Problem with osql.exe -L

Hi Everyone,
I'm facing a small problem. Whenever I execute osql.exe -L command it lists
all the server on the network except my local server instance (not default i
nstance) and other similar server instance names on the network.
Earlier it use to list all the server instance but all of a sudden stopped l
isting.
What can be the problem? Please help me to rectify this issue.
Thanks in adv.
Regards,
BGSOSQL -L uses the ODBC SQLBrowseConnect functionality. It's
not guaranteed to give a complete list due to broadcast
issues, network routers/subnet issues, instances may not
respond within the timeout period, etc. You can find issues
listed here:
http://www.sqldev.net/misc/ListSQLSvr.htm
-Sue
On Wed, 1 Jun 2005 20:15:46 +0530, "Gururaj Badam"
<gururajb@.msn.com> wrote:

>Hi Everyone,
>I'm facing a small problem. Whenever I execute osql.exe -L command it lists
all the server on the network except my local server instance (not default
instance) and other similar server instance names on the network.
>Earlier it use to list all the server instance but all of a sudden stopped
listing.
>What can be the problem? Please help me to rectify this issue.
>Thanks in adv.
>Regards,
>BGS|||Sue,
Is ListAvailableSQLServers in SQL-DMO is also same as "osql -L" command?
Actually I'm trying to populate a ComboBox with list of all the SQL Servers
on the network and set the default to the Local Server (desired instance).
Can you suggest some other better mechanism which can be used to acheive the
same?
-BGS|||ListAvailableServers is also based on the ODBC function
SQLBrowseConnect. If you need a guaranteed list and are
running SQL 2000, you could register all SQL Servers in AD
and go through AD to list all of SQL Servers.
-Sue
On Thu, 2 Jun 2005 09:57:10 +0530, "Gururaj Badam"
<gururajb@.msn.com> wrote:

>Sue,
>Is ListAvailableSQLServers in SQL-DMO is also same as "osql -L" command?
>Actually I'm trying to populate a ComboBox with list of all the SQL Servers
>on the network and set the default to the Local Server (desired instance).
>Can you suggest some other better mechanism which can be used to acheive th
e
>same?
>-BGS
>|||Sue,
Actually I'm not using SQL 2k but MSDE installation. It is a product, I
can't ask the client to install SQL Server 2000.
That's the reason I'm packing the MSDE along with the application
installation package.
-BGS
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:g9ut91daj141d35g8v2dn133q713uo9ieq@.
4ax.com...
> ListAvailableServers is also based on the ODBC function
> SQLBrowseConnect. If you need a guaranteed list and are
> running SQL 2000, you could register all SQL Servers in AD
> and go through AD to list all of SQL Servers.
> -Sue
>|||MSDE is SQL Server, so everything that Sue mentioned still applies.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gururaj Badam" <gururajb@.msn.com> wrote in message news:OV9E6C3ZFHA.2916@.TK2MSFTNGP14.phx.g
bl...
> Sue,
> Actually I'm not using SQL 2k but MSDE installation. It is a product, I
> can't ask the client to install SQL Server 2000.
> That's the reason I'm packing the MSDE along with the application
> installation package.
> -BGS
>
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:g9ut91daj141d35g8v2dn133q713uo9ieq@.
4ax.com...
>|||Tibor,
How can I ask the user of my product to register the SQL Server with the AD,
that looks odd.
Is there any other way to approach this problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23AYiWX3ZFHA.3040@.TK2MSFTNGP14.phx.gbl...
> MSDE is SQL Server, so everything that Sue mentioned still applies.
> --
> Tibor Karaszi, SQL Server MVP

Problem with osql.exe -L

Hi Everyone,
I'm facing a small problem. Whenever I execute osql.exe -L command it lists all the server on the network except my local server instance (not default instance) and other similar server instance names on the network.
Earlier it use to list all the server instance but all of a sudden stopped listing.
What can be the problem? Please help me to rectify this issue.
Thanks in adv.
Regards,
BGS
OSQL -L uses the ODBC SQLBrowseConnect functionality. It's
not guaranteed to give a complete list due to broadcast
issues, network routers/subnet issues, instances may not
respond within the timeout period, etc. You can find issues
listed here:
http://www.sqldev.net/misc/ListSQLSvr.htm
-Sue
On Wed, 1 Jun 2005 20:15:46 +0530, "Gururaj Badam"
<gururajb@.msn.com> wrote:

>Hi Everyone,
>I'm facing a small problem. Whenever I execute osql.exe -L command it lists all the server on the network except my local server instance (not default instance) and other similar server instance names on the network.
>Earlier it use to list all the server instance but all of a sudden stopped listing.
>What can be the problem? Please help me to rectify this issue.
>Thanks in adv.
>Regards,
>BGS
|||Sue,
Is ListAvailableSQLServers in SQL-DMO is also same as "osql -L" command?
Actually I'm trying to populate a ComboBox with list of all the SQL Servers
on the network and set the default to the Local Server (desired instance).
Can you suggest some other better mechanism which can be used to acheive the
same?
-BGS
|||ListAvailableServers is also based on the ODBC function
SQLBrowseConnect. If you need a guaranteed list and are
running SQL 2000, you could register all SQL Servers in AD
and go through AD to list all of SQL Servers.
-Sue
On Thu, 2 Jun 2005 09:57:10 +0530, "Gururaj Badam"
<gururajb@.msn.com> wrote:

>Sue,
>Is ListAvailableSQLServers in SQL-DMO is also same as "osql -L" command?
>Actually I'm trying to populate a ComboBox with list of all the SQL Servers
>on the network and set the default to the Local Server (desired instance).
>Can you suggest some other better mechanism which can be used to acheive the
>same?
>-BGS
>
|||Sue,
Actually I'm not using SQL 2k but MSDE installation. It is a product, I
can't ask the client to install SQL Server 2000.
That's the reason I'm packing the MSDE along with the application
installation package.
-BGS
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:g9ut91daj141d35g8v2dn133q713uo9ieq@.4ax.com...
> ListAvailableServers is also based on the ODBC function
> SQLBrowseConnect. If you need a guaranteed list and are
> running SQL 2000, you could register all SQL Servers in AD
> and go through AD to list all of SQL Servers.
> -Sue
>
|||MSDE is SQL Server, so everything that Sue mentioned still applies.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gururaj Badam" <gururajb@.msn.com> wrote in message news:OV9E6C3ZFHA.2916@.TK2MSFTNGP14.phx.gbl...
> Sue,
> Actually I'm not using SQL 2k but MSDE installation. It is a product, I
> can't ask the client to install SQL Server 2000.
> That's the reason I'm packing the MSDE along with the application
> installation package.
> -BGS
>
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:g9ut91daj141d35g8v2dn133q713uo9ieq@.4ax.com...
>
|||Tibor,
How can I ask the user of my product to register the SQL Server with the AD,
that looks odd.
Is there any other way to approach this problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23AYiWX3ZFHA.3040@.TK2MSFTNGP14.phx.gbl...
> MSDE is SQL Server, so everything that Sue mentioned still applies.
> --
> Tibor Karaszi, SQL Server MVP