SQL Server Tables

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...

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....

SQL Server tables - What account created the object

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

recovery when using sql tables

Recovery or rollback procedure when using SQL tables on AS400

Restoring a deleted table in SQL Server 2005

How do I restore a deleted table in SQL Server 2005?

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 :-)

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 ...

SQL Server 2000 Database Table Limit?

Is there a limit to how many tables a single database can hold in SQL 2000?

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...

Loading an XML file's dataset into an existing SQL Server 2005 table

I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?

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?

Optimizing a SQL Server stored procedure

I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of this...

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...

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?

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?

Finding a table's name from a trigger name in SQL Server

How can I find the related table's name from just a trigger name?

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?

Deny domain administrators to select from sql server tables ( SQL server 2005)

I have added the "domain admin" group to the Sql Server, and set permission as "Deny" to connect to the database engine. All employees of this group can still select from any table. The sql server "public" role does not have any permissions on any database table. The "domain admin " group...

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...

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?