In my Excel file, the value in F3 are integers, otherwise, it shows 'NULL' text. I want the DTS transmation will insert value NULL to the "regionid" column if the...

Just realize in order to make the recompilation happens, I have to execute my procedure. Am I right?

Steve:

I just used "sp_recompile" to compile the procedure and did not see the update of the table C back to A in my example. Any idea?

Steve:

How to re-compile a procedure?

I double check with couple levels of security associated with the read-only tables.

-- The primary file group the database in is not read-only;

-- the Access option of the...

I use the "exec sp_who2" to check, the databas is indeed used by me. And I need to restore the new data to this database, what is the correct way...

got it! Thank you.

Thank you all. Now I know how to create and execute a job in SQL Server.

However, I encounter another problem: when a job fails, I can't re-start it using "Start...

I found the real problem is that when I re-install the SQL Server, for some reasons, the debugger is not installed correctly/completely in my server. When I tried to use...

What do you mean "does not match the name of the job you are trying to run"? Where can I find the name of jobs?

Antare:

I paid special attention to the data access of the login I use to connect to the 2 databases. All the experienced I have, the only thing I can enforce...

Thank you very much, Sir.

This information will help.

Great, I try your suggestions and it works now. 🙂

I wander if I can use the same method to fix the missing REBBRUI.rll file. In this case, the file...

Anyone knows how long does the rebuild take?

I tried it last Friday. It only take 1 minutes for the rebuildm.exe to copy all the data files for master, msdb, tempdb,...

Gentlemen:

Thank you for the asistances.

I still have problem to identify the search function. Nothing is after "Contest" in the top navg. bar.

Andy, do you mind to send me the...