|
|
hi thatraja,
thank you for giving me suggestions. But unfortunately none of it worked. Regarding to uninstall the update KB956391, so nd so...., its not a practical solution, as there are more than 30 users, even we tried that.
when i tried to install the Sql service packs 3 / 4 ...etc.. its showing message that, some other updates need to be installed.
i'm using Mssql 2008 , Mssql report service 2005 , Asp.net 2005.
please guide me,
Thanks in advance.
|
|
|
|
|
I have also tried the various work arounds, non of which have worked after a reboot. I've instructed my users to export the data to PDF and print from there (and disabled the print control). Major Pain...
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
dears
plz telll me How to describe SSAS PROJECT
coz i m new in this field and tell me best book
regards
|
|
|
|
|
|
Which is the biggest Reporting tool in .Net ?
|
|
|
|
|
I have used SSRS.
Many do use Crystal Reports.
These are major reporting tools by vendors.
There are many 3rd party tools..
♫ 99 little bugs in the code,
99 bugs in the code
We fix a bug, compile it again
101 little bugs in the code ♫
|
|
|
|
|
|
I would think SQL Server Reporting Services SSRS is the most widely used.
Crystal Reports is a dog, it is one of the worst supported, garbage products I have ever had the misfortune to have been very knowledgeable about.
There are however many other reporting options that I have no experience in.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
There are lots of reporting tools availabe for .net. Normally Crystal Report is the Most popular. Though Lots of developer used HTML reporting because of its easy to implement in websites. And every host support that. But Lots of host not support Crystal Report.
|
|
|
|
|
despite others, I also recommend RDLC of Microsoft.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
Although Crystal report is the most popular reporting technology, I will recommend SSRS. SSRS offers much better flexibility, controls over the report.
|
|
|
|
|
|
I have to create a SSIS package which will take data from a large xml file(~10GB), and import it into sql server 2005 database. Can anyone tell me the steps which i have to follow to do this? I also have to do XSD validation and maitain Transaction.
|
|
|
|
|
well you could better use BCP command for large files to import into a database.
See here for more details
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Hi all,
I have a MS-Access database.
Whenever I open the database its modified date and time will be changed.
I want whenever a change in the database ( by modifying records or tables )
then only the DB date and time should be changed.
How to control by not modifying date and time, when only database is opened or accessed?
How to do this?
|
|
|
|
|
I can't understand enough your question, can you explain more technically?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Yaah,
Whenever we just open and close the database. The date and time of the database will be modified.
I don't want this. ( date and time modification ).
If I have changed the database
ex: By adding new records or tables, or deleting records or tables
then only the database modified date and time should be changed.
how to do this?
|
|
|
|
|
You are not going to be able to manage the modified time of a file (your DB) from within the file, it will be in use by another process.
If you need to track the changes made WITHIN the database then you are going to have to build the logging infrastructure to manage that and it will not be via the modified date of the database file.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You could possibly get and store the date before opening the file and restore it after closing.
But I doubt it's worth the trouble.
|
|
|
|
|
I have a large xml file and I want to importing data from it to my database using LINQ.
- My database has many type of data and my xml file has null value.
- xml file has multi table.
In T-SQL, I used Dataset.Readxml and using SqlBulkCopy to insert dataset into SQL. My problem is xml file has null value.
I want to use LINQ to write it. What should I do? Please help me.
|
|
|
|
|
xml doesn't have 'null', so exactly what do you mean?
I suspect you mean that you have an element with no value or perhaps 'nil'?
If so there are two possibilities.
1. The corresponding database column allows nulls.
2. The corresponding database column does not allow nulls - thus you MUST provide a value. You would do that while processing the file. No one can tell you what a valid value for that is since it depends on business rules.
|
|
|
|
|
Yes, I mean I have an element with no value or perhap null.
I want to use LINQ.I have a column date type of data is datetime. And in my xml file, date has no data. I wrote a store procedure use openxml. When I execute it, it return 01/01/1900. I want it return null.
|
|
|
|
|
So just add something to the end of the stored proc to update the invalid value to null.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
OK, Try this bunch.
