Have you checked SQL Server Error Log? what does it say there?

Can you also provide some insert scripts to insert data into that table for testing at our end?

That would help to understand more.

I am curious, what does it stand for.

I am not sure of any automation for this.

Last time I had run into the same situation, I had to script detach and the attach for one database and...

SQL Jobs are for scheduling any task or process to reoccur at regular intervals (Daily, weekly etc).

Tasks or Steps in SQL Jobs can be anything from Activex Scripts, OS (Dos)...

Hi,

Can't you ask the file name created to be appended or prefixed with DDMMYYYY as 12112009 or MMDDYYYY format? That would save a lot lot of time for you.

What ever is there in table 3 is already available in Table1 so what else do you want to apply.

Because we could understand your problem and provide the solution everytime,...

You got it wrong...

The error log is in to the sql agent ?? if it does i have a new problem...

sql server agent is disabled, i´ve used the configuration manager to reboot the...

Do you see the SQL and other services you chose install are available in SQL Configuration Manager?

Do you see Business Intelligence Development Studio (BIDS) or Visual Studio 2005 etc, if...

So you mean to say you want the 1st Table be line this after update?

table1

AcctNo OfficerID Address

111 FADCDG ...

I do not think that you can share the Data / Log Files between 2 different servers at the same time.

Instead have use Replication on the OLTP and see that...

If the entire Windows Machine reboots, have your System Engineers/ Admins not been able to find what's wrong with it, rather than a SQL guy trying to figure it out.

SQL 2005 comes with Management Studio.

Do you see that?

I have not done an inplace upgrade of the SQL 2000 Express Edition to 2005 Std.

But when looked at MDSN

http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx

It does not show that upgrade path exists, which means you...