• Hiding the system views table from Microsoft Access

    How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error when insertin.g data into SQL table

                    I'm using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I'm having a problem of inserting data into one of the tables in my database through my VB.NET application. I...

    Obhasha0795 pointsBadges:
  • SQL Server 2005 question self join query

    I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ------------ ----------- Book Commerce Commerce Accounting Science Math Commerce B.O. Material Pen Pen Link Pen Renolods I want ouput...

    Kotnimahesh5 pointsBadges:
  • SQL Server tables – What account created the object

    Is there a way to see who created or droped a table in sql server?

    Rick Martinez585 pointsBadges:
  • recovery when using sql tables

    Recovery or rollback procedure when using SQL tables on AS400

    Ragenrags10 pointsBadges:
  • FirstIAM page of a table in SQL Server 2005

    Hi, Can you please explain how is the "FirstIAM page of a table" is calculated in the sysindex view, in SQL server 2005. Is is stored in some system table or is it calculated every time a table is accessed? Pardon me if this sounds to be a stupid question.I am new to SQL server 2005 :-)

    JudeAj5 pointsBadges:
  • query for join

    i have 2 tables unittypes,rules unittypes has unitid and description unitid description A1 description1 A2 description2 A3 description3 rules has id unitid 1 A1,A2 2 A1,A3 i am trying to get it to get a resultset like 1 description1,description2 2 description1,description3 the sql i wrote was...

    Rampradeep5 pointsBadges:
  • Left outer join

    I have 5 related tables. The main table is meeting. The other tables are participant_meeting, vendor,user_id, address. I need the meeting information and the particpant who attentds the meeting(participant_meeting), and their address(address) the vendor for the meeting (vendors) , user_id for the...

    Niveanand5 pointsBadges:
  • Retrieving and adding data to tables on different SQL Servers

    Is it possible to retrieve data from two tables, located in two different SQL Servers in one domain, and then add the data and save the result in another table in a third SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Deleting in a complicated data structure on SQL Server 2000

    I have a complicated data structure on SQL Server 2000 which, at times can go four levels deep. It is all designed using foreign keys, as expected. I am having difficulty getting deletion to work from the top level, which is an orders table. Some child tables have cascade deletes on, and some are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Configuring SQL Server to not lock tables when using the SELECT statement

    Is there a way to configure SQL Server to not lock tables where I am using the SELECT statement, so as to not have to writte "with NOLOCK" every time I use SELECT?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to correctly view overlapping SQL Server tables

    I want to overlap two SQL Server tables, and when I do, it is visible in Report Preview. When I run the report in a browser, however, the second table starts only when the first ends. Also, when I view them as a PDF, they show properly. Any ideas?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using SSIS to populate SQL Server Data Warehouse

    I am just wondering if anyone has tried using SSIS to extract data from iseries tables to insert into Sql Server tables?

    RodVerity20 pointsBadges:
  • Creating a summary table in SQL Server

    I need to create a summary table for the combination of some fields in a SQL Server table. I have the combination field value and the source table name in one SQL table as a row value. I need to pick this value and then fire a query on a source table with extracted values from the SQL table. How...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Dumping a table in a SQL Server database

    How can you dump a table in a SQL Server database and convert the script into text?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Data updation issues in a SQL Server table

    I have accidentally updated all data in a SQL Server table according to one data source, and now all my data is a copy of that data. How can I make a command to allow all data in that table to search for other data and update, according to another reference table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • An alternative to using triggers on a SQL Server

    I am using triggers to update two similar tables on a SQL Server. Is there any other method to do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error uploading records into a SQL Server table

    We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Transposing a table using SQL Server Reporting Services in VB.NET

    How can I transpose a table using SQL Server Reporting Services in VB.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding an index on fields in a SQL Server table

    I have a massive customer table. The ID is the primary key and thus SQL Server makes a clustered index on that. There is no other index on the table. Can I add an index on fields like age, country and gender to make the results faster?

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following