In SQL 2005, you can use the SMO objects to create your database, table, column and more others. The code for the same is available in microsoft virtual labs sessions...

Yes of course.

70-431 for MCTS

70-447 for MCITP(Remember that MCTS is mandatory for this.)

Those are used when you want to create fulltext indexes in a table. To know more read full text index in bol.

The link below lists the availabl path for upgrade please check

http://msdn2.microsoft.com/en-us/library/ms143393.aspx

Your insert statement itself seems to be wrong. It should be

insert into #temp select col1,..coln from tablename.

You can't create a table with the same name. If you would like to take backup of tables daily or periodically then you can use the script written by me...

In SQL Server 2000, you need sysadmin privilege to run profiler. The same is not the case with SQL 2005.

When you use local account yu can't access resources in network. Better change the account running your sql server and agent to a domain/workgroup account and grant the necessary permissions...

Just check if the given code below does work for you.

select substring(convert(varchar(30),getdate(),109),13,len(convert(varchar(30),getdate(),109)))

If you have additinal hardware try implementing log shipping. But to take log back the recovery model should be either bulk-logged or full. You can't take a log backup in...

Possibly the network bandwidth is veryvery slow. You can check these with the performance monitor counters that are avialable with the windows operating system.

Just change those settings and try executing the job to see if it succeeds.

A trigger, linked servers should be fine for your effort did you try that.

Just stop your SQL server service. thats enough. SQL server service closes all connections and then stops so there is no need for you to manually close all existing connections....

Yes as told by michael you have to reinstall .Net framework 2.0. Also go ahead with a clean installation of client tools from the machine you try to connect.