SQL Database

  1. Prevent refresh by hitting F5 in the Azure Web Portal when typing

    There are a few interfaces in the portal where you can type queries: SQL Editor, Azure Data Explorer, Azure Cloud Shell... Unfortunately, you may hit F5 and lose everything. Please prevent it!

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. DBMail

    AZURE SQL Database does not support msdb.dbo.sp_send_dbmail.
    How can we use if I wan to send emails when trigger fires.

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. master data service connect to azure

    The connectivity from MDS to Azure SQL or a PaaS MDS will be a great feature to extend the limitations on usage

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. SqlBulkCopy.WriteToServer fails on SQL Azure if destination table is temporary

    SqlBulkCopy.WriteToServer fails on SQL Azure if destination table is temporary.

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 30

    <=-=Oct 25 2011 2:38PM=-=>

    Hi Andrey,

    Thanks for reporting this issue. SqlBulkCopy.WriteToServer does not work in this case because SQL Azure currently does not support temp table. We will route this bug to SQL Azure team so that they can follow up with you.

    Young Gah Kim
    Development Lead
    ADO.NET Managed Providers and DataSet Team

    <=-=Apr 19 2012 6:15PM=-=>

    Hello Andrey,
    Thanks for reporting the issue. The problem is due to the fact that SQL Azure doesn’t support 3-part names for stored procedure calls. In this case, the driver/provider use tempdb.sys.sp_* syntax to access certain stored procedures that provide metadata about objects and these calls fail. We are looking at resolving the issue & enabling 3-part names for tempdb calls.
    Otherwise, you can use temporary tables in SQL Azure fine – we do support it with the restriction mentioned above. Additionally, you can’t create temporary tables…

1 2 30 31 32 34 Next →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base