Writing a hidden trigger against a SQL table

How do I write a hidden trigger against a SQL table?

SQL Server Ask the Experts2,585 pointsBadges:

Recovering a truncated table on a SQL Server

How can I recover a truncated table on a SQL Server?

SQL Server Ask the Experts2,585 pointsBadges:

Matching key question in SQL Server

Hi, Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3...) Col2 has letters (AA, Aa, aA, aa, AB etc) I need to use Col2 to join to Tab2...

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

Restoring a deleted table in SQL Server 2005

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

SQL Server Ask the Experts2,585 pointsBadges:

How to split a column into SQL data..

I have table called  country having one column called complete_name (varchar(max)) which is as under   [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent;...

Anamika8315 pointsBadges:

SQL Server 2000 Database Table Limit?

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

Xarly25 pointsBadges:

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

SQL Server Ask the Experts2,585 pointsBadges:

Upload Excel to SQL Server Table

I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table....

WorkAround5 pointsBadges:

Reading xml url into SQL Server 2008 Table with OpenXML

I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url as text into my sql table.  My...

Rscheinberg595 pointsBadges:

Writing a query to store an image file in a SQL Server 2005 table

How would I write a query to store an image file in a SQL Server 2005 table?

SQL Server Ask the Experts2,585 pointsBadges:

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?

SQL Server Ask the Experts2,585 pointsBadges:

SQL Server 2008 R2: User table with clustered indexes

I recently found that a couple of my tables in SQL Server 2008 R2 with no clustered indexes defined. However, there are non-clustered indexes defined (so basically they're on HEAP). After I did some searching, I learned that some select statements were using a filter on the columns defined (in...

ITKE1,152,330 pointsBadges:

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

IgorS5 pointsBadges:

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?

SQL Server Ask the Experts2,585 pointsBadges:

SQL Server 2008: INSERT statement

One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?

ITKE1,152,330 pointsBadges:

Looking to create and populate a numbers table in SQL Server 2005

Now in SQL Server 2005, I know there are different ways to create and populate a numbers table. But, what's the best way? I'm looking for the best way to optimize these characteristics:Table created with optimal indexingrows generated fastestsimple code used to create and populate

ITKE1,152,330 pointsBadges:

How can we add a column (with a default value) to a table in SQL Server 2005?

Our business is using an older version of SQL Server (2005 in fact) and all we're trying to do is add a column, with a default value, to an existing table. Can someone point us in the right direction?

ITKE1,152,330 pointsBadges:

SQL Server 2008: Query for names

Now in SQL Server 2008, is there a way that I can query for names in all tables that contain the column with name. Something along these lines:%myName%

ITKE1,152,330 pointsBadges:

Auto-increment in SQL Server 2008 R2

I've just created a new table in SQL Server 2008 R2 and I'm trying to get the index on auto-increment. Is there a way to do this?

ITKE1,152,330 pointsBadges: