Sergiy,

The link you have posted is ok. But there the user knew atleast his column name. Here it looks like our friend neither knows the column name nor the table...

you have a procedure named sp_tables that will list the tables in the database. but unless and otherwise you know exactly what columns and tables to be used in your...

An update statement as given below should be ok. check and let me know.

update test1

set test1.col2 = test2.col2,

test1.col3 = test2.col3

from test1,test2

where test1.col1 = test2.col1

Are you trying to install it in a cluster environment?

I tried using the sp but could not find what i exactly wanted. i want to get the time for last few transactions might be before an hour or so.

use trace flag -T3608 in the startup of sql server. This will only start your master database. Once the SQL server starts in this mode alter the tempdb location and...

The problem might occur if you use non-ansi joins anywhere in your procedure.

You can alter the database path using alter database command and then once you give the correct path of the tempdb database restart sql services that should be running fine.

Check what is the type of the backup. I think you are trying to restore a diff backup without restoring a full backup.

Starts and then stops:

Does the SQL Server service run for few mins and then stops or it stops immediately. This might be a problem if the needed permissions for the...

did you try starting the mail session with xp_startmail. If so did that throw any error. Please try that and let us know whats the error that posts in when...

OPENROWSET makes a connection to the remote server only for the period that connection requesting is open where as LINKED server is configured to access the remote server anytime and...

Check whats the size of log file. That might occupy more space than what you have expected.

There is a tool in SQL 2005 that can be used to check any differences with tables called tablediff. Check if that statisfies your req. If not you can use...

SQL server fails to access resources in network with local users. Instead use a domain id to access the network resource and check if that succeds.