Drop column on compatibility level 65

I have a database converted from sybase to SQL Server and the application
requires the database compatibility level 65.
I am trying to drop a column by Enterprise Manager and by Query Analyser
(Alter table xxx drop column yyy). Both came back with error "Incorrect
syntax". It is because drop column do not support on database compatibility
level 65.
Can you please advise what is another alternative way ?Unfortunately you are unable to use DROP TABLE as part of an ALTER TABLE
command in SQL Server 6.5, hence are unable to do this using SQL Server 6.5
compatibility mode. In order to drop a column in SQL Server 6.5
compatibility mode you will need to follow the steps below:
- Script the Permissions of the table you wish to drop the column from
- Create a New table without the column you want to drop
- Move the data from the Original table to the New table
- Drop the Original table
- Rename the New table to the Original table name (sp_rename)
- Re-Apply the Permissions to the table
- Run sp_recompile for the table
- Peter Ward
WARDY IT Solutions
"Johnny" wrote:
> I have a database converted from sybase to SQL Server and the application
> requires the database compatibility level 65.
> I am trying to drop a column by Enterprise Manager and by Query Analyser
> (Alter table xxx drop column yyy). Both came back with error "Incorrect
> syntax". It is because drop column do not support on database compatibility
> level 65.
> Can you please advise what is another alternative way ?
>

Drill-through report passing credentials

Is it possible to drill through to a report that does not have embeded credentials? Every time I link from a report that requires a sql username and password to run to another report that requires the same permissions, I recieve an error message stating: "One

or more data sources is missing credentials" Is there a way to make RS prompt the end user to re-enter credentials after drilling through to the next report, or to make the credentials entered to access the first report pass through to the second report? The drilling through works perfectally from within visual studio, but fails to work when the report is viewed in IE.Did you ever fix this problem? I am having the same problem. It works fine when run in Visual Studio but then on the server it does not prompt again for the credentials when drilling through to the next report. My email is scriptjunk3@.hotmail.com. If you did fix this or get an answer, please let me know here or at my email. Thank you.

Drill-through report passing credentials

Is it possible to drill through to a report that does not have embeded credentials? Every time I link from a report that requires a sql username and password to run to another report that requires the same permissions, I recieve an error message stating: "One or more data sources is missing credentials" Is there a way to make RS prompt the end user to re-enter credentials after drilling through to the next report, or to make the credentials entered to access the first report pass through to the second report? The drilling through works perfectally from within visual studio, but fails to work when the report is viewed in IE.
Did you ever fix this problem? I am having the same problem. It works fine when run in Visual Studio but then on the server it does not prompt again for the credentials when drilling through to the next report. My email is scriptjunk3@.hotmail.com. If you did fix this or get an answer, please let me know here or at my email. Thank you.