Strange Error in DB - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Strange Error in DB

Author

Topic

srivatsahg
Yak Posting Veteran

71 Posts

Posted - 2009-09-02 : 03:18:40

Hello Forum

I have a strange issue w.r.t database on our system.
The moment I launch my server application which accesses the database, at all starts, I have this into a log file

08:30:45.890 SELECT * FROM [dbo].[SomeTable] WHERE MetaName = 'IsBasic'
The MetaName is a column in the table SomeTable

Could not find server 'HotServer\SQLEXPRESS' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

So, I made this command:
sp_addlinkedserver 'HotServer\SQLEXPRESS'

And some like (That I found on a forum):
sp_dropserver 'HotServer\SQLEXPRESS'
sp_addserver 'ONE', local
then, I restarted the server

Finally, I have another error (again, at every start):
08:30:45.890 SELECT * FROM [dbo].[SomeTable] WHERE MetaName = 'IsBasic'
>> The cursor does not include the table being modified or the table is not updatable through the cursor.
>> The statement has been terminated.

Any ideas what is happening here

Regards
Srivatsa

Do you have any idea about that?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-09-02 : 05:19:09

where are you executing this from?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources