Good note Steve ... about not trading one's soul. I would like to change the following though:

From: I would certainly rather make a million dollars ethically than a billion dollars...

Hi RF,

Have fun with this ..

Gone with the Wind (12 Month)

Beyond the Horizon (6 Month)

Hit the Road (3 Month)

In Car Park (1 Month)

Still Here (1 Week)

Cheers,

Osama

Hi,

Perhaps this is of help:

http://msdn2.microsoft.com/en-us/library/ms177418.aspx

Apparently it is not supported and one should use Database Mail instead.

Osama

Hi,

You can run one of those scripts that counts records in ALL tables before and immediately after a time when you know the third part application is at work. Although...

HI,

Try this ..

select DateAdd(year, 1, '29-feb-2008') expiryDate

Osama

Hi Mike,

Try creating a DTS package with an SQL Task that executes a stored procedure followed by an email task that send email with any attachment (for now not the...

Yes you can do that in DTS.

Create a new DTS and use the SQL Task for the SQL, email task for teh email, etc.

Osama

Hi Mike,

You can include it all in an SSIS package.

Osama

Thank you Andrew!

You have covered lots of details and at an excellent level.

Only the costs remain unexplored!

:ermm:

Osama

Thank you. Of course. I meant it at the end of the string. But I think with 200 million records, Full Text index is the way to go.

🙂

Osama

Hi,

So, as mentioned above, you may indeed find the best performance is to use the Ful Text Searching.

If you don't want to do that and want to explore things, at...

Hi,

If your text data is a maximum of 8000, then you may use varchar(8000) instead of text data type.

Osama

Hi,

May I suggest the following practical solution:

1. Educate the staff as to the importance of the first scan and the last scan for the day ie. reporting to work and...

Hi,

how about ...?

-----------------

drop table #ok

select 'Ok Good' ok1 into #ok

print 'Here we go'

select * from #ok

go

print 'Here we go again'

select * from #ok

go

print 'Here we go at last'

select * from...

Hi,

You seem to be able to identify which tables have the foreign keys ... Try to divide the job into several copies: First copy the tables that have NO FOREIGN...