[web Service] Rename a Report

i try to rename a report with web services.
i used ReportingService2005.SetProperties Method but when
i try with
Property.Name = "Name";
Property.Value = "myNewName"
i can't update the report name => RS2005 say the property 'name' is readonly
this method is ok with property "description"
How todo to rename report ?On Mar 16, 3:55 am, jeff <j...@.discussions.microsoft.com> wrote:
> i try to rename a report with web services.
> i used ReportingService2005.SetProperties Method but when
> i try with
> Property.Name = "Name";
> Property.Value = "myNewName"
> i can't update the report name => RS2005 say the property 'name' is readonly
> this method is ok with property "description"
> How todo to rename report ?
There are a couple of different ways to do it. Either change it in the
Properties tab in the Report Manager -or- change it at the file level.
So programmatically (option 2), you could do something like this in a
stored prcoedure that the report is using, etc:
exec xp_cmdshell 'rename c:\OriginalReportName.rdl NewReportName.rdl'
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||i wouldlike use Webservice ..... ( i create a soft that manage reporting
services 2005 with webservices )
"EMartinez" wrote:
> On Mar 16, 3:55 am, jeff <j...@.discussions.microsoft.com> wrote:
> > i try to rename a report with web services.
> >
> > i used ReportingService2005.SetProperties Method but when
> > i try with
> > Property.Name = "Name";
> > Property.Value = "myNewName"
> > i can't update the report name => RS2005 say the property 'name' is readonly
> > this method is ok with property "description"
> >
> > How todo to rename report ?
> There are a couple of different ways to do it. Either change it in the
> Properties tab in the Report Manager -or- change it at the file level.
> So programmatically (option 2), you could do something like this in a
> stored prcoedure that the report is using, etc:
> exec xp_cmdshell 'rename c:\OriginalReportName.rdl NewReportName.rdl'
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>

[URGENT] Problem to Restore Database from backup

Mrs,

I'm having a serious problem in SQL 2000 SP3 Database which is used Business Applications.
Today, I tryied to take backup in service time by the Enterprize Manager, the following
error occured and could not take backup.
--
Error 926 : Database '[database name]' cannot opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information.
--
After that, we tried same operation 3 times. But result is same.

After sometime, end-user report us that they can not log-in to database.

So we tried to dettach this database and attached it.
We success to dettach, but we can not attached it.

Also we tried to restore this database from Yesterday's backup file by using Enterprize Manager,
but the following error occured, and could not complete.
This backup file was generated daily backup task in Maintenance Plan in Enterprize Manager.
--
Microsoft SQl-DMO(ODBC SQLState:42000)
The media family on device "E:\ccd\......xxx.bak" is incorrectly formed.
SQL Server cannot process this media family.
RESTORE DATABASE is terminating abnormally.

--

We need to recover the database immediately not to stop the end-user business process.
Please help us.

Yamagury.

refer , http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1977204&SiteID=1 try as suggested and get back.... also you need to apply SP4 or go to sql 2005 as sql 2000 sp3 has ended its life cycle in july 10th 2007 itself....

refer

http://support.microsoft.com/gp/lifesupsps

|||Thank you for your support.

Yes, We already tried to apply SP4.
But this problem was not solved.

Now I'm trying to do as your instruction.|||(you had to back up the transaction log before you perform any restore operations and hadn't detach it before.

You had to verify your backup with RESTORE VERIFYONLY statement .)

use RESTORE HEADERONLY and see if you have multiple backup files in the the same backup file. If yes then
try using FILE= option while restoring.

File is from :

RESTORE DATABASE { database_name | @.database_name_var }
< file_or_filegroup > [ ,...n ]
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [ , ] FILE = { file_number | @.file_number } ] .....

see Books Online

(Why do you have not SP4?

Read this.)

|||
Dear Deepak

I tried to create database and swap mdf/ldf file.
and go into single user mode, and then run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS,

but, DBCC command return error. Database could not be repaired.

How can I do after this?|||

Ok you can try as follows,

Alter database DBname set emergency

this will bring your db into emergency mode so that you can access your db and then subsequently export the datas alone from this db to another db so that you can minimize the dataloss.....if you have a full backup then drop this suspect database and restore it from full backup but there will be dataloss to minimize it set the db as emergency mode and export the tables,sps etc which you feel is required to another db in UAT server and script those and rerun the script in the restored db

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[Performance Discussion] To schedule a time for mssql command, which way would be faster a

1. Use mssql server agent service to take the schedule
2. Use a .NET windows service with timers to call SqlClientConnection

above, which way would be faster and get a better performance?I don't think you'll see any performance difference.

but go with agent.|||ok, but will have a difference when busy

[HELP] How can I start an Analysis Services service

Hi all,

at Surface Area Configuration in my SQL Server 2005 I noticed that I have Database Engine, Reporting Services and SQL Server Browser services. I want to deploy a cube modelled at SQL Server Business Intelligence Development Studio and I'm getting connection errors.

I checked at Management Studio that I don't have an instance of Analysis Services. Only Database Engine and Reporting Services.

How can I create an instance of Analysis Services.

Does anyone could help me please?

Thanks a lot.

Another way to verify if you have Analysis Services installed or not, is to look in Services for "SQL Server Analysis Services". To install it, re-run the Setup and there is an option for Analysis Services.

Adrian Dumitrascu

[264] An attempt was made to send an email when no email session has been established

Hi

I have go an integration service package which sends email on completion of the package. It is not a notification email. The email is being sent from the integartion service package.

The package is being scheduled using SQL Agent Job scheduler. It has few steps each and every step sends a mail on completion and then it moves to the next step. If i run each step seperately. It completes the job and fails when sending the email.

Giving the error

[264] An attempt was made to send an email when no email session has been established.

The wierd part is that sometime it sends but some times it does give me this error.

Any help in this regard is very much appreciated.

Thanks

Mani

Please refer the below link. This should help

http://blogs.msdn.com/gopsdwarak/archive/2006/04/25/583434.aspx

[2.0] web service method to list the reports ?

Hello,

I'd like to use the Reporting Services 2005 Web Service to list all the reports on the server, but I don't know which method to use ?
I found many web methods to do all sort of things but not to get a list of reports.

Any idea ?

Ok I found the method of the Reporting Web Service : ListChildren(...)

But when I make a call to the WS on my web app, I got the error :HTTP status 401: Access Denied.

My Web App use Form authentication.
My ASPNET user is member of the ReportinsServicesWebServiceUser role so it should work.

I try to use impersonation, but still the same result...

|||

Have you tried allowing anonymous access to the site in IIS and adding

service.Credentials = System.Net.CredentialCache.DefaultCredentials

in code?

|||

I tried this and it's ok !

There was another security problem with RS which make a DCOM access to NetMan component with Network Services account.

Weird but it seems ok now, thanks.

[165]ODBC Error 0 Timeout expired[SQLSTATE HYT00]

sql server 2000 8.00.194
Microsoft Windows 2000 Service Pack 2

I looked into my sqlserver agent log and found the following

ODBC Error 0 Timeout expired[SQLSTATE HYT00]
logon to server local '( failed)' (Job manager)

I have no idea what that means but it did keep out users for a minute or more.
The threads found on this forum almost all point to reccuring situations
mine is a sporadic one time issue.
Is it Ok to conclude it is a network error as I did?

TIA
VinceVincento Harris (wumutek@.yahoo.com) writes:
> sql server 2000 8.00.194

That's an SQL Server with no service pack. I strongly encouarge you to
download and install Service Pack 3.

> I looked into my sqlserver agent log and found the following
> ODBC Error 0 Timeout expired[SQLSTATE HYT00]
> logon to server local '( failed)' (Job manager)
> I have no idea what that means but it did keep out users for a minute or
> more. The threads found on this forum almost all point to reccuring
> situations mine is a sporadic one time issue.
> Is it Ok to conclude it is a network error as I did?

This may be a correct conclusion in the end, but it is not the most likely.

The ODBC error "Timeout expired" means that a query did not start to
return rows with the timeout period, which by default is 30 seconds.
The reason for this could be that the query itself needed longer time
to execute, because of large amounts of data to search and/or poor
indexing. It could also be that the query was blocked by another query,
and that query was long-running. In fact it does not have to be a query
as such that was blocking, but a process holding locks because of
an earlier abandoned query, which was not properly handled.

All this could have been started by some abnormal event like a
network glitch. However, it is much more likely that there was
some inappropriate SQL statement somewhere.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

@@Version still shows Service Pack 1

We just installed the service pack 2 to our server, so I did a select @.@.version but it's still say Service Pack 1, even though the version number is now 3054. Is that a bug in the service pack?

Thanks.

Can you post the entire string returned by SELECT @.@.VERSION? My guess is that you are seeing the Windows OS Service Pack that is also included in the @.@.VERSION call. SQL Server should return SP2.

Thanks,

Sam Lester (MSFT)

|||Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
|||

Yeah, the SP1 in this case refers to your Windows Version:

Windows NT 5.2 (Build 3790: Service Pack 1)

The Service Pack level apparently isn't listed in the @.@.VERSION as I thought it was. Build 3054 is definitely SP2, but you can also check Add/Remove Programs report or the setup regitry hives to confirm.

Thanks,
Sam Lester (MSFT)

|||
Thanks for your help.

@@Version not updating

Greetings,
I recently installed Service Pack 4 on SQL 2000. The install went
smooth with no errors and a message at the end stating the install
completed successfully. I rebooted the server (Windows Server '03) and
tried to check the @.@.Version global variable but it still lists only
Service Pack 1.
Could it be that SP4 didn't install? Or is it more likely something
else is preventing the @.@.Version from updating?
Thanks in advance,
BenHi Ben
What do you get from
SELECT SERVERPROPERTY('ProductLevel')
HTH
Kalen Delaney, SQL Server MVP
"sullins602" <ben.sullins@.gmail.com> wrote in message
news:1152814872.081466.270730@.s13g2000cwa.googlegroups.com...
> Greetings,
> I recently installed Service Pack 4 on SQL 2000. The install went
> smooth with no errors and a message at the end stating the install
> completed successfully. I rebooted the server (Windows Server '03) and
> tried to check the @.@.Version global variable but it still lists only
> Service Pack 1.
> Could it be that SP4 didn't install? Or is it more likely something
> else is preventing the @.@.Version from updating?
> Thanks in advance,
> Ben
>|||Hi Ben,
Looks like @.@.version does not show the SQL Server service pack number but a
version number. Check for a number like 8.00.2039. Probably the service pack
listed is for the operating system.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"sullins602" wrote:

> Greetings,
> I recently installed Service Pack 4 on SQL 2000. The install went
> smooth with no errors and a message at the end stating the install
> completed successfully. I rebooted the server (Windows Server '03) and
> tried to check the @.@.Version global variable but it still lists only
> Service Pack 1.
> Could it be that SP4 didn't install? Or is it more likely something
> else is preventing the @.@.Version from updating?
> Thanks in advance,
> Ben
>|||Thats it! I was looking at the service pack for the OS not the
database. Thanks for your help fellas...
-ben

@@Version not updating

Greetings,
I recently installed Service Pack 4 on SQL 2000. The install went
smooth with no errors and a message at the end stating the install
completed successfully. I rebooted the server (Windows Server '03) and
tried to check the @.@.Version global variable but it still lists only
Service Pack 1.
Could it be that SP4 didn't install? Or is it more likely something
else is preventing the @.@.Version from updating?
Thanks in advance,
BenHi Ben
What do you get from
SELECT SERVERPROPERTY('ProductLevel')
--
HTH
Kalen Delaney, SQL Server MVP
"sullins602" <ben.sullins@.gmail.com> wrote in message
news:1152814872.081466.270730@.s13g2000cwa.googlegroups.com...
> Greetings,
> I recently installed Service Pack 4 on SQL 2000. The install went
> smooth with no errors and a message at the end stating the install
> completed successfully. I rebooted the server (Windows Server '03) and
> tried to check the @.@.Version global variable but it still lists only
> Service Pack 1.
> Could it be that SP4 didn't install? Or is it more likely something
> else is preventing the @.@.Version from updating?
> Thanks in advance,
> Ben
>|||Hi Ben,
Looks like @.@.version does not show the SQL Server service pack number but a
version number. Check for a number like 8.00.2039. Probably the service pack
listed is for the operating system.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"sullins602" wrote:
> Greetings,
> I recently installed Service Pack 4 on SQL 2000. The install went
> smooth with no errors and a message at the end stating the install
> completed successfully. I rebooted the server (Windows Server '03) and
> tried to check the @.@.Version global variable but it still lists only
> Service Pack 1.
> Could it be that SP4 didn't install? Or is it more likely something
> else is preventing the @.@.Version from updating?
> Thanks in advance,
> Ben
>|||Thats it! I was looking at the service pack for the OS not the
database. Thanks for your help fellas...
-ben

@@servername NULL

I am running SQL 7 Standard on a W2K server, both at the most current
service packs. After applying the lastest security update to Windows
and rebooting the server, SQL has suddenly fogottern its name - SELECT
@.@.SERVERNAME returns NULL. In conjuction with this loss of identity,
various maintenance plan jobs seem to hang and never complete. This is
wreaking all sorts of havoc with my backups since none of them complete
successfully.
Will the sp_dropserver/sp_addserver combination fix the NULL problem?
Is there anything else I need to do?
Thanks,
M. E. HoustonYes...the dropserver, addserver should clean it up.
If you query the system table sysserver, you will probably
find that there isn't a server with the srvid = 0. The 0 is
used for the local server. If there is an entry for the
local server and srvid is not 0, you can remove it with
sp_dropserver. Uisng sp_addserver with 'local' adds the
server with the srvid = 0. If you don't specifiy 'local',
it's not added with the 0 for srvid.
-Sue
On Tue, 30 Sep 2003 11:19:09 -0500, meh
<margit.houston@.no_spam.gsiusa.com> wrote:
>I am running SQL 7 Standard on a W2K server, both at the most current
>service packs. After applying the lastest security update to Windows
>and rebooting the server, SQL has suddenly fogottern its name - SELECT
>@.@.SERVERNAME returns NULL. In conjuction with this loss of identity,
>various maintenance plan jobs seem to hang and never complete. This is
>wreaking all sorts of havoc with my backups since none of them complete
>successfully.
>Will the sp_dropserver/sp_addserver combination fix the NULL problem?
>Is there anything else I need to do?
>Thanks,
>M. E. Houston|||This solved my server name problem, but I'm still having
issues with jobs created by maintenance plans hanging. In
order to make them stop, I have to kill the process. When
I do that, the following message gets written to the log --
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0:
[Microsoft][ODBC SQL Server Driver][Shared Memory]
ConnectionRead (recv()).
[Microsoft][ODBC SQL Server Driver][Shared Memory]General
network error. Check your network documentation.
-- Anyone have any clue as to what this really means?
Thanks,
Margit
>--Original Message--
>Yes...the dropserver, addserver should clean it up.
>If you query the system table sysserver, you will probably
>find that there isn't a server with the srvid = 0. The 0
is
>used for the local server. If there is an entry for the
>local server and srvid is not 0, you can remove it with
>sp_dropserver. Uisng sp_addserver with 'local' adds the
>server with the srvid = 0. If you don't specifiy 'local',
>it's not added with the 0 for srvid.
>-Sue|||Just curious based on the first issue and not sure if it's
the issue or not but did you by any chance rename the server
after the jobs were created? Do you have any problems
changing, modifying jobs?
-Sue
On Thu, 2 Oct 2003 13:22:09 -0700, "M. E. Houston"
<margit.houston@.no_spam.gsiusa.com> wrote:
>This solved my server name problem, but I'm still having
>issues with jobs created by maintenance plans hanging. In
>order to make them stop, I have to kill the process. When
>I do that, the following message gets written to the log --
>[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0:
>[Microsoft][ODBC SQL Server Driver][Shared Memory]
>ConnectionRead (recv()).
>[Microsoft][ODBC SQL Server Driver][Shared Memory]General
>network error. Check your network documentation.
>-- Anyone have any clue as to what this really means?
>Thanks,
>Margit
>
>>--Original Message--
>>Yes...the dropserver, addserver should clean it up.
>>If you query the system table sysserver, you will probably
>>find that there isn't a server with the srvid = 0. The 0
>is
>>used for the local server. If there is an entry for the
>>local server and srvid is not 0, you can remove it with
>>sp_dropserver. Uisng sp_addserver with 'local' adds the
>>server with the srvid = 0. If you don't specifiy 'local',
>>it's not added with the 0 for srvid.
>>-Sue|||Sorry for the delay in reply.
I did not have any problems making changes to any of the
jobs/maintenance plans either before or after I renamed the server. I
thought the problem might have been a naming issue so I deleted all the
maintenance plans and all the jobs I had created and started over. The
new jobs under the correct server name still exhibit the same bad
behaviour. There doesn't seem to be any consistency as to where in the
job stream things fall apart, i.e., which database in the backup job it
hangs on. On some occassions, the jobs even complete as expected.
Thanks,
Margit
Sue Hoegemeier wrote:
> Just curious based on the first issue and not sure if it's
> the issue or not but did you by any chance rename the server
> after the jobs were created? Do you have any problems
> changing, modifying jobs?
> -Sue|||Sorry for the delay in reply.
I did not have any problems making changes to any of the
jobs/maintenance plans either before or after I renamed the server. I
thought the problem might have been a naming issue so I deleted all the
maintenance plans and all the jobs I had created and started over. The
new jobs under the correct server name still exhibit the same bad
behaviour. There doesn't seem to be any consistency as to where in the
job stream things fall apart, i.e., which database in the backup job it
hangs on. On some occassions, the jobs even complete as expected.
Thanks,
Margit
Sue Hoegemeier wrote:
> Just curious based on the first issue and not sure if it's
> the issue or not but did you by any chance rename the server
> after the jobs were created? Do you have any problems
> changing, modifying jobs?
> -Sue|||Can't tell you for sure why the jobs randomly hang - I've
seen jobs hang when they attempt to send mail and there are
problems somewhere in the mail configuration. You could run
profiler or a trace to try to track down what specifically
is going on when the jobs hang.
-Sue
On Wed, 08 Oct 2003 08:53:32 -0500, meh
<margit.houston@.no_spam.gsiusa.com> wrote:
>Sorry for the delay in reply.
>I did not have any problems making changes to any of the
>jobs/maintenance plans either before or after I renamed the server. I
>thought the problem might have been a naming issue so I deleted all the
>maintenance plans and all the jobs I had created and started over. The
>new jobs under the correct server name still exhibit the same bad
>behaviour. There doesn't seem to be any consistency as to where in the
>job stream things fall apart, i.e., which database in the backup job it
>hangs on. On some occassions, the jobs even complete as expected.
>Thanks,
>Margit
>Sue Hoegemeier wrote:
>> Just curious based on the first issue and not sure if it's
>> the issue or not but did you by any chance rename the server
>> after the jobs were created? Do you have any problems
>> changing, modifying jobs?
>> -Sue