Have you tried CSTR()?

CSV has it as just text, the driver may see it differently, but from a text file, I'm not sure CAST or CONVERT work. I'd deal with...

There are a few utilities as well that can help here. We had a press release about SQL Digger last week, which does searching.

You can put them all in one transaction, but you could generate a huge log on the alters as many of them are rename table, create new table, load data.

I'd...

There must be some sort of job or process that is running. Or someone is manually executing the jobs. You could run profiler and trap just those backup events. That...

The log is used just like a database log. It stores information about the transactions that are in use. Since there isn't really a recovery when you restart, the tempdb...

Agree with Brian that this is confusing. Does the existing software run on SQL Server, but you want a second database? Or is it running on other database software?

I've had...

http://www.homepower.com/index.cfm

http://www.homesteadtechnology.com/power/

Sorry, it's not a choice. Those are good points, but the intention is to see if you know which tool to use. Launching EM is a bit of a giveaway...

I think he's referring to the US missing the Olympics last year. That's despite winning in 2000.

It was great, Rockies down 2 in...

Errrrrrr.

You can run SQL Server on Windows on Linux.

I wish they'd port it.

And I thought no one would fooled. I actually wrote 3 different ones and Andy and Brian liked this one the best, so thank them. You could have been reading...

So you have the db definition in master, but nothing else? If DROP DATABASE doesn't work, then I'd allow system table updates, reconfigure with override and delete directly from sysdatabases.

Joe,

It's possible, but the main complaint with the digital world is the ease of stripping that stuff out. I think there still could be some type of advertising, but no...

Too short, yikes it took awhile to try and easily summarize things.

I'd love to delve in deeper, and maybe I will, but if anyone wants to dive into a specific...

Dan,

That's an interesting point of view. I hadn't considered the "tighter control" aspect. I think after watching programmers sneak too much stuff into production, I hate the idea of them...