We have an in house application that uses SQL to store support cases and
occassionally a user will complain that support cases were deleted.  
My guess is that someone might be deleting the records but I don't want to
tell her that unless I'm sure that's the case.

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?