Can someone provide me with a sample script of how to do a check
constraint with an If statement?  If thats possible.  For example, if
there are 2 columns, track and collector.  I would need to check if
the collector was 'abc' then the tracking number must be like 'abc%'.

I have a java application that is using hibernate to connect to sql server
2008.  The application is using a connection pool of 25 sql server database
connections.  Each connection is using the same sql login that is created
for the application.

Can someone supply a vb.net code snippet to enumerate through a DTS package's
connection properties?  I have been told it can be done, and while I am a
vb.net novice I am willing to study the sample and learn how to extend it/
Thanks,

Using SQL Server 2005.
According to BOL :
http://msdn.microsoft.com/en-us/library/ms181271(SQL.90).aspx
the BREAK keyword :   "Exits the innermost loop in a WHILE or IF.ELSE

I need to run a group by query on the RunDate column.  What is the syntax to
only group on the date portion of the date value?  I need to order these
dates DESC.  Here is what I tried that did not perform the ordering correctly:
select convert(char(10), rundate, 101), count(*) cnt ...

I have a script that I run on some of our servers to determine if the server
is in mixed mode or not and if it is not then put it into mixed mode.
The script works like this,
Read the "loginMode" sub key of the microsoft sql server registry hive.

I would like to call a stored procedure from within a storec procedure.
  EXEC stored_proc_name @col1 = 'abc', @col2 =' xyz'
stored_proc_name returns a single row containing a single int column. I would like to capture this value and use it to
perform a subsequent stored procedure. ...

I've set up a pair of sql servers (and a witness server) for database
mirroring. I'm using the .net sql client with a connection string that
specifies one server as the normal data source, and the other as the failover
partner. To test failover, I wrote a small .NET app that ...

Using sql 08 I need to convert a string to a uniqueidentifer which is
failing.  Please advise how I can do this convertion.  Thanks.
DECLARE
@id uniqueidentifier,

I created a vb.net CLR function that I'm going to use to search for patterns
in a TEXT data type in SQL 2005. It appeared to be working fine but I'm
concerned that I'm not getting the entire text. When I deploy the function
in VB.net and then look at it in SQL, it's got the input ...

Why doesn't this return any results in SQL 2005?
Create Table Table1
(Column1 NVarchar(20), Column2 NVarchar(20))
Create Table Table2

SQL2000
Let's say I am querying a table where I need to find records that have
fielda equal to several different values.  For example:
select * from table where fielda = value1 OR fielda = value2 OR fieldA =

I am looking at the schema for a table that I need to create at SQL Server
2005.
I believe the original data comes from AS400.
How do I indicate "(10)" in the regular "datetime" datatype?

ok. I have come into a project mid stream and want to set up up some indexes
on the tables so that it makes it easier for the resources on the server. Is
there any place in within SQL Server that is queryable that says this field
is accessed 40000 times, and this field is ...

I'v a tbale which has a column of type uniqueidentifier. So there is also a
contraint "UNIQUE" which makes it difficult to drop the column. I can not
drop the column or the constraint since they depend one on another.
So how to drop a column of type uniqueidentifier?