If you have already linked the PDS dataset to Crystal, don't create a new dataset. Instead, add a new datatable to existing PDS dataset and then add rows to it. After this you can see two tables at Crystal side.
Thank You Mika, I did it the other way round. After adding the new columns to the dataset. I have updated the dataset schema using .WriteXMLSchema (), this infact, updates the old schema with the one and shows the newsly added column in the fields explorer section of the Crystal Report.
My application depends on a sql server database I want to deploy my project in the client machine with out deploying the sql server express edition because it take some disk space and it some times cause some problems in its deployment(mainly if user don't have any experience).Is there any way to overcome this situation.
Im using two database db1,db2, the data will be insert,update will done in db1 will be uploaded once in a day.if i updated or inserted the records in another day means it should fetch that records alone and updated to db2 database,im using sql server 2000,asp.net2.0.how can i acheive this one.
I currently have a site in ASP.NET connecting to SQL Server 2005, what we have picked up is that there are a lot of processes with the same process id. i.e. 64 appears 7 times in the activity monitor, half of which is either sleeping or suspended, the other 3 is runnable.
How is this happening? is it possible to have more than one process with the same ID? and a lot of these processed has a wait type of CXPacket.
Just want to state that I'm no sql guru so its a process of head bumping at this stage.
Thanks in advance
No matter how long he who laughs last laughs, he who laughs first has a head start!
You are seeing parallel execution of statements which is basically a good thing.
However it can also be a problem (depending on the application) in which case you should reduce the amount of parallelism or even disable it. Usually if this is the case you also see very high (~100%) CPU load and actually your CPU becomes the bottleneck.
Unfortunately you have to configure parallelism for the whole SQL Server. However you can configure parallel query so that it will not happen so often:
1. set cost threshold for parallelism for a higher value. For example if the value for this is 5, it means that if the operation is expected to take more than 5 seconds, parallelism shall be used. You can increase this value so that only 'long' operations use parallelism (say set theshold to 30 seconds or whatever is suitable).
2. don't let the database use all processors. If you have 4 processors, you can set max degree of parallelism to 2 which means that only 2 processors are used simultaneously. Value 0 means that all processors are used
To list your configuration use either Management studio or by T-SQL by configuring to see advanced options and then listing all option:
sp_configure 'show advanced options', 1;
I am using SQL Server 2000 on back end and .Net C sharp on front end. Server is connected with more than 30 users.
On user’s computers there are different files having different formats like MS Word, Excel, Visio, PDF etc with more than 4 MB size.
I want to see these files through database, correct them and resend to users through database on LAN.
How Can I Do All This without sharing any directory?
Best Regards for your kind Help
we are Talking about Different Storages, So why would you think SQL would help you to save word,excell documents.Firstly you must first understand what is a Database before you can start storing data on it.
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
Has anyone managed to deploy an SSIS package using SQL server to store the configuration values.
I have created the package in VS and successfully run it. It is a basic ETL process.
I have 3 connections
SourceDB - connection is hard coded into the package
DestinationDB - connection is to come from the configuration DB
LoaderDB - Harcoded in the package supplies the configuration values.
Validation fails when trying to connect to the loaderdb - with invalid login credentials.
I found this article and got to the point where the package is actually looking for LoaderDB
When inspecting the package in Management Studio I noted that the connection manager does not have the password so I edited the connection string to include the password which still fails (tested the connection string from VS - no problems).
I cannot use XML config files as I need to expose the configs to the users for modification. Therefore storing them in SQL is the best solution, if I can get it to work.
Never underestimate the power of human stupidity
Create a user defined variable to store the password. Build your connection string using an expression and extract the password from the UDV. And when you run your package, you can set the value for any user defined variable.
Thanks for the hint - i had it in front of me in the article but didn't put it together.
What a freakin nightmare, imagine having to put the connection string in clear in a bloody environment variable - is that a scream of anguish from my security person.....
It looks like the connection HAS to live in a variable. I had the idea that I could put the bits (server, UID and password) in the config table and have the package build the connection based on the config values, seems the package is ingnoring those and using the connection string in the deployment (no password).
Never underestimate the power of human stupidity
Last Visit: 31-Dec-99 18:00 Last Update: 23-Sep-23 5:39