Search results for query: *

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

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...

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 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

Hi guys, Can we have the modification date of a stored procedure? I would like to list all the stored procedure that have been modified since a certain date. Thank you for your help. Kim

Hi, Is it possible to retrieve my NT Username of my Window NT when I connect with a SQL Login in SQL Server? Thanks for your help. Kim Kim

Hi, Anyone knows how to script only all triggers in SQL server? Thank you very much. Kim

Hi, I have integrated Stored procedures (SQL server 7) into InterDev, but I don't see the Lock Icon beside the Stored procedures. I cannot see the option Check Out when I right click on it. When I open the Stored procedure folder, it asks me my VSS login ID. Any ideas? Thanks your for your...

Hi, Is it possible to convert SQL Server 2000 database back to 7.0? Thanks for your help. Kim Kim

Hi Guys, I want to do this TableA (ColA, ColB, ColC, ColD) Primary key: ColA, ColB I want (ColC + ColD) a unique value Do I have to create an index on ColC+ColD as Unique value in order to have a unique value for those 2 fields which are not part of the primary key? Thank you very much for...

Hello, I have a database in SQL Server, and trying to link the with InterDev for Stored procedures, it doesn't show me the Add to Source Control option if I right-click. Any ideas? Kim

Hi, I heard that between Distinct and Group By, the Distinct is faster, it is right? If yes, why? Anyone has an idea? Kim Kim

I have create a Database Project in InterDev. When I right-click on the connection to Add to Source Control, I enter the database location. I have this error: Error: --------------------------- Microsoft Development Environment --------------------------- ADO error: [Microsoft][ODBC SQL Server...

Hi, Can 2 users create temporary tables at the same time? It is true that we are locking the tempdb database each time we create temporary table? Thank for your help. Kim

I have create a Database Project in InterDev. When I right-click on the connection to Add to Source Control, I enter the database location. I have this error: Error: --------------------------- Microsoft Development Environment --------------------------- ADO error: [Microsoft][ODBC SQL Server...

Hi, I have a Database project in InterDev. I try to Add to SourceSafe. I have this error ERROR: ODSOLE Extended procedure. Bad variable type ERROR: A cursor with the name 'CursorProcNames' doesn't exists. Do you have any idea? Kim