If it's always '*' that you want to remove, you could look at the REPLACE function.

CTRL-G

enter line number

or you can just double-click on the message in the results pane

BCP or SSIS would be your alternatives. For examples, just search SQL Server Books Online. You'll find plenty of them.

Or a bit more clean, I think:

SELECT SUM(A_Hours)

FROM #jobtran

WHERE IndCode IN ( 'CLN', 'SAF', 'SAT', 'SS', 'SUN', 'TA', 'TCR', 'TRN',

...

SELECT SUM(CASE WHEN IndCode IN ( 'CLN', 'SAF', 'SAT', 'SS', 'SUN', 'TA',

...

http://blogs.msdn.com/b/cindygross/archive/2009/10/23/considerations-for-installing-sql-server-on-vmware.aspx

gives some good pointers and additional links

Some things to look at:

networking: is prod on a different network than dev? What's the configuration and usage for each

server setup: how do the servers differ on the physical...

I hear you. Had to fight some of those battles myself. But make sure you're doing your due diligence and at least presenting the information to the sysadmins...

It could also be how you have your virtual server set up. Make sure you're following best practices as recommended by Microsoft and your VM vendor for SQL Server...

Means you may have a non-date value.

Try this: Select * from My Table where IsDate(MyColumn) = 0

(may not get you everything/anything but it's a good place to start)

Look up LIKE in books online. This is how the link comes up for me:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/581fb289-29f9-412b-869c-18d33a9e93d5.htm

select * from mytable where mycolumn LIKE '%db__name%'

if the column is text/ntext then us a...

We've just recently started using CommVault and run some DR testing scenarios. What we have found is that given our environment (VMWare servers. etc.) the best option for DR...

How is this any "simpler" than creating a simple data flow within SSIS, the tool that was designed to do this?

Seriously, you could have a whole, complete export done in...

If you have many views with many jpins, the amount in tembdb is quite likely significantly larger than the database size.

SQL Server will use all of the space that tempdb...

Awesome. Almost the solution I'd come up with.

Possible changes:

at start of script, get the initial character and the numeric split into their own variable rather than parsing...