@jim

If you are good at DOS commands, then you'll be a natural in PowerShell. It is almost backward-compatible but not quite. Yes, I've done many years of DOS...

Yes, you're right, it is definitely a mistake. As Gail has pointed out, it was done at a time when the site was suffering from the community's contributions being plagiarized...

[p]We were going to quote this to him next week![/p]

Oh yes, we're very much looking forward to seeing Steve again, and planning all sorts of things to try and...

Really? Surely, in western literature, changing the case of the letters of a word doesn't change its meaning.

I suspect that many DBAs have their own home-brewed solution to doing this, so that any changes from the released system can be instantly alerted to the DBA. I have...

Agreed. However, if the order in which you import the tables is important, or if you have any other conditions that need tweaking, then you can specify this too. You...

Steve is not making a ridiculous statement. If a project is initiated to make an Oracle-compatible database, the guys who designed it must have in mind the idea that it...

That sounds fine as long as the 'user', which the perl process connects to the database with, is assigned rights only to those SPs. That means that the Perl process...

If your database is supporting a public-facing service such as a website, it is likely to be vulnerable to malicious or mischievous attack. The attacker 'injects' SQL code into a...

Agreed. A minor point: In this case the slightly simpler...

EXECUTE('select * from ' + @dbname + '.dbo.sysfiles')

...might be as good

Like Sergiy, I'm rather wondering where to start. In addition to what he suggests, take out those hints for the time-being, and use a proper temporary table instead of using...

Here is a way of doing it without any temporary table, using a correlated subquery (probably slower!). I've used the original test data t make a simple test table. Note that...

I'd hate to think that anyone at Red-Gate should think that the views of 'alanrobinson' represent anything more than his own eccentric thoughts. The decision to give away a product...

Phil Factor's solution that I mentioned earlier in the thread uses the same approach as the one Joe Celco mentions that he uses. It is, as he says, far neater. The...