Recent content by varshan09

Thank you for your replies. Please find my comments below - 1. Cannot use Truncate as we are not deleting all records in the table 2. Cannot use temporary tables in tempDB as we need to retain data till the time user is executing another calculation process. Please suggest. Thank you, Varsha

Hi All, We are developing an intranet based web application which deals with huge amount of data. To explain it better, the application has a calculation process which adds nearly 30 million rows in a table for a user. There can be multiple users accessing the application and performing similar...

I want to store xml in a table. Let's say I have following xml: <Root> <Row> <Col1>Val1</Col1> <Col2>Val1</Col2> </Row> <Row> <Col1>Val2</Col1> <Col2>Val2</Col2> </Row> </Root> Is it possible to use OpenXML to insert each <Row>...</Row> as a single row in table? In the above example I want to...

Hi, Can you explain more about web services exposed by sql server reporting services? Also regarding XSL-FO pdf generator, can I get simple example of generating PDF report? Thanks Varsha

Hi, We are working to develop one analysis tool which has reporting capabilities. Reports are developed in HTML. we need to add a feature of export to PDf. since reports provide pagination feature and in the pdf we need to show all pages. What are different options for it? Thanks Varsha

Hi, Is use of typed arraylist versus typed collection is preferred? I'm using for transferring data from one application domain to other. Please clarify. Thanks Varsha

Is there any way to specify any column as encrypted in SQL server 2000? We have the requirement of storing passwords in the table and we want to store enrypted values of the passwords. Any pointers will be appreciated! Thanks Varsha

EXEC master..xp_cmdshell 'C:\MSSQL7\Exec\SQL_Install_Script_Migration.bat' This will be one time activity during the installation, so we didn't go ahead with the idea of putting the entire thing in a SQL job. Thanks Varsha

Just to you an example, we have many steps as part of data migration - 1. Dropping all constraints 2. Running Create and Alter scripts to change the schema 3. Creating stored procedures 4. Creating all constraints We have created different .sql files to perform these operation, and our batch...

Actually as part of the bat file, we are writing in a log file, since it is not writing in the log file, also it is not changing the data as per expectation. Thanks Varsha

Hi, We have a batch file which needs to be executed from query analyzer. We are trying to do this using xp_cmdshell. It does not seem to be working. When I run the .bat file through command prompt, it transfers the data and logs the trace in the file, as per expectation. With xp_cmdshell, it is...

Hi All, We have a requirement to change colour of all buttons and controls on the form throughout the application. I know we can easily do this in the web applications using stylesheets. Is there anything similar to stylesheets in desktop applications which can be used to change te colour of the...

Hi All, We are using ExecuteReader method of the SQlCommand object with the option of CommandBehavior.SchemaOnly. It works perfectly fine to get the schema of the columns in the resultset. I am facing problem in fetching schema information of the temp tables(Created using #temp syntax). It...

Hi, How can I find out that a windows PC already has an instance of MSDE? Our requirement is to include setup of MSDE in the application exe and launch the exe if MSDE is not installed. If it is already installed, we need to skip the process of installation of MSDE on the computer. Any...

Hi, In our case, we need to download it form the customer portal. Will it add additional complexity if download from the portal and run it? Thanks Varsha