I have the following stored procedure:
create procedure MyNumericTestProc
(
   @param1 numeric(13,2) output

does any body know, how to send email through SQL server.
any setups(out look express etc.) needed for this.
any code for this?
please let me know, if any body knows.

I'm getting a session timeout from time to time whilst working on a web
application that I have on my machine. Is there a way to extend or disable
the connection timeout? Would it be done from the IIS manager or from within
the global.asa file, or both?

I have an app which using Access front end and SQL server backend and ODBC
connection.
My app may access the SQL server backend database without ODBC
configuration.

If anyone knows the answer to this I’d me greatly appreciative.
I am not on a domain.
I have SQL Server sitting on computer A
Computer A has:

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just

I am having difficulty registering to a newly installed server.
The server resides in a remote location.  
The server is using mixed mode.  I set a user up on the server named
SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL with

The problem I got is when I am using the ResultSet to loop through the
result rows, the JDBC driver keeps writing each row's data to a tmp
file at /Tomcat/temp/ After the loop is finished, I do a
"ResultSet.close();". After that, the content in that tmp file is

I am getting the following errors when I try to connect to SQL from a SQL
server:
Connection Failed.
SQL State '01000'

I'm an old C/C++ programmer, but new to SQL and MS SQL Server.
I'm writing an application in C++/MFC (6.0) that happens to need some access
to data from an SQL Server.  When installing Visual C++, it has option for
installing database components and ODBC Drivers, which I did a while ...

I have been using the NotesSQL driver to connect to a Domino server to pull
data, with a Notes ID that didn not require a password.
I was using a UDL connection to set up the ODBC connection details.
However, a Domino server change now requires password authentication, having

Hi,
 My MS Access application needs to connect to a SQL server via a system
dsn. However, I keep getting the error 18456 - Login failed for user 'xxxx'.
The surprising bit is I am able to use the same password and user id and

1.  Using the ODBC tool I created System DSN (SysbaseDSN) and the “Test
Connect”  established a connection … after prompting for the UserName and PW.
2.  Ran the following from Query Analyzer
USE MASTER

We have a program using sqlserver7, bde 5.01, msde, which works fine on the
98se machines we have connecting to ntserver4, however we got a new xp pro
machine with sp2, I have mapped the exe to the network and it goes to a login
screen, where it then fails to connect to the ...

i am trying to connect to sql server in a remote database by using windows
authentication. I tried to connect using php and cgi. The apache service
under which i am running my cgi or php is under localsystem account. If i
change it to administrator account, i am able to connect ...