have you tried the following.

1. create a Rule

2. then create a user defined data type(UDT) then associate the rule      previously created with the  UDT

3. create the table instead of using...

http://www.databasejournal.com/features/mssql/archives.php

archive goodies, dig-in and all sort of tips & tricks 

Hi mike, Does anyone know which system T-SQL uses?

You can try the following experiment to test which type it follows:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fn_true]') and xtype...

hi carl,

references:

(nice reference)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_06112004.asp

(examples using collation - is an MVP thanks to umachandar)

http://www.umachandar.com/technical/SQL2000Scripts/Main10.htm 

yes, you are right about the Danish Collation, collation (in a highlevel view) is kind of a...

an addition to this just in case you want to manipulate the data

--DROP TABLE #QUERY

CREATE TABLE #QUERY 

(

 TABLE_QUALIFIER VARCHAR(100) NULL,

 TABLE_OWNER varchar(100) NULL,

 TABLE_NAME varchar(100) NULL,

 TABLE_TYPE varchar(100) NULL,

 REMARKS VARCHAR(100) NULL

)

GO

INSERT INTO...

i would go for what cris has done, pretty nifty, but here are other options using sp, this is pretty nice sp. look it up msdn BOL

use northwind

go

sp_tables null,dbo, null,...

try something like this, now it really depends on how your table is built, this is just my assumption and to be taken as is without any warrantly that i...

ON THE PREMISE THAT

The user can ONLY pick ONE of those parameters.

I would re-create my query as follows: (parameter transparency, up to the sp to decide parameter object type)

CREATE PROCEDURE DBO.GETUSERS

@POLYMORP...

if the tables are in a Referential Integrity with each other, just deleting from the parent table, will casade the delete to the parent & child table(s). just issue one delete command....

Example

Use Northwind

go

DECLARE @Results TABLE

(

 RowNum int IDENTITY (1,1),

 CustomerID varchar(20),

 PostalCode varchar(30)

)

INSERT INTO @Results (CustomerID, PostalCode)

 SELECT CustomerID, PostalCode

 FROM customers ORDER BY PostalCode

SELECT * FROM @Results

try the following, hope this helps

03/31/2005  05:14 PM    <DIR>          bak

05/02/2005  05:26 PM    <DIR>          DataFiles

02/16/2005  10:46 AM    <DIR>          DFO

05/09/2005  04:27 PM    <DIR>          dnd_reports

03/11/2005  03:17 PM    <DIR>          FTPServer

02/03/2005  05:50 PM    <DIR>          photo_scratch

05/11/2005  09:15 AM    <DIR>          SISPHOTOS

04/01/2005 ...

hi carl,

>> Also is this behavior avoidable?

yes, it all has to do with Collation, you must be aware

of your data and what type of restrictions you want

performed...

i just want to understand your environment.

btw: have you run perfmon.exe and include the db counters. this is as far as i know about this topic and as far as...

what type of mirror configuration are you running? duplex-mode where in the two physical disks are connected to two different controllers or are you using standard mirroring when two physical...

using raid on server?