how do you designate a foreign key in T-SQL?
The query has a syntax error on the foreign key.
thanks,
CREATE TABLE[INTERNAL_CAR](

I have 3 columns in a table that I want to require at least one of them to
contain data (not null and not empty string).  What's the best way to
accomplish this?

I have a table called Active1
Columns:
JobID, JobstatusID, activeJobid, StatusDate, Timediff.
Sample Data:

Is the description below true?
Anybody get the database file (.mdf) of SQLServer Express 2005, he can
attach the database file to the SSMSEE(SQL Server Management Studio Express
Edition ) installed in another Windows XP , and get the data  in the

I have stored procedure that performs some data manipulation and some actions
on file system (copying and moving files...).
1 - Is there a method to achieve this other than using xp_cmdshell in T-Sql ?
2 - If I use xp_cmdshell, how can a user who has no sysadmin role execute

when we create a databse and say we choose to allow it to grow just 10% i
was wondering whats the use of that option ?
i mean if data that was submitied to the database was biger than 10% what
will happen it wont be saved or what ?

I need to write an SP that returns data depending on the parameters
sent. These include
1) Date where search can be <date1 or >date2 or between date1 and
date2 or exclude date from search criteria

I am running enterprise edition of SQL 2000. What I am attempting to
do is design a query that will check our casino database for people
who meet certain criteria, i.e. had game play during a certain date
range and had a theoretical win of a certain range as well.

I use SqlServer 2005 Express with ASP.NET to develop web application, then
Install the web application in my windows XP. I have a question about
security:
When someone copy the .mdb file and attach it to his computer, he can get

EventID: 26040
"Server TCP provider has stopped listening on port [ 1433 ] due to a
failure. Error: 0x2736, state: 2. The server will automatically attempt to
reestablish listening."

         Returning output parameter string of up to 8000 bytes from
a
COM object works
using varchar(8000).  But, I get the following message if I use

Hi
I have a large database (450GB). I want to take a backup. On this server I
only have 200 GB space available. I have about 600 GB on another server
available.

I'm trying to bulk copy a table of size ~30GiB via JDBC. Because of plain
SELECT exhausts available JVM memory, I decided to use a cursor instead. But
as I understand from SQL Server documentation, there isn't such a command as
"fetch next N rows". (Similar to "FETCH FORWARD ...

On a SQL 2000 Server is it possible to report when and how long the
autogrowth events took for a database?

I've been trying to kind of reverse engineer SISS bulk loading
functionality without making a dtsx file. Watching the execution in
profiler when it gets to the actual bulk insert point in the job the
command comes up encrypted. I'm assuming it's bcp but I'm not finding