Search results for query: *

Hi, Please find below the log file. I am unable to start SQL Server. Any inputs will be welcome. Ranjith 2005-01-25 18:20:37.22 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1...

Hi, I have a Access Database A A.mdb gets additions every month. We need to import A into an SQL Server database S. We lose the keys in the process. We manually add the keys in S. When a new A comes we need to import it to S. I try to do this with Data Transformation Services. When I...

Imported using the Data Transformation Services Import/Export Wizard.

I now use only one table to do the querying. Is that an issue? There are no indexes for the PROJECT table. This database was imported from ACCESS. We thought we would have a time advantage querying from a SQL Server database. Requirement: Query 3000 records from a database. Ways(ACCESS or...

I had seen the MS SQL forum only later and I had posted there too. I will continue there to find a solution to this issue. The thread id is thread183-978862 Thank you for the responses. Ranjith.

Hi SQLSister, When I call the query from the Query Analyzer the duration is zero(which means it is lesser than a millisecond) Ranjith

Hi Frederico, Here are the details you asked for: Code to call Stored Procedure: public string runStoredProcedure(string UniqueKeyValue, string RequiredClassPropertyName) { SqlCommand getClassProperty = new SqlCommand(RequiredClassPropertyName, m_Connection)...

I tried all of the above suggested responses. However the execution time remains the same. Is there some more information about the table or the database which I need to tell the forum? Ranjith.

thank you for the responses. Let me try them and get back to the forum. Ranjith

Hi PHV, I tried the above stored procedure. The execution time remains the same. Is it possible to handle errors instead of checking for errors in stored procedures? If yes, how? Ranjith

Hi PHV, Thanks for the quick reply. I have changed the code to use one table. However the stored procedure execution time remains the same. Is there any other way I may improve the time? Ranjith.

Database: SQL Server 2000 OS: Windows XP Professional Tables: PROJECT: PROJECT_ID - primary key SCHEDULE: PROJECT_ID - foreign key STARTDATE - string (yyyymmdd) Aim: To get the Start Date string from the SCHEDULE table given the PROJECT_ID Checks: NULL, EXISTS and default value to be...

Database: SQL Server 2000 OS: Windows XP Professional Tables: PROJECT: PROJECT_ID - primary key SCHEDULE: PROJECT_ID - foreign key STARTDATE - string (yyyymmdd) Aim: To get the Start Date string from the SCHEDULE table given the PROJECT_ID Checks: NULL, EXISTS and default value to be...

Hi, I have a xsl transformation cum formatting file. This file contains both transformation and formatting functionality inside. I need to handle the <br/> tag. When the <br/> tag is found then i need a break(both linefeed and carriage return) in the PDF generated. I am using FOP 0.20.5 in...