Re: SQL server rename

Hi,

This time out might be due to some other reasons. I feel that your
statistics might be outdated. Can you do 1 thing:-

1. Execute a update statistics for all tables (sp_updatestats)

2. Execute a DBCC CHECKDB on the database and analyze the log

Thanks
Hari
SQL Server MVP


"pm" <ppamco@xxxxxxxxxxx> wrote in message
news:OASDaPs1FHA.2540@xxxxxxxxxxxxxxxxxxxxxxx
> Hi All
> I am hoping someone has seen this problem before and can help me out.
> I had to rename the server that I am running sql server 2000 (SP4) on.
> After the reboot all seemed ok. I then ran the sp_dropserver'oldname' and
> sp_addserver'newname','local' commands. When I ran the select @@servername
> after rebooting I got the correct name back (as in the hostname was
> returned).
> I then ran up enterprise manager and deleted the old registration and
> added a new one. I could then connect and look at my databases. However
> when I right click on a database table (in enterprise manager) and select
> return all rows nothing happens. Eventually I get an ODBC error message
> saying there was a timeout error.
> If I use query analyser I can connect to the database no problem. If I
> then run a select statement on a table query analyser status goes to
> executing query batch job and never returns. I have to manually cancel the
> query before I see the results of my select statement.
> If I run the dropserver and addserver to rename the instance to the old
> hostname then enterprise manager and query analyser run fine.
> If anyone could tell me what is going on here I would be most
> appreciative.
>
> Many thanks
> Paul
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
> ASP.NET resources...


.

Relevant Pages

  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • RE: xp_cmdshell, ownership chaining, sql 2000
    ... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
    (microsoft.public.sqlserver.programming)
  • xp_cmdshell, ownership chaining, sql 2000
    ... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
    (microsoft.public.sqlserver.programming)
  • Re: Data migration questions?
    ... Use SSIS or the SqlBulkCopy class to import the data into SQL Server. ... Anyone who has read my books knows that I'm not in favor of including BLOBs in the database. ... "Mervin Williams" wrote in message ... should I use a DataSet to bring the data down to the local machine that will run the code and execute the transformation logic from it. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: User ID and Password in the Query
    ... Pro SQL Server 2000 Database Design - ... > How can I pass the user id and password in a simple SQL statement. ... I am logged into a database. ... Without logging into query analyser with his credentials(I had ...
    (microsoft.public.sqlserver.programming)