Well I wonder why this idea didn't struck me. :) that was too simple. Thanx for help SimulationofSai.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Hi there, I am trying to encrypt my sotred procedures with "WITH ENCRYPTION" clause like this ALTER PROC myProcedure WITH ENCRYPTION. It works well for the stored procedure that has not parameters but for a stored procedure with parameter list it generates the following error. "Incorrect syntax near '@p_param1'." where @p_param1 is the first parameter. Note that this SP is giving the proper results and runs well. Thanx in advance
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Thank u very mcuh Henlon. That was AWESOME. [:)] That really works. When I opened the database from bin folder it contained all the data that was inserted earlier. I don't know how should I say thank u to u. Thank u so much. [;)]
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Well everything is fine with connection string and application works fine enough as far as it is in RAM but acutal changes are not commited.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Yes this property is set to true as 'User Instance = True'. I think it might be some limitation of SQL EXpress but uptil now I haven't come to know about any such limitation. Same problem also posted here by someone. http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2555908&SiteID=17[^]
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
No I am not using this statment and I have also checked SqlCommand object's propertys using it like this com.Transaction.Commit(); function but it is not working. :( I think it is the problem of SQLEXPRESS that may does not allow inserting or updating by default. If anyone give any idea about it, I shall be thankful.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Yes I have tried the procedure in query analyser and it inserts data successfully. I have added 4 records in tabale using this SP but and everytime I start application, it starts from ID = 5 (ID is IDENTITY column).
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
I am using SQL Server EXPRESS Edition for my C# client. I have written an SP InsertData for inserting data into a table. Another SP GETDATA fetch all the data from the table. Now the problem is with my C# client application. On the main Form I have placed a grid which is filled by calling GETDATA stored procedure. There are text fields and an ADD button on the main form. When I click add button I call InsertData SP and then in the same event handler I call GETDATA SP again to refresh my grid. It works well and show data in grid but later when I check the database no entry is inserted in the database. Again I run the application and database is in the previous state (i.e. no data is found that was inserted in the previous run). In other words data is shown to be inserted but is not actually inserted in the database. What could be the problem? For refernce I have checked msdn where someone has posted the same problem here. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2888935&SiteID=1[^] but no satisfactory answer found up till now.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Hi there, Can someone tell me, is it possible in SQL Server 2005 how to Decrypt and Encrypted SP or View.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Hi there, I am trying to save an Image from a database to a file but it only save the following to the file "System.Byte[]".
fileWriter.Write(dsExportDataTypes.Tables[0].Rows[i]["ATTACHMENT"]);
fileWriter is an object of StreamWriter Class.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
HI could anyone tell me how to find all the disabled trigers in the database?
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Thnx buddy that was useful. :)
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Hi All, Can somebody tell me the easiest way to import data from and Excel sheet to a table in Sql Server 2005 database. An immediate response would be appreciable. Thanx in advance.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
OK thanx buddies. So nice of u.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Hi there, I am new to sql server 2005 can somebody tell me is there any sql command that returns all databases hosted on SQL server 2005.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Is there any exception? If yes then what is the exception message?
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
If you are using a textbox say txtName then you can write an event handler for KeyPressed event. Like.... private void txtUname_KeyPress(object sender, KeyPressEventArgs e) { if (txtUname.Text.Length == 160) { MessageBox.Show("Text5"); } } Hopefully it will solve your problem.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
I think your grid must be having only 5 records from 0 to 4. So its not geting the 6th record.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Hi all I am writing a program in which I want to read all the column names of a table in db of sql server and against every column I want to check wether it is NULLABLE or not. I am using MyDataset.Tables[0].Columns[j].AllowDBNull property of dataset but it shows always a true. I mean all the columns are shown as NULLABLE. Could someone help me? -- modified at 1:44 Friday 24th August, 2007
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."