I'll call you Capt. Carp. from now on.

Feel free to do so, if it makes you happy

Once you cross the 4,000 posts...

Hi Veteran

Yes, I expect you to do so!!! This proc is nice, isn't it? (maybe because of this it's undocumented)

if that doesn't work, then I'll need to see the whole query to find the problem.

Should be the best way to get a quick and good response.

You can't stop someone with SA privileges from viewing the data. You can however encrypt it. Actually if you don't trust your DBA's (they only should be SA) you have...

Now that's disappointing, Remi!

I thought it to be more tricky, thrilling and exciting.

See, if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

I've only heard it this far from procedures and functions. AFAIK, loses a procedure this status once it is changed after being marked as system object, so that it needs...

Oh, if it is that what Steve mentioned, I think this will help:

SELECT

 sfilegrp.groupid AS GroupID

 , SUBSTRING(sfilegrp.groupname,1,30) AS FilegroupName

 , FILENAME

 , SUBSTRING(sobj.name,1,50) AS ObjectName

FROM

 SYSOBJECTS sobj

INNER JOIN

 SYSINDEXES si

ON

 sobj.id = si.id

 INNER...

Okay, next time we have a sophisticated discussion at the lowlands of a language, it should be in German. I'll stick to my school english and avoid slang.

Hm, I can't find this in my dictionary. What does "bummed out" mean?

WHERE CardNumber LIKE %PartOfCardNumber%

With a search condition like that, no index is terribly useful.

To add to Remi, what about a computed column? You...

You might have a look at INFORMATION_SCHEMA.TABLES in BOL.

Actually if I have my way (and assuming this is for an OLTP database server, I would use RAID1 for the log and RAID 10 for the data.

See, if...

Yes, the set-based way for the median. But have a close look here http://groups.google.com/groups?hl=de&lr=&th=c8786f747b6cf92d&rnum=1 , compare the execution plans for both alternatives (TOP 50 blah blah and the solution in...

??? What...