Results 1 to 4 of 4

Thread: An exception occurred while executing a Transact-SQL statement or batch

  1. #1
    Join Date
    Feb 2009
    Posts
    49

    An exception occurred while executing a Transact-SQL statement or batch

    Hi,

    I Visual Studio 2008, SQLServer 2005 dev edition loaded on a Windows XP machine. When Visual Studio used to open, it loads fine but when I went to see the Default .aspx page I have this error: An exception occurred while executing a Transact-SQL statement or batch. There is no error code given in the error message. There is a additional infomation given. What do I do to troubleshoot and resolve this error?

  2. #2
    Join Date
    May 2008
    Posts
    613

    Re: An exception occurred while executing a Transact-SQL statement or batch

    I suggest you at any time when you try to install SQL Server, try to select the Advance option and then try to select the components that you think your situation is required before starting the installation of components see what you are installing. When you restore a database, it defaults to the physical paths used by the original person.

  3. #3
    Join Date
    May 2008
    Posts
    980

    Re: An exception occurred while executing a Transact-SQL statement or batch

    The first thing to do is open the Management Studio, expand the Management node, right click on the mail database and select Send email evidence. Until this functionality is working correctly, there is no point in trying something else. If you have not configured the mail database, right-click the node and select Configure Database Mail.

  4. #4
    Join Date
    Dec 2007
    Posts
    845

    Re: An exception occurred while executing a Transact-SQL statement or batch

    To solve you problem, you need to access the Configure Distribution Wizard, follow these steps:

    1. Open SQL Server Management Studio.
    2. Connect to the instance of SQL Server 2005.
    3. Right-click the Replication folder, and then click Configure Distribution.

    If you may not be able to find the Configure Distribution entry when you right-click the Replication folder. You can view and modify distributor properties at this point. To do this, follow these steps:

    1. Open SQL Server Management Studio.
    2. Connect to the instance of SQL Server 2005.
    3. Right-click the Replication folder, and then click Distributor Properties.

Similar Threads

  1. Exception hresult: 0x800706ba occurred in RPC server
    By Thenral in forum Networking & Security
    Replies: 6
    Last Post: 05-06-2011, 10:22 AM
  2. Replies: 4
    Last Post: 05-04-2011, 03:27 AM
  3. "An error occurred throwing an exception" message in Firefox
    By Cedric in forum Technology & Internet
    Replies: 6
    Last Post: 19-06-2010, 09:16 AM
  4. Create cursor in SQL server via transact SQL
    By In2TheBlues in forum Software Development
    Replies: 3
    Last Post: 10-06-2009, 12:59 PM
  5. an unhandled win32 exception occurred in explorer.exe
    By meditative in forum MediaCenter
    Replies: 2
    Last Post: 06-10-2008, 07:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •