Folks,
Can you point me to where I can look for more info to complete this task.
There is a proprietary app running with SQL 2000 as backend. Everynight the
app put DB in single user mode and runs DBCC itself to check data. That
runs well except few times it failed to get exclusive login in order to
clear single user mode. It causes the app fails to open. I think I may
want to run a script at my computer querying the DB and notify someone by
using Outlook on my computer. Is there any info that can tell me how to
open Outlook from in inside sql script?
Thanks,Hi,
try to use xp_sendmail. but you don't need the database in
single user to run dbcc checkdb, you only need single user
mode if you use the repair option.
CMLC
>--Original Message--
>Folks,
>Can you point me to where I can look for more info to
complete this task.
>There is a proprietary app running with SQL 2000 as
backend. Everynight the
>app put DB in single user mode and runs DBCC itself to
check data. That
>runs well except few times it failed to get exclusive
login in order to
>clear single user mode. It causes the app fails to
open. I think I may
>want to run a script at my computer querying the DB and
notify someone by
>using Outlook on my computer. Is there any info that can
tell me how to
>open Outlook from in inside sql script?
>Thanks,
>
>.
>|||hi,
to use xp_sendmail we must have SQL mail configured on the SQL box. This is
not my case because I can't touch the box. What I wanted is to use Outlook
on my pc to send email out. Is it possible?
> you don't need the database in single user to run dbcc checkdb, you only
> need single user mode if you use the >repair option
the app is proprietary so ... no touching. It seems that it would repair
data if possible.
"CMLC" <anonymous@.discussions.microsoft.com> wrote in message
news:196d01c4a188$bc87d820$a401280a@.phx.gbl...
> Hi,
> try to use xp_sendmail. but you don't need the database in
> single user to run dbcc checkdb, you only need single user
> mode if you use the repair option.
> CMLC
>
>>--Original Message--
>>Folks,
>>Can you point me to where I can look for more info to
> complete this task.
>>There is a proprietary app running with SQL 2000 as
> backend. Everynight the
>>app put DB in single user mode and runs DBCC itself to
> check data. That
>>runs well except few times it failed to get exclusive
> login in order to
>>clear single user mode. It causes the app fails to
> open. I think I may
>>want to run a script at my computer querying the DB and
> notify someone by
>>using Outlook on my computer. Is there any info that can
> tell me how to
>>open Outlook from in inside sql script?
>>Thanks,
>>
>>.|||Hi,
Thanks for your post.
From your descriptions, I understood that you would like to notify the
logon customer by email but you cannot configure your SQL Profile. Correct
me if I was wrong.
Based on my scope, You can use other methods to send Simple Mail Transfer
Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
OLE Automation stored procedures. See the following documents for more
detailed information
HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
http://support.microsoft.com/?kbid=312839
Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
for sending MIME based email over SMTP, implemented as an Extended Stored
Procedure.
XPSMTP.DLL - SQL Server SMTP Mail XP
http://www.sqldev.net/xp/xpsmtp.htm
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.|||Thank you. It's what I wanted. I was thinking of a much more complicated
Outlook approach.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:$y5iBpeoEHA.740@.cpmsftngxa06.phx.gbl...
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to notify the
> logon customer by email but you cannot configure your SQL Profile. Correct
> me if I was wrong.
> Based on my scope, You can use other methods to send Simple Mail Transfer
> Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
> Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
> Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
> OLE Automation stored procedures. See the following documents for more
> detailed information
> HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
> http://support.microsoft.com/?kbid=312839
> Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
> for sending MIME based email over SMTP, implemented as an Extended Stored
> Procedure.
> XPSMTP.DLL - SQL Server SMTP Mail XP
> http://www.sqldev.net/xp/xpsmtp.htm
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
> This document contains references to a third party World Wide Web site.
> Microsoft is providing this information as a convenience to you. Microsoft
> does not control these sites and has not tested any software or
> information
> found on these sites; therefore, Microsoft cannot make any representations
> regarding the quality, safety, or suitability of any software or
> information found there. There are inherent dangers in the use of any
> software found on the Internet, and Microsoft cautions you to make sure
> that you completely understand the risk before retrieving any software
> from
> the Internet.
>|||It works great for me. However is there any pros or cons of sending mail
out using CDOSYS such as security?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:$y5iBpeoEHA.740@.cpmsftngxa06.phx.gbl...
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to notify the
> logon customer by email but you cannot configure your SQL Profile. Correct
> me if I was wrong.
> Based on my scope, You can use other methods to send Simple Mail Transfer
> Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
> Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
> Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
> OLE Automation stored procedures. See the following documents for more
> detailed information
> HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
> http://support.microsoft.com/?kbid=312839
> Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
> for sending MIME based email over SMTP, implemented as an Extended Stored
> Procedure.
> XPSMTP.DLL - SQL Server SMTP Mail XP
> http://www.sqldev.net/xp/xpsmtp.htm
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
> This document contains references to a third party World Wide Web site.
> Microsoft is providing this information as a convenience to you. Microsoft
> does not control these sites and has not tested any software or
> information
> found on these sites; therefore, Microsoft cannot make any representations
> regarding the quality, safety, or suitability of any software or
> information found there. There are inherent dangers in the use of any
> software found on the Internet, and Microsoft cautions you to make sure
> that you completely understand the risk before retrieving any software
> from
> the Internet.
>|||Hi,
It's great to hear that my suggestion is suitable for you.
Collaboration Data Objects (CDO) for Microsoft? Windows? 2000 (Cdosys.dll),
which implements the 2.0 version of the Collaboration Data Objects API
specification, is a Component Object Model (COM) component designed to
simplify writing programs that create or manipulate Internet messages. You
could ask this exchange newsgroup, where I think will be more professional
answers there.
IMO, CDOSYS requires relatively high level of development instead of
xp_sendmail do. I would like to suggest upgrading to the lastest updates,
Windows 2000 SP4 and Office 2000 SP3 (if you had that Office installed).
See the documents below for detailed information about why these updates
are important
OL2000: Information About the CDO E-mail Security Update
http://support.microsoft.com/default.aspx?scid=kb;en-us;268279
OFF2000: How to Update an Administrative Installation with the Outlook CDO
Security Update
http://support.microsoft.com/default.aspx?scid=kb;en-us;268719
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!sql
Showing posts with label complete. Show all posts
Showing posts with label complete. Show all posts
Wednesday, March 28, 2012
Outlook
Folks,
Can you point me to where I can look for more info to complete this task.
There is a proprietary app running with SQL 2000 as backend. Everynight the
app put DB in single user mode and runs DBCC itself to check data. That
runs well except few times it failed to get exclusive login in order to
clear single user mode. It causes the app fails to open. I think I may
want to run a script at my computer querying the DB and notify someone by
using Outlook on my computer. Is there any info that can tell me how to
open Outlook from in inside sql script?
Thanks,
Hi,
Thanks for your post.
From your descriptions, I understood that you would like to notify the
logon customer by email but you cannot configure your SQL Profile. Correct
me if I was wrong.
Based on my scope, You can use other methods to send Simple Mail Transfer
Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
OLE Automation stored procedures. See the following documents for more
detailed information
HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
http://support.microsoft.com/?kbid=312839
Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
for sending MIME based email over SMTP, implemented as an Extended Stored
Procedure.
XPSMTP.DLL - SQL Server SMTP Mail XP
http://www.sqldev.net/xp/xpsmtp.htm
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
|||Thank you. It's what I wanted. I was thinking of a much more complicated
Outlook approach.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:$y5iBpeoEHA.740@.cpmsftngxa06.phx.gbl...
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to notify the
> logon customer by email but you cannot configure your SQL Profile. Correct
> me if I was wrong.
> Based on my scope, You can use other methods to send Simple Mail Transfer
> Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
> Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
> Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
> OLE Automation stored procedures. See the following documents for more
> detailed information
> HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
> http://support.microsoft.com/?kbid=312839
> Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
> for sending MIME based email over SMTP, implemented as an Extended Stored
> Procedure.
> XPSMTP.DLL - SQL Server SMTP Mail XP
> http://www.sqldev.net/xp/xpsmtp.htm
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
> This document contains references to a third party World Wide Web site.
> Microsoft is providing this information as a convenience to you. Microsoft
> does not control these sites and has not tested any software or
> information
> found on these sites; therefore, Microsoft cannot make any representations
> regarding the quality, safety, or suitability of any software or
> information found there. There are inherent dangers in the use of any
> software found on the Internet, and Microsoft cautions you to make sure
> that you completely understand the risk before retrieving any software
> from
> the Internet.
>
|||It works great for me. However is there any pros or cons of sending mail
out using CDOSYS such as security?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:$y5iBpeoEHA.740@.cpmsftngxa06.phx.gbl...
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to notify the
> logon customer by email but you cannot configure your SQL Profile. Correct
> me if I was wrong.
> Based on my scope, You can use other methods to send Simple Mail Transfer
> Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
> Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
> Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
> OLE Automation stored procedures. See the following documents for more
> detailed information
> HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
> http://support.microsoft.com/?kbid=312839
> Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
> for sending MIME based email over SMTP, implemented as an Extended Stored
> Procedure.
> XPSMTP.DLL - SQL Server SMTP Mail XP
> http://www.sqldev.net/xp/xpsmtp.htm
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
> This document contains references to a third party World Wide Web site.
> Microsoft is providing this information as a convenience to you. Microsoft
> does not control these sites and has not tested any software or
> information
> found on these sites; therefore, Microsoft cannot make any representations
> regarding the quality, safety, or suitability of any software or
> information found there. There are inherent dangers in the use of any
> software found on the Internet, and Microsoft cautions you to make sure
> that you completely understand the risk before retrieving any software
> from
> the Internet.
>
|||Hi,
It's great to hear that my suggestion is suitable for you.
Collaboration Data Objects (CDO) for Microsoft? Windows? 2000 (Cdosys.dll),
which implements the 2.0 version of the Collaboration Data Objects API
specification, is a Component Object Model (COM) component designed to
simplify writing programs that create or manipulate Internet messages. You
could ask this exchange newsgroup, where I think will be more professional
answers there.
IMO, CDOSYS requires relatively high level of development instead of
xp_sendmail do. I would like to suggest upgrading to the lastest updates,
Windows 2000 SP4 and Office 2000 SP3 (if you had that Office installed).
See the documents below for detailed information about why these updates
are important
OL2000: Information About the CDO E-mail Security Update
http://support.microsoft.com/default...b;en-us;268279
OFF2000: How to Update an Administrative Installation with the Outlook CDO
Security Update
http://support.microsoft.com/default...b;en-us;268719
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Can you point me to where I can look for more info to complete this task.
There is a proprietary app running with SQL 2000 as backend. Everynight the
app put DB in single user mode and runs DBCC itself to check data. That
runs well except few times it failed to get exclusive login in order to
clear single user mode. It causes the app fails to open. I think I may
want to run a script at my computer querying the DB and notify someone by
using Outlook on my computer. Is there any info that can tell me how to
open Outlook from in inside sql script?
Thanks,
Hi,
Thanks for your post.
From your descriptions, I understood that you would like to notify the
logon customer by email but you cannot configure your SQL Profile. Correct
me if I was wrong.
Based on my scope, You can use other methods to send Simple Mail Transfer
Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
OLE Automation stored procedures. See the following documents for more
detailed information
HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
http://support.microsoft.com/?kbid=312839
Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
for sending MIME based email over SMTP, implemented as an Extended Stored
Procedure.
XPSMTP.DLL - SQL Server SMTP Mail XP
http://www.sqldev.net/xp/xpsmtp.htm
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
|||Thank you. It's what I wanted. I was thinking of a much more complicated
Outlook approach.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:$y5iBpeoEHA.740@.cpmsftngxa06.phx.gbl...
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to notify the
> logon customer by email but you cannot configure your SQL Profile. Correct
> me if I was wrong.
> Based on my scope, You can use other methods to send Simple Mail Transfer
> Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
> Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
> Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
> OLE Automation stored procedures. See the following documents for more
> detailed information
> HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
> http://support.microsoft.com/?kbid=312839
> Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
> for sending MIME based email over SMTP, implemented as an Extended Stored
> Procedure.
> XPSMTP.DLL - SQL Server SMTP Mail XP
> http://www.sqldev.net/xp/xpsmtp.htm
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
> This document contains references to a third party World Wide Web site.
> Microsoft is providing this information as a convenience to you. Microsoft
> does not control these sites and has not tested any software or
> information
> found on these sites; therefore, Microsoft cannot make any representations
> regarding the quality, safety, or suitability of any software or
> information found there. There are inherent dangers in the use of any
> software found on the Internet, and Microsoft cautions you to make sure
> that you completely understand the risk before retrieving any software
> from
> the Internet.
>
|||It works great for me. However is there any pros or cons of sending mail
out using CDOSYS such as security?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:$y5iBpeoEHA.740@.cpmsftngxa06.phx.gbl...
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to notify the
> logon customer by email but you cannot configure your SQL Profile. Correct
> me if I was wrong.
> Based on my scope, You can use other methods to send Simple Mail Transfer
> Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
> Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
> Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
> OLE Automation stored procedures. See the following documents for more
> detailed information
> HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
> http://support.microsoft.com/?kbid=312839
> Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
> for sending MIME based email over SMTP, implemented as an Extended Stored
> Procedure.
> XPSMTP.DLL - SQL Server SMTP Mail XP
> http://www.sqldev.net/xp/xpsmtp.htm
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
> This document contains references to a third party World Wide Web site.
> Microsoft is providing this information as a convenience to you. Microsoft
> does not control these sites and has not tested any software or
> information
> found on these sites; therefore, Microsoft cannot make any representations
> regarding the quality, safety, or suitability of any software or
> information found there. There are inherent dangers in the use of any
> software found on the Internet, and Microsoft cautions you to make sure
> that you completely understand the risk before retrieving any software
> from
> the Internet.
>
|||Hi,
It's great to hear that my suggestion is suitable for you.
Collaboration Data Objects (CDO) for Microsoft? Windows? 2000 (Cdosys.dll),
which implements the 2.0 version of the Collaboration Data Objects API
specification, is a Component Object Model (COM) component designed to
simplify writing programs that create or manipulate Internet messages. You
could ask this exchange newsgroup, where I think will be more professional
answers there.
IMO, CDOSYS requires relatively high level of development instead of
xp_sendmail do. I would like to suggest upgrading to the lastest updates,
Windows 2000 SP4 and Office 2000 SP3 (if you had that Office installed).
See the documents below for detailed information about why these updates
are important
OL2000: Information About the CDO E-mail Security Update
http://support.microsoft.com/default...b;en-us;268279
OFF2000: How to Update an Administrative Installation with the Outlook CDO
Security Update
http://support.microsoft.com/default...b;en-us;268719
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Wednesday, March 7, 2012
osql command reference?
Hi!
I have been looking for a complete command reference to osql. A document
that describes all possible SQL commands that you acn use. Unfortunately,
I seem too stupid :/
I haven't found:
* the complete desciption of BACKUP and RESTORE
* a way to show the table definitions.
TIA,
Stefan
At command prompt, run the following command and it will show you all
switches available for OSQL.
OSQL /?
Also see the topic "osql utility" in SQL Server 2000 Books Online.
Similarly, SQL Server Books Online has complete documentation on BACUP and
RESTORE commands.
sp_help will give you table definitions and you can generate table creation
scripts in Enterprise Manager.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsbdo75yjs9ddfw@.news.individual.de...
Hi!
I have been looking for a complete command reference to osql. A document
that describes all possible SQL commands that you acn use. Unfortunately,
I seem too stupid :/
I haven't found:
* the complete desciption of BACKUP and RESTORE
* a way to show the table definitions.
TIA,
Stefan
|||On Mon, 19 Jul 2004 11:09:11 +0100, Narayana Vyas Kondreddi
<answer_me@.hotmail.com> wrote:
> At command prompt, run the following command and it will show you all
> switches available for OSQL.
> OSQL /?
These, I know, thanks
> Also see the topic "osql utility" in SQL Server 2000 Books Online.
> Similarly, SQL Server Books Online has complete documentation on BACUP
> and RESTORE commands.
> sp_help will give you table definitions and you can generate table
> creation scripts in Enterprise Manager.
Thanks, that helped me to find my way through. I found an online reference
at
<http://manuals.sybase.com/onlinebook...sg1250e/sqlug/>.
Stefan
|||Hi,
Books online is the best option to learn all commands and usage.
http://www.microsoft.com/sql/techinf...2000/books.asp
* the complete desciption of BACKUP and RESTORE
See backup and Restore in books online
* a way to show the table definitions.
sp_help <table_name>
* OSQL
See OSQL in books online
Thanks
Hari
MCDBA
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsbdo75yjs9ddfw@.news.individual.de...
> Hi!
> I have been looking for a complete command reference to osql. A
document
> that describes all possible SQL commands that you acn use. Unfortunately,
> I seem too stupid :/
> I haven't found:
> * the complete desciption of BACKUP and RESTORE
> * a way to show the table definitions.
> TIA,
> Stefan
|||The online reference you found is for Sybase and is not valid for Microsoft
SQL Server. Follow Hari's link.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsbdq5udms9ddfw@.pluto...
On Mon, 19 Jul 2004 11:09:11 +0100, Narayana Vyas Kondreddi
<answer_me@.hotmail.com> wrote:
> At command prompt, run the following command and it will show you all
> switches available for OSQL.
> OSQL /?
These, I know, thanks
> Also see the topic "osql utility" in SQL Server 2000 Books Online.
> Similarly, SQL Server Books Online has complete documentation on BACUP
> and RESTORE commands.
> sp_help will give you table definitions and you can generate table
> creation scripts in Enterprise Manager.
Thanks, that helped me to find my way through. I found an online reference
at
<http://manuals.sybase.com/onlinebook...sg1250e/sqlug/>.
Stefan
|||On Mon, 19 Jul 2004 15:57:16 +0530, Hari Prasad
<hari_prasad_k@.hotmail.com> wrote:
> Hi,
> Books online is the best option to learn all commands and usage.
> http://www.microsoft.com/sql/techinf...2000/books.asp
> * the complete desciption of BACKUP and RESTORE
> See backup and Restore in books online
> * a way to show the table definitions.
> sp_help <table_name>
> * OSQL
> See OSQL in books online
Thanks!
And while my other link isn't for MSDE, most of the things discussed there
work in MSDE as well
Stefan
|||osql is primarily a utility for running Transact-SQL statements on an
instance of SQL Server, including MSDE 2000. The primary reference for most
of the statements you can run using osql is the Transact-SQL Reference in
the SQL Server 2000 Books Online.
You can download the latest version of the SQL Server 2000 Books Online
from:
http://www.microsoft.com/sql/techinf...2000/books.asp
The latest version of the SQL Server 2000 Books Online is also published in
the MSDN Library at:
http://msdn.microsoft.com/library/?u...asp?frame=true
These are topics about running osql that are in the copy of the Books Online
in MSDN:
http://msdn.microsoft.com/library/de...asp?frame=true
http://msdn.microsoft.com/library/?u...asp?frame=true
This is the start of the Transact-SQL Reference in the MSDN copy of the
Books Online:
http://msdn.microsoft.com/library/de...asp?frame=true
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
I have been looking for a complete command reference to osql. A document
that describes all possible SQL commands that you acn use. Unfortunately,
I seem too stupid :/
I haven't found:
* the complete desciption of BACKUP and RESTORE
* a way to show the table definitions.
TIA,
Stefan
At command prompt, run the following command and it will show you all
switches available for OSQL.
OSQL /?
Also see the topic "osql utility" in SQL Server 2000 Books Online.
Similarly, SQL Server Books Online has complete documentation on BACUP and
RESTORE commands.
sp_help will give you table definitions and you can generate table creation
scripts in Enterprise Manager.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsbdo75yjs9ddfw@.news.individual.de...
Hi!
I have been looking for a complete command reference to osql. A document
that describes all possible SQL commands that you acn use. Unfortunately,
I seem too stupid :/
I haven't found:
* the complete desciption of BACKUP and RESTORE
* a way to show the table definitions.
TIA,
Stefan
|||On Mon, 19 Jul 2004 11:09:11 +0100, Narayana Vyas Kondreddi
<answer_me@.hotmail.com> wrote:
> At command prompt, run the following command and it will show you all
> switches available for OSQL.
> OSQL /?
These, I know, thanks
> Also see the topic "osql utility" in SQL Server 2000 Books Online.
> Similarly, SQL Server Books Online has complete documentation on BACUP
> and RESTORE commands.
> sp_help will give you table definitions and you can generate table
> creation scripts in Enterprise Manager.
Thanks, that helped me to find my way through. I found an online reference
at
<http://manuals.sybase.com/onlinebook...sg1250e/sqlug/>.
Stefan
|||Hi,
Books online is the best option to learn all commands and usage.
http://www.microsoft.com/sql/techinf...2000/books.asp
* the complete desciption of BACKUP and RESTORE
See backup and Restore in books online
* a way to show the table definitions.
sp_help <table_name>
* OSQL
See OSQL in books online
Thanks
Hari
MCDBA
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsbdo75yjs9ddfw@.news.individual.de...
> Hi!
> I have been looking for a complete command reference to osql. A
document
> that describes all possible SQL commands that you acn use. Unfortunately,
> I seem too stupid :/
> I haven't found:
> * the complete desciption of BACKUP and RESTORE
> * a way to show the table definitions.
> TIA,
> Stefan
|||The online reference you found is for Sybase and is not valid for Microsoft
SQL Server. Follow Hari's link.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsbdq5udms9ddfw@.pluto...
On Mon, 19 Jul 2004 11:09:11 +0100, Narayana Vyas Kondreddi
<answer_me@.hotmail.com> wrote:
> At command prompt, run the following command and it will show you all
> switches available for OSQL.
> OSQL /?
These, I know, thanks
> Also see the topic "osql utility" in SQL Server 2000 Books Online.
> Similarly, SQL Server Books Online has complete documentation on BACUP
> and RESTORE commands.
> sp_help will give you table definitions and you can generate table
> creation scripts in Enterprise Manager.
Thanks, that helped me to find my way through. I found an online reference
at
<http://manuals.sybase.com/onlinebook...sg1250e/sqlug/>.
Stefan
|||On Mon, 19 Jul 2004 15:57:16 +0530, Hari Prasad
<hari_prasad_k@.hotmail.com> wrote:
> Hi,
> Books online is the best option to learn all commands and usage.
> http://www.microsoft.com/sql/techinf...2000/books.asp
> * the complete desciption of BACKUP and RESTORE
> See backup and Restore in books online
> * a way to show the table definitions.
> sp_help <table_name>
> * OSQL
> See OSQL in books online
Thanks!
And while my other link isn't for MSDE, most of the things discussed there
work in MSDE as well
Stefan
|||osql is primarily a utility for running Transact-SQL statements on an
instance of SQL Server, including MSDE 2000. The primary reference for most
of the statements you can run using osql is the Transact-SQL Reference in
the SQL Server 2000 Books Online.
You can download the latest version of the SQL Server 2000 Books Online
from:
http://www.microsoft.com/sql/techinf...2000/books.asp
The latest version of the SQL Server 2000 Books Online is also published in
the MSDN Library at:
http://msdn.microsoft.com/library/?u...asp?frame=true
These are topics about running osql that are in the copy of the Books Online
in MSDN:
http://msdn.microsoft.com/library/de...asp?frame=true
http://msdn.microsoft.com/library/?u...asp?frame=true
This is the start of the Transact-SQL Reference in the MSDN copy of the
Books Online:
http://msdn.microsoft.com/library/de...asp?frame=true
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Monday, February 20, 2012
Orphaned SPID
I have a spid that was killed in the middle of a
rollback. The status message states that the rollback is
100% complete. The query analyzer connection is not there
anymore.
I cannot kill that spid with the kill command. Is there
any way to kill it without bouncing the server?
"canaries" <anonymous@.discussions.microsoft.com> wrote in message
news:494701c47ff8$74a7d6b0$a401280a@.phx.gbl...
> I have a spid that was killed in the middle of a
> rollback. The status message states that the rollback is
> 100% complete. The query analyzer connection is not there
> anymore.
> I cannot kill that spid with the kill command. Is there
> any way to kill it without bouncing the server?
Assuming you're talking about bouncing the physical server, stopping and
restarting the mssqlserver service should do it for you...
Steve
rollback. The status message states that the rollback is
100% complete. The query analyzer connection is not there
anymore.
I cannot kill that spid with the kill command. Is there
any way to kill it without bouncing the server?
"canaries" <anonymous@.discussions.microsoft.com> wrote in message
news:494701c47ff8$74a7d6b0$a401280a@.phx.gbl...
> I have a spid that was killed in the middle of a
> rollback. The status message states that the rollback is
> 100% complete. The query analyzer connection is not there
> anymore.
> I cannot kill that spid with the kill command. Is there
> any way to kill it without bouncing the server?
Assuming you're talking about bouncing the physical server, stopping and
restarting the mssqlserver service should do it for you...
Steve
Orphaned SPID
I have a spid that was killed in the middle of a
rollback. The status message states that the rollback is
100% complete. The query analyzer connection is not there
anymore.
I cannot kill that spid with the kill command. Is there
any way to kill it without bouncing the server?"canaries" <anonymous@.discussions.microsoft.com> wrote in message
news:494701c47ff8$74a7d6b0$a401280a@.phx.gbl...
> I have a spid that was killed in the middle of a
> rollback. The status message states that the rollback is
> 100% complete. The query analyzer connection is not there
> anymore.
> I cannot kill that spid with the kill command. Is there
> any way to kill it without bouncing the server?
Assuming you're talking about bouncing the physical server, stopping and
restarting the mssqlserver service should do it for you...
Steve
rollback. The status message states that the rollback is
100% complete. The query analyzer connection is not there
anymore.
I cannot kill that spid with the kill command. Is there
any way to kill it without bouncing the server?"canaries" <anonymous@.discussions.microsoft.com> wrote in message
news:494701c47ff8$74a7d6b0$a401280a@.phx.gbl...
> I have a spid that was killed in the middle of a
> rollback. The status message states that the rollback is
> 100% complete. The query analyzer connection is not there
> anymore.
> I cannot kill that spid with the kill command. Is there
> any way to kill it without bouncing the server?
Assuming you're talking about bouncing the physical server, stopping and
restarting the mssqlserver service should do it for you...
Steve
Subscribe to:
Posts (Atom)