Fait une recherche dans Books Online.

ALTER DATABASE DbName WITH MOVE

Je me souviens plus du nom exact de l'option qui suit (et j'ai pas sql server ici)... ça va prendre le...

... and why did you decide the create such a column in the DB / select statement?

will.rowland (9/16/2008)

---

Good point. I didn't know if actual solicitations were allowed, especially since I can't guarantee this will turn into an actual job offer, but...

We are located in Austin,...

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...