Sadly, not many descisions makers I've encountered fully support complete implemetation of DRI. In most cases they seem intimidated by it and will come up with some lame excuse not to implement it...

Hi Clint and Ken

Thanks for your replies. I was looking to export specific items to file, without going through the system catalogue. Clint check http://msdn2.microsoft.com/en-us/library/ms187997.aspx for sql 2000 mappings to...

The other thing you can try is to drop the rollback segment: DROP ROLLBACK SEGMENT R15;

According to OTN you can only drop it if it's offline (check the data dictionary...

Hi Ryan

I'm no Oracle expert but the first thing I thought of was that you may have an uncommitted rollback segment prohibiting the import.

Here's what otn has to say:

Before...

Shocking situation to be in Steve, I dare say you have handled it admirably, keep up the good work!

We all have to keep our eyes open for plagorism. I also...

found something that may be of interest

@@servername returns data from sysservers.srvname, populated at the time of the instance installation.

host_name() executes sp_who to return sysprocesses.hostname. sysprocesses stores process information, hostname is used for...

LOL

Nice one Frank

I was using xp_cmdshell 'ipconfig' (which is a bit faster) to check the general ip settings but 'ping ' + HOST_NAME() is perhaps easier to hack.

Hi Carl

What data type is @ID and why do you have @ID = 0 (do you mean "OR T2.ID = 0" ?) Have you tried to run the query without the...

Most interesting.

One would think that the best people to prevent fraud and misuse of data would be the ones who designed or maintained that system.

Although none of us are infalliable...

Well one can only speculate that he sold out... I have this mental picture of someone whispering in his ear one grogy night "... just imagine how much money we'll,...

Great article

Obviously we'd all like to see it kept free and the ads aren't that obtrusive.

Sometimes I answer posts cause it gives me something to do but most of all...

Great discussion guys

Indexes and stats are often regarded as "the thing that should just work" but in reality they do need a bit...

Hi Bimal

Have you checked to see if the dll is actually loaded with sp_helpextendedproc ?

Also, a shot in the dark, I noticed that there is no reference to dropping the...

Hi Olga

There was a typo (a mistake in the typing of that command).

It should be:

exec sp_configure allow, 1   -- 1=Allow 0=Prevent

reconfigure with override