.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Where is the option to open a table in SQL 2008?

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server
 Now I just see open top 1000, or select ###

View Complete Post

More Related Resource Links

Under the Table: Programming with FileStreams in SQL Server 2008


There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.

Bob Beauchemin

MSDN Magazine May 2009

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

My repeating table did not open/load correctly

In my browser-enabled form I am using a webservice to get data from one look up table in my database. The table consists of two columns (ProdId and ProdDescription). In order to allow the user to select more than one products, I bind  this data to a repeating table where the productId column converted from a check box to a checkbox instead. So every row of this repeating table have a checkbox in the first column so the user can make selection and a textbox in the second column to list the Product Description. When the user open/load the existing form where multiple selection was made to the repeating table none of the checkboxs were checked. I have no idea how to go about to fix this issue and i can use some help. So far i have not use any codes for my form so i would like to stay codeless and using rules instead. Thank you in advance.

PIvot Table in SSRS 2008

Hi All, Is there any data Region (Pivot) in SSRS 2008 or higher version? Our requirement is to show the report like excel pivot gererated from a OLAP Cube where we can select or unselect any dimesion attribute or measures. Thanks, IndiaSQl  

Excel 2007 Pivot table OLAP- SSAS 2008 Error

Hi, I do have a strange issue with Excel 2007 pivot table report; the data source is SSAS 2008 cube. When refresh the excel 2007 report data using the 'Refresh All' or 'Refresh' button available under the Data menu, the below error is thrown. "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples." After some analysis, the report works well on the below workaround, 1. Remove all the calculated measures from report (3 measures in this scenario) 2. Remove one row label (dimension attribute) from report But the measures, attributes are valid one from cube and it is required fields in the report. So, understand that removing few items is not at all a solution. The below workaround also works. 1. Check the 'Defer Layout Update' option from the Pivot Table Field List window. 2. Click on the Update button After that Unchecked the 'Defer Layout Update' option and apply the filter, etc in the report. The report works very well. But every time, we need to use the above work around after open the excel report. I have NO clue on this issue. Please help to resolve this issue. Thanks, Jey


hi I Have deleted my sql table data (delete from employee) but this was a fault.i was suppose to delete data from other table what should i do to get my data back i have used (ROLLBACK select * from employee) to get my data back but it didnt help me.my DataBase recovery mode is also set to FUll ,still i am not able to get back my data Plaese Help me what query should i run?

sql server 2008 Table Partition

HI i want to implement partitioning in my sql server 2008 database table http://blogs.msdn.com/b/manisblog/archive/2009/01/18/easy-table-partitions-with-sql-server-2008.aspx   i have used this link. but when i try this link then i am able to create only primary file group no secondary file group..so help me also by fault i have created partition in wrong table .so i want to detete tha partition from that table but of i delete the PARTITION SCHEME and PARTITION FUNCTION THEN it throws error..so what shoul i do to remove partition from my current table

Powerpoint ppsx files open as read only in sharepoint with not option to edit

With Powerpoint 20007 in sharepoint(MOSS 2007) the PPSX files are opening in read only mode with no option to edit to be found. 2nd issue is ppsx files do not open on any persons computer as a show.  Is it possible to change this? How do I change this so I can edit the slides? Current "bad" solution is to save to local drive than upload them over the location  on sharepoint. This post was redirected by moderator from: http://social.answers.microsoft.com/Forums/en-US/pptshare/thread/9674b463-2195-4bbd-a2e7-526b8cfa4491

sql server 2008 Table Partition

HI http://blogs.msdn.com/b/manisblog/archive/2009/01/18/easy-table-partitions-with-sql-server-2008.aspx  i have used  above link to create partition,but my problem is i want to do partition on daily basic, one column in my table is date(by default has getdate()),on the base of this i want to do partition, eg.in this link i need to give time duration between which one can do partition, and also either daily or monthly or quarterly or yearly need to be specify ..if i give date between 01/08/2010 to 01/08/2012 and then select daily wise partition which i am in need then table create more than 700 partion but problem comes when i need to assign group to them how cud i select Primary file group more than 700 times to assign it to each partiotion.it becomes very lengthy process  Please help me

Open in new window option for Image Button

I am using an Image Button with onclientclick property set.Upon clicking the button I am able to navigate to URL page. But when I am right clicking on the Image Button I am not getting "Open in new window" or "Open in new tab". These options I see when I right click on an Hyperlink control.Can we achieve the same fro Image Button. If so how?Thank you,Praveen.

Partitioning a table in SQL Server 2008

Our application has got few tables which has grown to a larger size. Hence one suggestion put forward is to consider table partitioning. Since this does not involve any code changes in the application, we are looking into this option. 1. Is there any disadvantage if we use table partitioning feature 2. Will table partitioning affect the current indexes that exist on the table? 3. Database mirroring is enabled in our schema. Will partitioning have any effect on this? 4. Any suggestion on how we should try this out?  

how many open connection is recommended to leave - in sql server 2008 Enterprise Edition

hi i have my C# program that work with sql-server 2008 Enterprise Edition i have 40 users that connect to this database. i dont close the connection. how many open connection is recommended to leave ? or is it better to close connection ? thank's in advance

How to Add "Modified On" to my Table and View Listings (SQL 2008)

There is a "Create Date" - but I want to know when the last "Modify" date is in both Tables and Views.  is this even doable?  I think it was in SQL 2005RICHARDG

Visual Studio 2008 Asp.net Development Server Launches When use local IIS is project option

I have a visual studio 2008 asp.net MVC webapp project.  The project is set to use local IIS WebServer. When I run without debugging, it runs just fine.  However when i run with debugging Visual studio launches the Asp.net Development Server on top of IIS.  I would not care if it wasnt for the fact that any time i make a web request to the MVC Site it seems to be creating duplicate requests resulting in a very painful debugging experience.Thanks,Giovanni

Relate table using SSMS 2008 Express

Hello,How to add relationship between tables using SSMS 2008 Express?Thank You,-imperialx

Free or open source UML add-ons to Visual Studio 2008

Hi there, Like to know any open source UML tool, which can be added to Visual Studio 2008 as add on   Thanks,

Partitoning Table in SQL 2008 - Index

1. How is the index mainitained for a partitioned table?  2. Whether SQL Server has an overhead in maintaining INDEX in a partitioned table compared to a non-partitioned one? 3. If i insert few rows, does it affect the INDEX statistics in all partitions or only the affected partition. I would like to find out more details on how SQL Server manages INDEX on a partitioned table.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend