No Data-Driven Subscription button

I have created a report and published it on the reporting server. My connection is working, and I have followed the steps in the BOL tutorial for "Defining a Data-Driven Subscription" i.e. Credentials stored securely on report server, using windows credentials when connecting to the data source. When I click on "Subscriptions", I only see "New Subscriptions". However, when I look at other reports (not even created by me), I see the option to create data driven subscriptions. Can somebody tell me what I need to do to see this?I got it; the report cannot be in the "My Reports" folder.

newsequentialid

HI

Does anyone know if the sentence below from BOL means newsequentialid does not generate unique id on computer with network card? we have a sql database that uses newid for several tables, I want to switch to newsequentialid to reduce page splits

The GUIDs generated by NEWSEQUENTIALID() are unique within a particular computer only if the computer does not have a network card

thanks

Pauli

Hi,

see this article for more information:

http://sqljunkies.com/Article/4067A1B1-C31C-4EAF-86C3-80513451FC03.scuk

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de