Recent content by kim1

Hi, I have the following error message when I run: exec @intres = sp_OACreate 'CDO.Message', @intMsg OUTPUT Error: Source: ODSOLE Extended Procedure Description: The specified module could not be found. Does anyone has an idea ? Thank you very much for your help Kim Kim

Carla, I think you can add an application role but not a database role to a Server Role because the application role is at the server level (if I am not wrong.) Kim Kim

Hi James, I have a database roll that has some users in it and sometimes I need those users to have sysadmin priviledge. Is there anyway to set so I don't have to set manually each sql login to have sysadmin? Thank you for your help. Kim Kim

Hi everyone, Is it possible to add a Database Role to a Server Role? Kim Kim

Hi, I have a problem setting my sqlagent proxy account. I logging in as Administrator of the domain on my SQL Server and I try to set my proxy account to be the same account, but it keeps telling an error. Error executing extended stored procedure: Specified user can not login. Any ideas ...

Hy guys, Does DTS has an option to overwrite the file when I want to Export data from a Table to an Excel File. I try to run it every night, and DTS adds at the bottom of the file, it does not overwrite it. Is there anything I can do? thanks for your help. Kim Kim

Hi guys, Is there any system table I can request to tell me if a columns is part of a primary key and Unique Key? Table1 - ColA (PK) - ColB (PK) - ColC ColA and ColB are Primary Keys I have a loop that goes throught each column and I want to know if it is part of a primary key? or Unique...

Yes, There is no bug fix related to this. It is really amazing. My SP is like the following: CREATE PROC Test AS Select 'A' Select 'B' When I use the DTS to transfer this SP It comes out: CREATE PROC Test AS Select 'A' Select 'B' Thank you very much. Kim

Yes, I use SQL server 2000 Service Pack 2, both server have the identical installation. The Tabulation remains the same, only the whitespace line that are removed. Thanks Kim

Hi guys, When I transfer object between SQL Server, my stored procedure that have blank line were deleted during the transfer. Is there any way I can avoid this deletion. I want to keep my blank line in my SP. Thank you very much for your help Kim Kim

Hi Terry, Is there any way we can prevent the CALLER (it could be a ADODB.Command or from ASP page) FROM SEEING THE ERROR if there is an error generated from SQL Server? thanks Kim

Hi DC, I want to prevent the caller from seeing the error if there is an error. example. ADO calls a SP that have 4 inserts statement the 3e failed, I want the 4e inserts to execute and ADO not knowing that there is an error. Is is possible. Thank you so much. Kim

Hi guys, Is there a way to tell SQL Server not sending an error message if there is an Error? Thanks Kim

When I install VSS Server, I cannot see the option where I have to check for the Integration with Other Tools. I install the Server Installation and it seems that my InterDev doesn't integrate well with VSS. Any ideas? Thank you for your help. Kim Kim

Thank you very much for your confirmation Terry. Kim