Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 10-12-2009
Member
 
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?

Reply With Quote
  #2  
Old 10-12-2009
Una Una is offline
Member
 
Join Date: May 2008
Posts: 614
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.
Reply With Quote
  #3  
Old 10-12-2009
Member
 
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.
Reply With Quote
  #4  
Old 10-12-2009
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "An exception occurred while executing a Transact-SQL statement or batch"
Thread Thread Starter Forum Replies Last Post
Exception hresult: 0x800706ba occurred in RPC server Thenral Networking & Security 6 05-06-2011 10:22 AM
Just in time Bugging [An Exception "Runtime error" has occurred in Script] Glinda Technology & Internet 4 05-04-2011 03:27 AM
"An error occurred throwing an exception" message in Firefox Cedric Technology & Internet 6 19-06-2010 09:16 AM
Create cursor in SQL server via transact SQL In2TheBlues Software Development 3 10-06-2009 12:59 PM
an unhandled win32 exception occurred in explorer.exe meditative MediaCenter 2 06-10-2008 07:33 AM


All times are GMT +5.5. The time now is 11:37 PM.