Thanks again for y'r reply, but I already tried that without luck...

Thanks... but it is not 100% working for me! The constraint gets dropped, but when I try to recreate the column I get the message:

[font="Courier New"]ALTER TABLE systeem ALTER COLUMN...

I reply "OK Thanks" for all the people that give a suggestion. Tomorrow at the office I will try the various suggestions... so don'y know that now yet.

Ray

ok, thanks!!!

Ray

tHX!!!!!

Hi,

Thanks for your swift reply..... here's the output from your code:

TableNameIndex_NameAvg_Fragmentation_In_PercentFragment_CountAvg_Page_Space_Used_In_PercentRecord_CountAllow_Page_Locks

[dbo].[campagnes]PK_campagnes77,7777777777778878,2472695824067171

[dbo].[campagnes]PK_campagnes0NULL18,0627625401532171

[dbo].[campagnes]IX_campagnes012,28564368668149171

To be honest I would like to monitor everything 🙂

More specific for now: (history of) CPU utilisation and (history of) resources stored procedures used

We have lots of stored procedures running...

m

Thanks for the answers.... I understand now!

Thanks again!

As for your sql injection example: I will try it; but I must be able to get the return value of course.

As for your distance example: I have something...

Thanks for your reply. Actually I ran into another problem: the SELECT * FROM OpenQuery(linked_sql2005_servername , 'select master.dbo.fx_Traveltime(''2023RS'',''1161AE'',-120)' can't be made dynamically! Obviously I would have to change the parameters...

Hi Steve,

Thanks for your reply. We have Workgroup edition.... for the free Express edition I can understand that MS disables some functionality. I also understand that more expensive versions have...

A workaround I tried: create the package on the old SQL2005, and run it on the new SQL2008. Again no solution:

The SQL Server Execute Package Utility requires Integration Services to...

Thanks for all y'r input folks.... I'm pretty disappointed with MS. How can a company that makes the best databaseserver software let the users so down???

I'll dig into your hints...

Thanks for your reply!

You are very right about the upgrade from 32 to 64 bit. As for downloading the drivers: MS says that the 64-bit drivers are shipped with Server...