Is there any way to open the object-Definition of an object by name? e.g.
EXEC Test -> Rightclick on Test -> open object definition -> the stored procedure definition opens in a new window.
View Complete Post
I'm going through the MS SQL Server SSIS Step by Step book from Microsoft Press and I think I have an issue with my install of MS SQL Server.ÃÂ On the first exercise, the book instructs you to open an existing project and then open a data source view from the project.ÃÂ The data source view contains several table objects and a named query object.ÃÂ When I right-click on the named query object and then choose 'Edit Named Query .', I get a pair of 'Object reference not set to an instance of an object' errors.ÃÂ This also happens if I double-click on the object itself.
I created a blank project. ÃÂ Then I created a Data Source View and populated it with tables from an existingÃÂ database using the wizard.ÃÂ When I tried to add a new named query I got the same error.
Is there a configuration error here?ÃÂ So far all of the other functions have worked normally.
SQL Server 2005 Developer - SP2 (all patches applied) (SQL Server 2005 Evaluation exhibits the same error)
For more than one user in my network, they are unable to edit office documents when opened through a shortcut. The document opens in read only mode, cannot find a way in office to edit the document such as through the publish or server menu items.
I did a search and this did not resolve the problem: http://support.microsoft.com/kb/870853
Our sharepoint server is 2003, coupled with SBS 2003
SQL database 2000
Users are using Office 2007, sp2
Operating System: XP, sp3
Users are setup to receive all MS updates, so they have latest updates.
The edit bar shows up when opening the document in sharepoint as read only. Clicking it allows the user to edit the document. They have contribute privileges to the library and file in sharepoint. The file(s) are being opened
with a shortcut (right click -> New -> Shortcut, paste in the hyperlink to the document in sharepoint). Strangely enough, I have the same setup as the other users but using office 2010 and the edit document bar shows up when opening the document
in the same manner. On a side note, some users have infopath 2010 installed, others do not.
Any help would be appreciated, or posts to other topics with solutions that I misse
using Asp.net c#
i am searching a record from my database and displaying it in gridview now i want the comments should be updated as per the record which is being searched
For E.g if record No.3 is searched then only i can update record no.3 and i don't want rest of data to be shown
now what is happening when i click on edit my whole table is being displayed
this is bcuz i made one method gridfill() which i m calling everytime if i m doing grid row editing,row cancelling and row updating
how i can resolve this thing
protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
GridView2.EditIndex = e.NewEditIndex;
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
string id = GridView2.Rows[e.RowIndex].Cells.Text;
t = (TextBox)GridView2.Rows[e.RowIndex].Cells.Controls;
string query = "update user1 set comments=@comments where id=@id";
SqlConnection con = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand(query, con);