The chObjOwner mentioned above is very useful.  It is from the msft knowledge base and builds a script that changes all objects for a given user...

I once saw some software that automated the functions of the excel spreadsheet in this article, but can't find it again.  Anyone familiar with it.

I also need the same type...

I realized that after I posted.  The problem is that for the 1 digit hours, the right(,7) selects the space between the year and the time so you get '0...

Thanks for the replies.  That is helpful.  The AM/PM doesn't use a space after the time, so I revised as below.  Not sure why the '0' + was added since...

Both are good examples of some scripts.  Does anyone have an addition to the UDF_CONVERTDATE that would add option 7 that would allow returning just the time?  Maybe 7 would...

the sp_refreshview works.  You can also use QA to resecript the dependent view using "ALTER" and rerun.  SQL seems to store column orders as the reference in the view, so...

One additional comment on this process.  I still find the query tools in EM awkward and wanted to make sure people know that you can follow the same process in...

Redgate is a great product.  I have been using it for 2 years and the latest version is a great improvement over past versions.  No learning curve.  Highly recommend it.

I have seen people ask how to convert statements to usable UDFs, so here is this one that I converted.

ALTER FUNCTION dbo.Trim_Field

 (

  @Value NVARCHAR(3000)

  ,@Trim_Characters NVARCHAR(10) = ' '

  ,@Starting_Characters NVARCHAR(10) = ''

&nbsp

Here is a sample syntax of a function I have that looks for identical matches on the org and addresss fields.

Downsides of these functions are that you have to use...

It seems that Aaron's answer might be what you are looking for, to turn a list of comma separated values into a table of ID values which can then be...

It seems like the Object Search (F4) from Query Analyzer accomplishes the same goal with a nice UI for flexible searching?

Here is the link to a dynamic cross tab query builder that works close to the Access Cross Tab.

http://www.johnmacintyre.ca/codespct.asp

Thanks to Bob Monahon for...

I would guess Antares686 is on track.  I'd try adding the name, dept and id from the "b" to help figure out which records...

The inability to use select distinct and search using LIKE seem like major limitations to the text/ntext fields.

This was a great article, but the solutions seem like some major pains...