mmeshref

First of all, I am Egyptian, so I can understand and read arabic, I just don't have arabic keyboard as I don't live in Egypt What I am saying that NO ONE SHOULD EVER write his own authentication system, we are going away of using SQL Authentication because of …

Query Processing This lesson will be the first lesson in the query processing and how the query get processed, to understand the query processing components, we first need to understand Iterators Iterators What are iterators? SQL Server breaks queries down int…

I assume that in the second method, they use one centeral login with admin privilages and then they try to control what the local user can do and what he can't, right? In other words, they have a single admin account, they then see if the user is an admin or n…

SQL Server Memory Management In this section, we'll take a look on how SQL Server manages memory, it's done mainly through these parts: Buffer Pool & Data Cache Access to In-Memory Data Pages Managing Pages in Data Cache Checkpoints SQL Server Memory: Buffer P…

I already started :)

SQL Server Operating System: SQL Server has an internal operating system which is responsible for doing all the tasks, like managing threads, fibers, processes and memory inside SQL Server. Two Major pieces that belong to the SQL Server OS, is its ability to s…

Storage Engine Operations In continue for where we stopped in the last lesson, we'll be talking about Storage Engine's operations in this one. Storage Engine: Access Methods When SQL Server needs to locate data it uses access methods. Access methods will eithe…

So you don't know what SQLCLR is and why it's used and how? Sorry, can't help you in this, and you can't do this in pure T-SQL either!

As I said earlier, I'd be posting some articles on how SQL Server Engine works. I'll do it in English, brother Tareq could translate it to Arabic if you want. My first article would be about SQL Server Arcitecture SQL Server Architecture Below is a diagram sho…

You can't have a foreign key that doesn't exist in the other table, so you either choose values that exist in the other table, or remove the foreign key

Then don't make it a foreign key

NEW1 and NEW2 are both 4 characters, but the table column is only 3 charachters in length

So you'll put it in arabic or English?

I dont understand what do you mean by: كود الادخال وقبل ماكتب كود الربط

So you can connect to the server from all you application but not from the enterprise manager? The question about registry is not related to the instance, because if you can connect from your apps but not the enterprise manager, then something is messed up wit…

Try to remove the last ")" and see how it goes, this one is not correct

You sure nothing is messed up with your registry or installation? Can you connect to it using OLEDB or using SqlConnection for example?

There's no specific command, you create some .Net function that can read you email and return it to you in a form of a table or anything like that, you then put it inside SQLCLR and use it as a normal stored procedure How to do this in .Net, is something you c…

Can you give me the error message?

I am still not sure if I understand you correctly So your program can connect to the database when it tries to query data but not when it tries to insert data?