Yes i have the required permissions ,still not able to get the error.Could you tell me why facing this same issue.

Thanks a lot .I have understood between parse and run time error.Probably this did not clicked my mind.Once again thanks.

Hi ,

It is better if you tune the queries,may be stored procedure whci are running in your environment.We also had the same problem our development team tuned the sp's and...

looked for all the build-in system functions and query types (joins) used in previous version and confirm if they still work in newer versions.

3.Pulled all the datatypes used in previous...

ok was it working fine before or from the beggining it is giving error.

http://www.3sp.com/en/kb/idx.php/0/239/article/When-I-attempt-to-start-the-service-I-receive-an-error-1067.html

-sandeep

Hi,

Are you strating the service in the logon user to Local System Account or using some other a/c.

Hi,

Yes you can use custome code for export to excel .

Thnks

Sandeep

Hi,

Pk violation is what you should be looking at and try to analyse as why this violation has happened.

Hi,

SELECT *

FROM TABLE

WHERE ID = (SELECT MAX(ID) FROM TABLE)

What does your table structure look like? Do you have a naturally

increasing column...

Hi,

Please go through this KB article.

http://support.microsoft.com/kb/839174

Hope it helps,thanks

Hi,

this stored procedure will give you database space used and free space.

use dbname

sp_spaceused about the data files.

go

hope this helps thanks

Hi just to add on one more reporting tool is

BIRT is an Eclipse-based open source reporting system for web applications, especially those based on Java and J2EE. BIRT has two...

Hi,

Can go through this links.

http://support.microsoft.com/kb/224071

http://support.microsoft.com/kb/907511

Thanks.

Hi ,

Just to add on iam attaching one article which i found is useful.Just read this also:

Why use asynchronous, queued messaging? Queues enable flexible work scheduling, which can translate into...

Hi,

The following new features in SSIS 2008:

Lookup Enhancement

Data Profiling Task

Pipeline Memory Limiter

Pipeline Performance - Multicast Transform and Threading in SQL Server 2008

VSTA support for Script...