You searched for the word(s): userid:804844

More Search Options

RSS Available

• Re: Cannot connect to SQLEXPRESS

  i suggest you try to ping that server to make sure you really can connect to it. there are lots of reasons behind ur error message.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by someguy198650 on 12/23/2009

• Re: Cannot connect to SQLEXPRESS

  [quote user="BCRose"]It says that it did not start in a timely manner.[/quote] http://mohammedfauzi.blogspot.com/2009/02/service-did-not-respond-to-start-or.html http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351055 Since the user does not have permission to start the service, the exception occurs. But sql server should display the actual windows error message like 'Access denied' or something else. But sql server gives an unhandled exception, HTH

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by someguy198650 on 12/23/2009

• Re: Dynamic sql

  hello, As the execption said "Must declare the scalar variable "@var1"" exec sp_executesql N 'select @var1= ... from table where ...' , N '@var1 as varchar(50)' , 'put ur value here'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by someguy198650 on 10/23/2009

• Re: divide by zero error in sql

  SELECT Value = CASE WHEN persms != 0 THEN cost / persms ELSE persms END FROM table

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by someguy198650 on 10/23/2009

• Re: Dynamic sql

  use the third parameter on sp_executesql to assign ur values. sp_executesql N'select @var1=... from tab1 where ...' , --1st param N'@var1 decimal(18,3)' , --2nd param (Parameter Definition List) @ParmeterThatExistInTheSP --3rd param (Parameter Definition Values)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by someguy198650 on 10/23/2009

• Re: getting selected value from the table

  isn't that as simple as: <asp:GridView ID="Gridview1" runat="server"> <Columns> <asp:TemplateField> <ItemTemplate> <asp:HyperLink ID="HLnk" runat="server" Text='<%# Eval("Name") %>' NavigateUrl='<%# "~/mySecondPage.aspx?Id=" + Eval("Id").ToString %>' /> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> on the second page, page load

  Posted to Data Presentation Controls (Forum) by someguy198650 on 10/22/2009

• Re: EXECUTE permission was denied on the object 'myStoredProc', database 'myDB', schema 'dbo'.

  hello, can you try: --> Right click on the database --> Data base properties-XXXXXX(database) --> Click on permissions --> Explicit permissions for user --> Check execute on the grant column

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by someguy198650 on 10/22/2009

• Re: EXECUTE permission was denied on the object 'myStoredProc', database 'myDB', schema 'dbo'.

  If you want to limit a user to do a certain action like only executing an sp and not to be able to do a direct insert, then you can grant permission 'execute'. may be you can spare sometime & recheck, Grant permission to 'Insert' then do an insert stament, afterwards do an update.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by someguy198650 on 10/22/2009

• Re: failed to access IIS metabase

  http://geekswithblogs.net/narent/archive/2007/03/23/109573.aspx

  Posted to Installation and Setup (Forum) by someguy198650 on 10/5/2009

• Re: Check null in stored procedure

  Added to ram_s solution will be: If @ID is not null and Len(@ID)=0 Set @ID = null If @Search is not null and Len(@Search)=0 Set @Search = null Select * From TableName Where (@ID is null OR Id=@ID ) AND (@Search is null OR Search=@Search )

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by someguy198650 on 9/16/2009