Nobody?! I had to further tweak that code because it was moreso a SELECTed column in an INSERT VALUES clause. But that's the gyst of it.

First off, here's some data that I saw:

Anaheim CA

Los Angeles, C.A.

San Diego,C.A. (notice the lack of space between the comma and the state abbr)

Tampa Bay, F...

So it ended up being even worse than originally thought of. The data was even messier than that. In some entries, the zip code was appended to the...

What do you mean, "run the index"? Im guessing you're talking about a rebuild/reorganize. Yes, that should be part of your maintenance plan to defrag the index. What I was...

All indexes get written to (provided it isn't ignored with a filtered index's where clause). That is why you need to really plan, because additional indexes lead to more overhead...

Depending on your definition and scope of "reindex", it could mean one of two things. A REBUILD or a REORGANIZE. They are very different results with very different...

Go into the properties of the database user. Go into securables and inside there, you should be able to view the stored procedure object. If you can't, browse...

http://msdn.microsoft.com/en-us/library/ms190794.aspx

Please reference the above link if you are just concerned with transporting the database through attaching.

Yes, you can just attach the database files to another server. So you aren't concerned with the existing server's lack of SQL Server footprint? Not sure what you're...

Your error is telling you it can't find SSMS. And if you don't have any MSSQLSERVER services then it seems as though all reminents of SQL Server are no...

I guess what I have a hard time understanding with people saying they would never touch it again is, do you not enjoy sql? Does it not make your...

I would definitely continue with SQL. Often times we get engrosed in the day-to-day. But I think 98% of us first emerged in the SQL scene based on...