Database

Re: Problem while accessing the committed data + sql server 2005

15-Jun-09 2:52

use NoLock for dirty reading

Select cloumnName from Table with NoLock

himanshu

Pankaj Garg15-Jun-09 3:18

Pankaj Garg

15-Jun-09 3:18

Hi,

Suppose i update the row
Begin tran
Update table set column = 'some val' where id = 9
it's original value is val

now suppose transaction completes after some time, and mean while a user selects this table and the user should read
val

not some val

Any Idea?

I dn't want to ready dirty data and also don'y want the query to get blocked

IP restriction Error in SQL Server 2005

Aman786Singh15-Jun-09 1:00

Re: IP restriction Error in SQL Server 2005

15-Jun-09 1:00

I am getting this error
Msg 1084, Level 15, State 1, Procedure LOGIN_IP_RESTRICTION, Line 2
'LOGON' is an invalid event type.

while executing under code:-

CREATE TRIGGER [LOGIN_IP_RESTRICTION]
ON ALL SERVER FOR LOGON
AS
BEGIN
DECLARE @host NVARCHAR(255);

SET @host = EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'nvarchar(max)');

IF(EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION
WHERE UserName = SYSTEM_USER))
BEGIN
IF(NOT EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION
WHERE UserName = SYSTEM_USER AND ValidIP = @host))
BEGIN
ROLLBACK;
END
END
END;

i am running it on mAster database and i am using SQL server 2005 standard edition.

thanks in advance
Aman

Eddy Vluggen15-Jun-09 1:35

Eddy Vluggen

15-Jun-09 1:35

Did you install Service Pack 2?

I are troll Smile | :)

Re: IP restriction Error in SQL Server 2005

Manas Bhardwaj15-Jun-09 3:25

Manas Bhardwaj

15-Jun-09 3:25

Eddy Vluggen wrote:
~~Service Pack 2~~

Service Pack 3[^]

Poke tongue | ;-P

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: IP restriction Error in SQL Server 2005

Kaushal Arora15-Jun-09 7:10

Kaushal Arora

15-Jun-09 7:10

Hi Aman,

Try to read this article. It is full of information.

http://technet.microsoft.com/en-us/library/bb326598.aspx[^]

Regards,
Kaushal Arora

Please Mark as Answer if it Solved Your Problem.

Insert Data In Database

InvXeesh14-Jun-09 23:51

InvXeesh

14-Jun-09 23:51

Hi i want to know how to Insert Data Into Database table from textbox on button click..?
Here's my codes..

<br />
<br />
namespace DataBindingListBox<br />
{<br />
    /// <summary><br />
    /// Interaction logic for Window1.xaml<br />
    /// </summary><br />
    public partial class Window1 : Window<br />
    {<br />
        public SqlConnection connection; <br />
        public SqlCommand command; <br />
        string sql = "Select Number From Tnumber";<br />
        string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True";<br />
        <br />
        public Window1()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void Window_Loaded(object sender, RoutedEventArgs e)<br />
        {<br />
            BindData();<br />
        }<br />
<br />
        private void BindData()<br />
        {<br />
            DataSet dtSet = new DataSet();<br />
            using (connection = new SqlConnection(connectionString))<br />
            {<br />
                command = new SqlCommand(sql, connection);               <br />
                SqlDataAdapter adapter = new SqlDataAdapter();           <br />
                connection.Open();<br />
                adapter.SelectCommand = command;<br />
                adapter.Fill(dtSet, "Tnumber");<br />
                listBox1.DataContext = dtSet;              <br />
            }<br />
        }<br />
<br />
        private void BindXmlData()<br />
        {<br />
         //listBox1.DataContext = BooksData ;<br />
        }<br />
<br />
        private void button1_Click(object sender, RoutedEventArgs e)<br />
        {<br />
<br />
<br />
        }<br />
}<br />
    }

himanshu256115-Jun-09 0:03

15-Jun-09 0:03

Just read some basic tutorials which ae easily available on google

himanshu

InvXeesh15-Jun-09 0:05

InvXeesh

15-Jun-09 0:05

I did try to find but didn't get any appropriate tut aur guide.. Cry | :((

himanshu256115-Jun-09 1:14

15-Jun-09 1:14

string sql = "Insert into "TableName" (Column Name) values('Column Value')";
string connectionString = @"Data Source='local\SQLEXPRESS';Integrated Security=True;Pooling=False;Initial Catalog='MASTER'";
DataSet dtSet = new DataSet();
using (connection = new SqlConnection(connectionString))
{
command = new SqlCommand(sql, connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dtSet);
}

himanshu

Aman786Singh15-Jun-09 21:44

15-Jun-09 21:44

Is this himanshu kashyap from amritsar??

himanshu256115-Jun-09 22:32

Enable TCP/IP and Named pipe in SQL Server 2005

15-Jun-09 22:32

yes

himanshu

Isaac Gordon14-Jun-09 21:33

Isaac Gordon

14-Jun-09 21:33

Hi Experts
i want to enable/disable tcp/ip and name pipe of sql server 2005 using command or query
not from wizard or internally open the window or SAC(Surface area Confg.).
Can You tell me what is query/command to enable the tcp/ip and namepipe.
Dines Sharma
Thank U

Re: Enable TCP/IP and Named pipe in SQL Server 2005

Niladri_Biswas17-Jun-09 20:29

Niladri_Biswas

17-Jun-09 20:29

You can use Windows Management Instrumentation (WMI) to configure SQL Server 2005 programmatically, including its protocols.

See the following article for more information:

Configure and manage SQL Server 2005 from your application using WMI
http://blogs.msdn.com/sql_protocols/archive/2005/10/19/482840.aspx

You can also use PowerShell to automate WMI

http://blogs.msdn.com/sql_protocols/archive/2008/08/29/configuring-sql-protocols-through-windows-powershell.aspx[^]
Smile | :)

Niladri Biswas

Help to Pivot the Following Table

Vimalsoft(Pty) Ltd14-Jun-09 20:29

Vimalsoft(Pty) Ltd

14-Jun-09 20:29

Good Morning All

Recently i posted some Sp that i had a problem with while working on a high volume of Data and someone suggested Pivot in sql . I goggled it and found that it was exactly what i was looking for , but i had a problem on the aggregate site because i wanted to Concatenate the Strings. here is the table structure.

ID              DESCR           CYCLETEMPLATE
====================================
7620	     Campbell P Dr	26
7620	     Campbell P Dr	27
7620	     Campbell P Dr	28
7620	     Campbell P Dr	29
7620            Campbell P Dr	      31
7621	      Jones D Dr	        23
7621	      Jones D Dr	        24
7621	      Jones D Dr	        26
7621	      Jones D Dr	        28
7621	      Jones D Dr	        29
7621	      Jones D Dr	        33
7621	      Jones D Dr 	       34

i want to Pivot it and it should look like this

ID              DESCR           CYCLETEMPLATE
===============================
7620	Campbell P Dr	26,2728,29,31
7621	Jones D Dr	23,24,26,28,29,33,34

The CycleTemplate will be Concatinated if the Description is the same and the Discription will not be duplicated again. as you can see in the above example. If your solution duplicated the Cycletemplate its ok, i have an efficient way of removing duplicates in a Field level.

Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: Help to Pivot the Following Table

Mycroft Holmes14-Jun-09 21:18

Mycroft Holmes

14-Jun-09 21:18

Didn't someone supply a sample function to concat the strings. This is the way I would do it.

It would also depend on the number of doctors as well, too many would cripple the process. You cannot do this in a single pass select query.

Never underestimate the power of human stupidity
RAH

Backup database using sql 2005 Express Edition.

ram_panda0914-Jun-09 19:44

ram_panda09

14-Jun-09 19:44

Hi Team,

I'm a software developer and,
I want to make my hosting server database as my local server database for testing purpose.
But my problem is that, I'v downloaded the sql2005 ssmsee from msdn subscription and installed it in my Vista Home Premium.
The thing is that after installation the Import and Export Options are missing.
So I can't able to Import and Export the database.

So, please anybody help me to make the hosting server database as my local database.

Thanks in Adavance...

Thanks and Regards,
Rama Krishna Panda,
S.E.(.Net Tech.)
Ergode.com,Mumbai.

Re: Backup database using sql 2005 Express Edition.

Mycroft Holmes14-Jun-09 21:12

Mycroft Holmes

14-Jun-09 21:12

I'm pretty sure there is no option to Import a database. I use the developer version and I am able to restore a backed up database OR attach an MDF and LDF files. I can uses import of a table but there is not import database option.

Never underestimate the power of human stupidity
RAH

Re: Backup database using sql 2005 Express Edition.

Aman786Singh15-Jun-09 1:05

Re: Backup database using sql 2005 Express Edition.

15-Jun-09 1:05

Download SQL express 2005 tool kit from Microsoft.com

and attach it with your running version as a external tools.

regards,
Aman

Aman786Singh15-Jun-09 1:06