I have web forms on my site that store data in an sql dbase.  
I have a DATE column that i would like to store each date, that each request
was submitted.  The only function that i found to automatically populate that
field was TIMESTAMP...  any ideas on how i can autopopulate ...

I am a beginner on JDBC with SQL Server 2005.  I tried to write a
simple program to connect to the SQL Server 2005 that I installed on my
machine (localhost).   Here is the program:
import java.sql.*;

I have a question regarding the XML support in SQL Server 2005 and the
new Microsoft JDBC driver. I hope to get XML from SQL Server to do
XSLT-processing at the web-tier, but lack some sample code of how get
XML through JDBC when I do a SELECT .... FOR XML.

What is the maximum number of active connections in SS2005 on Windows
2003 DC?
Cheers
SQLCatZ

I have installed SQL 2005 and just done a normal install. I have opened
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider ...

In a windows service (.NET) on unplugging network cable it use to loose
connection to oracle database.
Once the network connection was up it was found that the service was unable
to restore its connection to oracle database.

I am rying to retrieve the data from the DBCC SHOW_STATISTICS command.  I am
getting different behavior between 2000 and 2005.  I run the following
program, and you can see the differences.  I am getting three results sets
using the 2000 driver against the 2000 database.  I am ...

We have been running a web application in Windows Server 2003 and SQL
Server 2000 both located on different machines. It was working fine
until a week ago. There were some security patches that were installed
from Microsoft site. After that we get SQL Server does not exist/Access

I am using the release version of SQL 2005 JDBC driver.
The JDBC driver help says that there is a connection property called
selectMethod, which sets whether result sets are directly read into memory or
a cursor is used.  The direct method is definitely faster for me, but it will

In Query Analyzer I am creating a Select statement using temp tables.  For a
simple example:
Select abc.def into #tmptable from ABCTable.
If I make changes to the query and then rerun it, it tells me that the

Please help! Insert a picture in an MS SQL Server table
How can u insert a picture an an image field in SQL server table? Is it
possible from SQL server tools or other tools, programming?

Sql 2k, server has four dual-core processors.  We're encountering an error
every 200-400 inserts that we are attempting to insert a duplicate row.  The
table is simple:
BrokenIdentity

Hi
I am new to sql server. Currently i need to write a code to connect to SQL
Server 7.0 and call a stored procedure in the database through JDBC.
I have got this code which is for connecting to SQL Server 2000. But i dont

Is it possible to connect to a user instance of a SQL Server 2005 Express
database via the JDBC driver?

    I'm having a problem in a customer's netwok:
We have an application that connects to a SQL Server from multiple
terminals via ODBC, but sometimes (I don't know why) the server stops
responding to new connections. The terminals that already had an open