Proof read and spell check please before posting....

In SSMS, right click on the maintenance plan and click modify.

i want to alter the...

Did you get this fixed? Make sure all the same DLL Files are located in the bin dir of the OLAP install folder..

Default:

"C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin\"

-- compare working install against...

change the type of your size column to bigint or cast(size as bigint) on the column.

If you're going to post, you need to at least spell check and proof read my friend....

I think you want this:

SELECT B.SchemeCode ...

Just check the system requirements on the download page for SQL 2005 SP3.

I believe Windows 2000 SP4 is in the list.

Yes, search google for something along the lines of "SQL Server Stored Procedure Security" and you will find lots of articles on best practices with SP's and security.

Change

To

You hit a case sensitive server.

For your reference, you can verify with what your server collation is set...

For 1- grab process explorer (http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx) and see what process is eating CPU, and see if it is SQL server is creating the spikes.

At first glance I see this, but it doesnt match your error message

select @@servername as 'InstName', sum(a.size) as 'Space Aloc (mb)', sum(a.used) as 'Space Used (mb)', sum(a.size)-sum(a.used) as 'Free Space...

I'm 90% sure Uninstall Enterprise/Install Standard is only option.

edition differences:

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

http://technet.microsoft.com/en-ca/library/cc966395.aspx

This is a pretty good explanation of how to implement security.

If I needed to do this, I would just restrict access to the table to all users but...

Do you have the full error message? Is the output saved to a report file?

Check your sql server error logs... you might see something there.

and also run a dbcc...

All depends on how much time you have to spend on it I suppose 🙂

I would feel out the situation and see if creating regular data copies to tables elsewhere...

I wouldn't use SQL Server to do this. Just setup a windows scheduler task on the web server to kill the files on your schedule (if needed). And...

I want col2 to be masked i.e. i dont want the column to be in clear text instead look like an hashed out column but when you perform a select...