Also keep in mind that if you have ids that go over 9, you can run into this situation :

4 & 44 = 444

44 & 4 = 444

If you...

Yes it can happen, especially if those 2 ids are in any numeric format.

What are the base datatypes of those columns?

What are you trying to accomplish with the calculated field?

You...

The only remotly close problem I had to yours is when the user didn't have permission to execute the procedure or function or whatever else. I got a general...

You got me there... I have no clue of what could be causing this.

Any chance you can post the code along with DDL and sample data so that we can...

Can you imagine if the comment was in the where condition instead of the select???

Angry boss to DBA >> why the heck didn't you test your sp before production, the...

I remember that in 2000, when there were text or image columns, we had to do a DBCC updateusage IIRC to have that table size updated.

If I'm wrong,...

Are you calling both sps from SSMS?

I know that results to grid will screw up the formating, but since you say you are printing that is most likely not the...

do a search for common table expressions (CTE).

I don't sql installed here to do a demo for you. But you'll find plenty of help on this site... and I'm...

Triggers on system objects were never safe... and they are 100% forbidden 2005 forward.

That's why DDL triggers were created.

I have never done that but I'm sure BOLs can point you...

As safer version would be this :

if object_id('dbo.Clients', 'U') > 0

PRINT 'drop it'

if object_id('dbo.usp_DeleteType_appareilBypkType', 'P') > 0

PRINT 'drop it'

note that the schema and object types are mentionned... there can...

Michael Earl (9/16/2008)

---

Try this:

[font="Courier New"]DECLARE @v-2 AS NVARCHAR(MAX)

SELECT TOP 10000 @v-2 = coalesce(@v + CAST(N', ' AS NVARCHAR(MAX)) + CAST(M1.Name AS NVARCHAR(MAX)), CAST(M1.Name AS NVARCHAR(MAX)) FROM master.Sys.Columns M1 CROSS JOIN...

In my case, there was nothing patches wise...

Check to see if there's a server trigger that disables that login.

You can also lookup alter login. Maybe that'll spark you on the right direction.

From my quick research, it...

I happenned to me all the time in EM.

The only I found around that was to close EM, open again, then I could hit the column and the sort would...

Also you can concatenate without using the cursor like this :

DECLARE @v-2 AS NVARCHAR(MAX)

SELECT TOP 10000 @v-2 = coalesce(@v + ', ' + M1.Name, M1.Name) FROM master.Sys.Columns M1 CROSS...