That's pretty weird...

For consistency I would log into Management Studio with the same user that Reporting Services use (unless you are already using Windows Authentication).

The only other alternative I can...

Are you using an ODBC connection in Reporting Services rather than the native OLEDB connection? That could be the reason...

Rebuilding indexes also updates statistics. My guess is that your statistics weren't up to date and the query optimizer therefore did not use the index.

Regards,

Martin.

Reporting Services, which is free with SQL Server is the best way to go...much better than Excel 😀

Well, if you still have the data and log file on the D:\ drive you can just attach them again. In Enterprise Manager, right-click "Databases" go to "All tasks" and...

I agree Jeff.

Rog, this is not an avenue for your marketing campaign. Rather say something useful...or don't.

Yes, that is probably the case.

I would not advise you to force the query to use a specific index. Rather structure your indexes so that the optimizer chooses the correct index.

There are always exceptions to the rule...

The above comments are good advice. I will also update statistics on the table(s)/indexes referenced. What happens sometimes is that the statistics on the particular table is outdated and the data...

I might be sending you on a wild-goose hunt, but it sounds like your application might not be closing its database connections properly...

You will probably have to write a vb/java script that:

• opens the file after you have populated it
• moves to the end of the file and check whether it is a carriage...

Hi,

Your domain password is the password you use to login to your network, or your local pc for that matter (if it is on a network).

To delete the SQL Server registration:

Right-click...

We have had similar issues sometimes when using Windows Authentication and our domain passwords expired and subsequently changed. For some reason it seems like the domain controller have not yet...

Hi,

The best thing to use here after you have your filename in a global variable is a dynamic properties task. You will see it on the left hand side in...

There is a way to do it, but its a bit of a hack. DTS will not give you the option to query a text file connection, but it will...