Create a appliction user and give him proper rights for application.

It is very diffcult to assume with the given data. Provide sample data.

Check the following link

http://207.46.16.252/en-us/magazine/2005.05.systemtables.aspx

Please go through BOL. Reporting Services were very well explained.

Can u please provide some data in text file? And let me know what is code page you are using?

Can u please post the error message and error number u are getting.

What is error message your are getting in the job?? Please provide the error code and error message of the job

Hi

I had the same problem.

I am downloading the files the remote ftp server

The file path for today ex:/m/09112009/a.txt

Likewise i need to download daily. I have configured...

Using float and real Data

The float and real data types are known as approximate data types. The behavior of float and real follows the IEEE 754 specification on approximate numeric...

select z,z1 from table1

union

select z,z3 from table2

union

select z,z1 from table3

Check the following link

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/88e9ebfa-6378-40b9-844e-fcd0266a66a6

Auto_Close

When Auto_Close is set to ON/TRUE, the database is closed and shut down when all processes in the database complete and the last user exits the database, thereby freeing...

Use the following example.

select (@maxno/50000) + 1 SheetsCount ...

You need to set the restrict acess to multi_user. Only administrator login can set the same.

The basic difference between Optimistic and Pessimistic locking is the time at which the lock on a

row or page occurs. A Pessimistic lock is enforced when the row is being...