You can get the location of the characters you are looking for by using patindex

e.g.

declare @a varchar(10)

set @a = 'abcd a_b'

select patindex('%[ _]%', @a)

If you need to remove things,...

You could use something like

WITH DG

AS ( SELECT DATEDIFF(day,

...

Yes, you can. The following (absolutely...

Use

EXEC(@Records)

Regards,

Andras

Use "COLLATE Latin1_General_CI_AS" in places where you do things with strings of different collations. Like:

T2.Global_ID=T1.Global_GID COLLATE Latin1_General_CI_AS

This si the quickfix. To do it properly you should look at why you...

Loner (8/8/2008)

---

Since SQL Server 2008 is finally here, I wonder if I can install it along with SQL Server 2005.

BTW can anyone tell me what is the difference between 2005...

One solution is to use xp_cmdshell to copy the files to a network share (note that you need to enable xp_cmdshell, and your SQL Server service account must have permission...

If I understood you right, you can use a recursive query to get all the children of a particular node:

WITH closedMyTable ( Pri_ID, ReflID, ParentID )

...

Now, 2000 is probably when my solution above is actually relevant (2000 does not have a default trace).

On 2000 there is no with tableresult,...

Sandy (8/8/2008)

---

Andras,

Thanks, but my question was who drop my table instead of delete the data, Is DDL command logged in transaction table?

we can also achieve this by another command too...

Well, unless you were running a trace, it is not too easy to figure out who did...

ajaymistry_07 (8/8/2008)

---

Hi,

Is anybody know that do we have anything like Oracle's inbuilt primary key ROWID which is also accessible to database developer.

I...

If you have coding guidelines use those. However, some things cannot be checked automatically, for those: http://www.osnews.com/story/19266/WTFs_m

Regards,

Andras

Just a note that this limit seems to have stayed the same in SQL Server 2008, so upgrading to a newer version may not help here, and you should look...

blom0344 (8/8/2008)

---

One of our Cognos reports crashed this morning out of the blue due to an SQL failure.

The source database is SQL server 2000 and the message indicated that the...