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

Sorry, but I can not agree...

I'm not sure I follow.

Do you want the procedure to run at midnight? If so, you need a SQL job

A logon trigger is server wide. I'm not sure if at the point of login you can see what database the user is going to connect to. You'll have to...

View should be sufficient.

You'll be needing both CASE (the the not empty string) and ISNULL (for the NULLS)

Something like this (partial query only )

SELECT ...,

CASE WHEN ISNULL(CUST_NAME_RU,'') = '' THEN...

I can't see your hard drive. Image url - file:///h:/sql.bmp

Attach a jpg to your post.

SQL agent is installed and is running. Are you sysadmin on that server?

Are the queries written optimally?

Do you have appropriate indexes?

If the trace is still running, yuo won't be able to open the file. You'll have to stop the trace, or pause it and copy the trace file elsewhere, to...

What's the error you're getting?

I've never used Visual studio's database projects, so I can't be much help.

I don't see it as a vulnerability....

Move the subquery into the from clause and treat it as a derived table.

Something like

SELECT

[year],

...

I did.

DECLARE @sSQL NVARCHAR(100), @rowcount INT

SET @sSQL = 'select * from sysobjects'

EXEC sp_executesql @sSQL

SELECT @rowcount = @@ROWCOUNT

PRINT '@rowcount = ' + CAST(@rowcount AS VARCHAR(4))

Output in the messages tab -

(118...