Hi

Can you elaborate a little more the question ?? time out for what kind of querys, connection, etc ??

Here some info., right click on the server name, select properties, tab connection, in the...

Hi, i get the error some time before, and the problem was a change in sql authentication... was changed to windows aut..

Check this link, may be help you

http://support.microsoft.com/default.aspx?scid=kb;en-us;225129

http://support.microsoft.com/default.aspx?scid=kb;en-us;238477

Well one suggestion is, stop SQL, backup o rename tempdb.mdf and tempdb.ldf files, then copy the original files from SQL installation CD.. start the sql ,, check if the error appear......

UPDATE tblSiteReview SET tblSiteReview.blnNonCompliant = True

from tblSite,tblSiteReview--,INNER JOIN tblSiteReview ON tblSite.tblSitePK = tblSiteReview.tblSiteFK

WHERE (((tblSite.intStatus)=2) AND ((tblSiteReview.dtmReviewDate)>[tblSiteReview].[dtmExpDate]))

Hi..

Check the next doc

http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

Hi,,

When you execute a query two or tree times, the statistics of the query is in "cache"  and the next times is excuted more quickly.

When you run the execution plan is some icon with high...

i did the same and works fine for me ... strange thing, may be something is wrog in the second computer, try in a third computer

hi

And then shrink the file if the log file size is very large using dbcc shrinkfile o in sql 2000 throught EM

.

Hi

Yes one easy way is configure the trace with the following filters, use:

databaseid

loginname

 and exclude all other users in the database

objectid

Try this and let me know any doubt

thnks

Ok, in this case, yes, you still using your actual process,

but you can write some lines for a job to check the run_status in sysjobhistory in msdb for each job and send email...

You can't be able to add a default instance in the second node o virtual server, from BOL -->

Naming a Virtual Server

SQL Server 2000 depends on distinct registry keys and service...

thanks, 1 more question

-is the user mjane a domian account ?? Local 

HERE THE QUESTION-->The account is local in the SQL server o is locally created in the clients machine

In client...

You can use a database maintenance plan, it create a job for backup, and each back up file is named like, databasename_date.bck..

in the maintenance you can specify how many day to maintain for recovery..

try this  .., in the old profile open a mmc an then open microsoft sql enterprise manager from the snap-in, check that all servers are listed, then file save as...

Well need more data, but

-is the user mjane a domian account ?? 

-is the account domain\mjane a user in the sql security and assigned to some database??

-how is the users connecting, QA,...