I'm no expert in permission so if I'm wrong please jump in and save my ass .

I think he must be the owner of...

This syntaxe seems to accomplish what you ar trying to do :

Select *

FROM dbo.Problemes

WHERE CONTAINS(TitreProbleme, ' "te*" ')

I'm shooting in the dark here... but have you tried destroying the connection object before running sp_who2?

Maybe that the connection is still there, but simply sleeping untill you actually run...

Hmm, besides making 2 separate sql statements and running both at the same time I don't think it's possible. You might maybe run a union on those both statement...

The UDF is more elegant, faster and has the added advantage of not building a global ##temp table which can cause big locking problems.

No you have to use the function. You have to declare a variable to ...

CREATE FUNCTION dbo.fnGetChilds (@Parent_ID as varchar(10))

RETURNS varchar(4000)

AS

Declare @Items as varchar(4000)

set @Items = ''

Select @Items = @Items + CAST(Child_id as varchar(10)) + ', ' from dbo.tblChild where Parent_ID = @Parent_ID

SET @Items...

You can use USER_NAME() and few other like this one (bol for details) to get the info about whose doing this stuff.

Also might I suggest you put your code in...

You'll have to do some work because there's no premade report. But this can get you started :

Select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS

Select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Those views are all located...

I second AJ's opinion on this... You can't have integretity and don't have it at the same time. You could use AJ's idea or you could also create...

I've never actually done this but a view seems to be pretty easy to implement :

Select col1, col2, id from dbo.TableX where user_id =

dbo.FnTranslateUNameToUid(user_name())

where FnTranslateUNameToUid would simply translate...

CREATE TABLE [Payes] (

[PkPaye] [int] IDENTITY (1, 1) NOT NULL ,

[FkEmploye] [int] NOT NULL ,

...

CONSTRAINT [PK_Payes] PRIMARY KEY CLUSTERED

(

[PkPaye]

) ON [PRIMARY],

CONSTRAINT [FK_Payes_DatesDebutsSemaines] FOREIGN KEY

(

[FkSemaine]

) REFERENCES [DatesDebutsSemaines]...

Yup and it would be faster than my version since only 1 update is ran.

Exactly my point ... my solution doesn't have this limit.

I've ran this on my test data and it returns incorrect results :

John Doe

JaneDoe

John

AFreakNameWithLotsOfNames

becomes

J A N E D O E

J O H N

A F R E A K N...