.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Where do I begin

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
I am wanting to channge my focus in the IT industry from networking to database work.  I have purchased SQL Server 2008 R2 Developer Edition.  I have looked at some books and bought a couple but it seems there are a great number of errors in the books and I don't know enough to correct the errors.  What would be a good book to start with or a download that can help with my path in this industry?

View Complete Post

More Related Resource Links

WCF - Where do I begin


I was asked about a project that doesnt currently use WCF. Where do I even begin!

The object is to allow the application to make a secure call to a database.  I've not the foggiest where to begin.

text to XML - where to begin?

Hello, I am new to the ASP.net realm and have a long way to go so please bear with me! I have learned with coding (mainly Perl and XML/XSLT) that there are 100 different ways to do accomplish the same result.  I am hoping you can point me in the right direction. Senario: I am working on some automation helping out migrating configs from 1 hardware load balancer to another.  My goal is to be able to select and copy the appropriate portions of the config I want to migrate and then paste it into a textBox webform.  I need to take the input of the textbox and parse the data into XML.  Once its parsed to XML, then I need to have the new XML data assigned as a string variable so I can use it so send as a HtTTP request to the endpoint. Thats it!!  LOL Here is a sample of the data I need to parse to XML.  Note that the line order will not always be the same. I am only interested in the variables in bold vip address tcpport 80ip address 2100redirect "http://forums.asp.net" I hope I havent asked for too much on my 1st post :) Thanks!David            

what is difference between BEGIN TRANC and BEGIN TRANCSACTION?

hi guys what is difference between BEGIN TRANC and BEGIN TRANCSACTION? and which one is better? Best regards, Morteza.

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a

Hi,   I am facing the below mentioned error:   The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].   I have a Insert statement which i am using to insert data into a remote server from my local server. I have added the remote server as a linked server in my local server but when i try to execute the statement i am getting the above mentioned error. I am using Windows Enterprise Edition 2003 and SQL Server 2000.   I have also enabled the Allow InBound and Allow OutBound in the security configuration of My Computer properties but still i am facing the same problem. Kindly let me know how to resolve this issue.   Thanks.

How to begin storyboard based on ListBoxItem selection???

0 down vote favorite

I encounter a problem that I cannot solve. I hope to find an answer here. I need a listbox to hide half way when a certain listboxitem is selected. I setup a storyboard with opacity mask animation which work fine in blend. My problem I cannot initiate BeginStoryboard. I tried numerous ways and no success. I need to hide the listbox to reveal the content behind it. I generate listboxitems from XML data file and based on the name node I planned to initiate storyboard playing.

Here what I have. I created DataTemplate which I set via Setter in ListBoxItem Style:

<DataTemplate x:Key="SelectedListBoxItemDataTemplate">
			<StackPanel x:Name

BEGIN, END, and GO Question



Sorry for the basic question here but when is it best to create new BEGIN, END, and GO blocks for SQL Statements?  In my case, I have a stored procedure that I created, below is a snippet:

I have something like this:





INSERT INTO etc, etc




The above snippet has just one insert statement, but if I had multiple insert statements that weren't necessarily related should I create a new BEGIN END block for the each of the other insert statements?
  1. Does BEGIN END cause the statements to be executed in a transaction block so if one statements failed, it would rollback or is that done differently?
  2. When is GO needed?








WCF/MSMQ Issue - Not sure where to begin


I've created a prototype application which uses WCF and MSMQ to send simple "hello world" messages from a client app to a server app.  I was able to get it successfully working on my machine. 

However, being a client/server technology, I need to get this prototype working across a network.

So, I got a second PC, installed MSMQ on it and my client application.  When I run the client app on this second PC, it does not work correctly.  I don't get any run-time exceptions, however, the messages are not received on my server.  If I go into my client PC's Computer Management console, I can see the messages in its outgoing queue.  So, it appears that the problem is that my client app is not connecting to my server app.

Both machines are on the same domain and can see each other in Windows Explorer.  I'm able to copy files back and forth from both PCs.  If I execute MessageQueue.GetPrivateQueuesByMachine() on my client PC, I can see my server's queues.  I should note that my server's queue is private. 

I'm using Visual Studio 2008, .NET 3.5.  My server machine is running Windows 7.  My client PC is running Windows Server 2003 R2.  My binding is netMsmqBinding.

To create my prototype, I am using Michele Bustamante's QueuedServices example from chapter 6 of her &q

Dynamics AX Report call a function at the begin of report execution


I need a way to call a function at begin of execution of the report, and to call another function when execution ends.


I need to connect to SQL to call a stored procedure.

SSCE T-SQL for Transactions (Begin...End;): Does it exist?


I'm currently trying to optimize my mobile application by consolidating a collection of update and insert statements into a single stored procedure (or transaction) on my mobile device.  However, when I issue the SqlCeCommand, I consistently get an error stating that the first parameter is a mistype (this is a stored procedure).  I tried issuing the same command in the SQL CE Query Browser and it would fail in a similiar fashion.

Any tips on how to go about this without making a direct SqlCommand to the main SQL Server 2008 servers? (I'm using replication.)

Why are my query windows now saying "BEGIN TRAN ROLLBACK"? How do I turn that off?


Why are my query windows now saying "BEGIN TRAN      ROLLBACK"?  How do I turn that off?  I am sure I must of done something to do this, but I know just a few short weeks ago it didn't come up.





Advantage of Begin and End?


I have the following code. The UI thread is blocked by code below when EndAdd gets called. Then what is the advantage of calling a method using Begin and End in example below? Is it that the UI thread does not consume extra resources for calling the new method ? So if the method was called synchronously then the UI thread or the main thread would consume whatever resources would be required by the Add method.

IAsyncRsult result = calculator.BeginAdd(x,y,null,null);

int sum = calculator.EndAdd(result);

OLE DB provider 'SQLOLEDB' was unable to begin a distributed transactio


Hi All,


I am getting following Error:

Oracle linked server in SQL server 2005 to update tables in Oracle database.

I have used OPENQuery to update tables in Oracle from a SQL Server 2005 Stored procedure.


If we run query from sql management studio for inserting or updating table of linked server then it runs fine. But if we use Begin distributed transaction then its gives error -

Server: Msg 7391, Level 16, State 1, Procedure sp_test, Line 105

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

What does BEGIN TRAN and ROLLBACK do in a query window?


I installed SSMS ToolPack and now in every query I have it would show








What does these do? Like If I run a select query within them, it runs fine, I didn't try to do anything else.  I read online about this a while ago and I remember that you have to set a TRAN for begin part, but I don't know what is the use for these as they are right now.  Any help would be appreciated

SQL dynamic query inside BEGIN Transaction


Hi All,

I am working on stored procedure and all update statements are inside "BEGIN TRAN" and COMMIT..now i expect if all statement runns succesfully then to return 1 else from catch block it should return error message..

i wrote stored procedure mentioned below ...

when i execute this stored procedure i see three output ..including return value..


-- =============================================
-- Author:		<>
-- Create date: <19 March 2010>
-- Description:	<Update FPA_CLAIM_MAN ,FPA_CLAIM_DETAIL ,
-- =============================================
ALTER PROCEDURE [dbo].[SP_UpdateFpaByFiAdmin](
	-- Add the parameters for the stored procedure here
	@COMMENT VARCHAR(1000) = ' ',
	@TOTA_CLAIM_AMT bigint,

	@bu_ecode VARCHAR(20),

	@total_bal bigint ,

	@STRING_Employee_Limit_distribution  VARCHAR(MAX) = '',
	@STRING_Employee_FPA_distribution  VARCHAR(MAX) = ''

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend