Can not get notification after modifying ADF.xml?

I reregister and restart my instances after modifying ADF.xml,but still have no any of notifications

any idea about that? Thanks

what should i do after tuning ADF.xml or ICF.xml?

Thanks in advance

|||

After modifying your source xml documents, the ICF and ADF, you should update the instance (right click, Tasks, update in SSMS or NSControl update from the command line) to modify the instance. Check the output in either case to make sure the changes were successfully applied.

If you've modified the SubscriptionClass, rather than altering the underlying subscription table, the update process renames the existing table and creates a new one. The new one is empty, without rows. You'll need to manually migrate the subscription data to the new table, taking into account the altered structure. The old subscription table will have an appended "Old" to its name.

HTH...

Joe

Can not created Named Calculation...

I can not seem to create a Named Calculation on a table that I have already created a Named Query on in my data source view. Any idea why this is and if there is a work around for it?

TIA

Wellman

If you have already a Named Query you can add an expression-based column to the SELECT statement using the syntax of the underlying data source.|||

Thank you for this information. Any idea why this is so? Doesn't make much sense to me.

Also, can I reference other tables as well?

TIA

Wellman

|||Which part doesn't make sense? You can view a named query as a SQL view. Just like a SQL view, your SELECT statement can include any valid syntax, including other tables, calling UDF, etc.

can i use sqlserver2005 with asp.net 1.1 ?

hie

can i use sql server 2005 along with asp.net 1.1 as my front end ?

any idea of doing this ?

Of course.

Can I somehow subscribe to SQL upgrade notifications?

Well, it's happened again. An upgrade to SQL server was released without my having any idea about it. SP2 came out today and the only way I knew it was I happened to see a headline on Yahoo. Similar things have happened in the past with HotFixes or security rollups. Sometimes it's rather embarrassing, especially when your boss challenges you on the most recent security updates for SQL. Is there any way which we can be notified of new upgrades/updates to SQL Server? I need to know when there is a new hotfix, update, service pack, or whatever so that I can install it as needed. So far, the only way I've found these was by accident. I'm signed up with the Microsoft Download Notification email list, so I was able to see that SP2 CTPs were released, but I've never seen it include hotfixes or rollups.

If something like a SQL update notification service doesn't exist, then I would ask that Microsoft look at putting one together. Thank you!

The download notifications only send out once a week according to the site. http://www.microsoft.com/downloads/render.aspx?content=notifications&displaylang=en

Another good way would be to check out the SQL Server Release Services blog (http://blogs.msdn.com/sqlreleaseservices/) or the other SQL sites linked from Microsoft.com http://www.microsoft.com/sql, http://www.microsoft.com/technet/prodtechnol/sql, and http://msdn.microsoft.com/sql.

Thanks,
Sam Lester (MSFT)

Can I run SQL Server 2005 x86 on Windows Server 2003 x64?

I have to build a new corporate SQL server. Can I run SQL Server 2005 x86 on Windows Server 2003 x64?

If I can, is this a good or bad idea? For example, are there performance implications?

Yes, that is a supported configuration. You can verify from:

SQL Server 2005 Installation Requirements (Hardware/Software)
http://msdn2.microsoft.com/en-us/library/ms143506.aspx

I would, however, recommend a 64 bit SQL Server in order to better utilize the server memory. And there are also performance considerations related a 32bit application running in WOW on a 64 bit OS.

If you objective is to get all performance possible, get the 64 bit SQL Server and start out on the 'right foot'.

|||

Thanks very much. I couldn't find anything on the main SQL Server site.