karthikeyan (4/23/2008)

Carl Federl

As "where (@Nm) is null" will always be false, zero rows will meet the

restriction....

He wants to specify the column name in a variable.

Because the variable @Nm is not null. It is equal to 'Age'

If you want to have a variable column specified in the where clause, you'll have to use dynamic SQL,...

That's not what spaceused is saying.

Spaceused lists your data size (the clustered index) as 12 GB. The page count confirms that.

What spaceused lists as index size is the total space...

You're referencing the table FDIT_SAP_AUC_IMPORT in the set and in the where, but it's not in the from.

Is this perhaps what you want?

update FDIT_SAP_IMPORT

set AUC=FDIT_SAP_AUC_IMPORT.auc

from FDIT_SAP_AUC_IMPORT

where FDIT_SAP_AUC_IMPORT.WBSnumber=FDIT_SAP_IMPORT.wbsnumber;

Can you post the entire query please, the table structure and all the indexes on it? Also, please save the execution plan as a .sqlplan file (right-click the exec plan,...

It might be. How many other indexes do you have on the table?

Run this and see what it regarding page count for the clustered index (index_id 1) and the other...

Maybe.

Can you post the entire update statement please?

Try connecting from full management studio, rather than management studio express.

You can install the workstation componenents alone on your client PC from the same DVD that you installed the server.

btw,...

Not that I know of. In SQL 2000, encryption means that the object cannot be scripted of modified without either having the original code, or decrypting the proc.

Especially in SQL...

It still works in SQL 2000 and later. What error are you getting?

This works fine in SQL 2005

CREATE PROCEDURE Test

WITH ENCRYPTION

AS

SELECT 1

ALTER TABLE <Table name>

ALTER COLUMN <Column name> DATETIME NULL

Make sure all the data in that column can be converted to date time, or you'll get some interesting error messges

A trigger fires when data in a table changes.

If you want to run something at a specific time, you need a job, set up within SQL agent. From the...

Express does not include SQL Agent, hence you cannot create or run jobs.

A trigger fires when a row is updated/inserted/deleted in a table.

From the sounds of it, you want to change data at a certain time. Is that correct?

I'm also not 100%...