Alert Not Firing

Hi, I added a new message using sp_addmessage(50001,16,'My Message',1)
I then configured an alert to check this message id.
In a stored procedure that does a check for a certain condition, if
condition is true raiserror(50001,16,1).
My hope was that tha alert would fire ans the the response would be to send
me an email.
Since the alert is not firing I get no email.
What am I missing here. Do I have this configured correctly?
Any help is appreciated.
Thanks
Gary
Try changing the evert alert definition to reference database name "master",
or "(All Databases)". I had a similar problem and it seem that messages
are send via the master database so the event alert definition needs to be
triggered from master.
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:FAEAAD58-1CA0-467D-8C5B-1A988D2DB962@.microsoft.com...
> Hi, I added a new message using sp_addmessage(50001,16,'My Message',1)
> I then configured an alert to check this message id.
> In a stored procedure that does a check for a certain condition, if
> condition is true raiserror(50001,16,1).
> My hope was that tha alert would fire ans the the response would be to
send
> me an email.
> Since the alert is not firing I get no email.
> What am I missing here. Do I have this configured correctly?
> Any help is appreciated.
> Thanks
> Gary
|||I've got the same problem and have tried setting the reference to All and
master to no avail. Any ideas? My system:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Jim
"Gregory A. Larsen" wrote:

> Try changing the evert alert definition to reference database name "master",
> or "(All Databases)". I had a similar problem and it seem that messages
> are send via the master database so the event alert definition needs to be
> triggered from master.
> --
> ----
> ----
> -
> Need SQL Server Examples check out my website
> http://www.geocities.com/sqlserverexamples
>
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:FAEAAD58-1CA0-467D-8C5B-1A988D2DB962@.microsoft.com...
> send
>
>
|||Jim, I got my alert to work. In the properties dialog there is a text box
labeled "Error message contains this text" I cleared it and did not enter
anything. I then clicked apply and then clicked ok. I ran my stored procedure
and it fired the alert. I hope this helps you.
Gary
"Jim" wrote:
[vbcol=seagreen]
> I've got the same problem and have tried setting the reference to All and
> master to no avail. Any ideas? My system:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> Jim
> "Gregory A. Larsen" wrote:
|||1. The messages need to show up in the eventlog. This is what agent polls. No messages in Eventlog =
Agent is not aware of them.
2. The "Databases" textbox is misleading. This is only a filter. At least AFAIK (and I wrote a
similar functionality to Agent's event handling myself). If what you put in the "Databases" text box
isn't in the message text then the alert will not fire.
3. Same thing for "Error message contains this text".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:BD2713F2-666C-4842-B479-1F38DAA7FE90@.microsoft.com...[vbcol=seagreen]
> Jim, I got my alert to work. In the properties dialog there is a text box
> labeled "Error message contains this text" I cleared it and did not enter
> anything. I then clicked apply and then clicked ok. I ran my stored procedure
> and it fired the alert. I hope this helps you.
> Gary
> "Jim" wrote:
|||Perfect! Thanks everyone.
Jim

Alert Not Firing

Hi, I added a new message using sp_addmessage(50001,16,'My Message',1)
I then configured an alert to check this message id.
In a stored procedure that does a check for a certain condition, if
condition is true raiserror(50001,16,1).
My hope was that tha alert would fire ans the the response would be to send
me an email.
Since the alert is not firing I get no email.
What am I missing here. Do I have this configured correctly?
Any help is appreciated.
Thanks
GaryTry changing the evert alert definition to reference database name "master",
or "(All Databases)". I had a similar problem and it seem that messages
are send via the master database so the event alert definition needs to be
triggered from master.
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:FAEAAD58-1CA0-467D-8C5B-1A988D2DB962@.microsoft.com...
> Hi, I added a new message using sp_addmessage(50001,16,'My Message',1)
> I then configured an alert to check this message id.
> In a stored procedure that does a check for a certain condition, if
> condition is true raiserror(50001,16,1).
> My hope was that tha alert would fire ans the the response would be to
send
> me an email.
> Since the alert is not firing I get no email.
> What am I missing here. Do I have this configured correctly?
> Any help is appreciated.
> Thanks
> Gary|||I've got the same problem and have tried setting the reference to All and
master to no avail. Any ideas? My system:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Jim
"Gregory A. Larsen" wrote:

> Try changing the evert alert definition to reference database name "master
",
> or "(All Databases)". I had a similar problem and it seem that messages
> are send via the master database so the event alert definition needs to be
> triggered from master.
> --
> ----
--
> ----
--
> -
> Need SQL Server Examples check out my website
> http://www.geocities.com/sqlserverexamples
>
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:FAEAAD58-1CA0-467D-8C5B-1A988D2DB962@.microsoft.com...
> send
>
>|||Jim, I got my alert to work. In the properties dialog there is a text box
labeled "Error message contains this text" I cleared it and did not enter
anything. I then clicked apply and then clicked ok. I ran my stored procedur
e
and it fired the alert. I hope this helps you.
Gary
"Jim" wrote:
[vbcol=seagreen]
> I've got the same problem and have tried setting the reference to All and
> master to no avail. Any ideas? My system:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack
4)
> Jim
> "Gregory A. Larsen" wrote:
>|||1. The messages need to show up in the eventlog. This is what agent polls. N
o messages in Eventlog =
Agent is not aware of them.
2. The "Databases" textbox is misleading. This is only a filter. At least AF
AIK (and I wrote a
similar functionality to Agent's event handling myself). If what you put in
the "Databases" text box
isn't in the message text then the alert will not fire.
3. Same thing for "Error message contains this text".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:BD2713F2-666C-4842-B479-1F38DAA7FE90@.microsoft.com...[vbcol=seagreen]
> Jim, I got my alert to work. In the properties dialog there is a text box
> labeled "Error message contains this text" I cleared it and did not enter
> anything. I then clicked apply and then clicked ok. I ran my stored proced
ure
> and it fired the alert. I hope this helps you.
> Gary
> "Jim" wrote:
>|||Perfect! Thanks everyone.
Jimsql

Alert Not Being Triggered

Hi guys,

Hope you are all well.

I am trying to set up a 'SQL Server event alert' that will 'net send' a warning message to one of the Operators that have been set-up on our SQL Server.

The alert has been configured to act on severity level '009 - User Defined', for all databases.

I have created a user defined system message with a severity level '9' on the sysmessages table.

EXEC sp_addmessage 80000, 9, 'My User Defined Message'

...and I have raised this error on our SQL Server.

RAISERROR(80000, 9, 1) WITH LOG

The error message is being generated in the SQL Server Log file, but for some reason my Alert does not appear to fire off the 'net send' event.

The operator is 'available to receive notifications', and I have tested the 'net send' command successfully.

Does anyone know why this Alert might not be sending a message with the 'net send' command?

Thanks in advance,
KevinI found the 'problem'. There is a text box in the Alert properties labelled 'Error message contains this text'. I stupidly assumed that this would be the message displayed to the Operator, when in fact this actually restricts the alert to only those events that contain the text specified in the error message.

:o :D

Alert doesn't work on SQL 2005

Hi,
I have trouble getting the alerts to work on SQL 2005.
Below I define a custom message and a custom alert.
When I raise the error though the alert never fires.
Any ideas why that would be?
Thanks,
Patrick
----
USE master
GO
EXEC sp_addmessage 50001, 16, N'The version of SQL Server has been
requested.'
GO
---
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @.name=N'TEST Alert',
@.message_id=50001,
@.severity=0,
@.enabled=1,
@.delay_between_responses=5,
@.include_event_description_in=5,
@.notification_message=N'TEST',
@.category_name=N'[Uncategorized]',
@.job_id=N'00000000-0000-0000-0000-000000000000'
---
RAISERROR (50001, 16, 1)
---On sp_addmessage set @.with_log to true, the default is false.
Hope this helps,
Ben Nevarez
"Patrick" wrote:
> Hi,
> I have trouble getting the alerts to work on SQL 2005.
> Below I define a custom message and a custom alert.
> When I raise the error though the alert never fires.
> Any ideas why that would be?
> Thanks,
> Patrick
> ----
> USE master
> GO
> EXEC sp_addmessage 50001, 16, N'The version of SQL Server has been
> requested.'
> GO
> ---
> USE [msdb]
> GO
> EXEC msdb.dbo.sp_add_alert @.name=N'TEST Alert',
> @.message_id=50001,
> @.severity=0,
> @.enabled=1,
> @.delay_between_responses=5,
> @.include_event_description_in=5,
> @.notification_message=N'TEST',
> @.category_name=N'[Uncategorized]',
> @.job_id=N'00000000-0000-0000-0000-000000000000'
> ---
> RAISERROR (50001, 16, 1)
> ---
>|||On Jan 29, 4:06 pm, Ben Nevarez
<bneva...@.no.spam.please.sunamerica.com> wrote:
> On sp_addmessage set @.with_log to true, the default is false.
> Hope this helps,
> Ben Nevarez
Hi Ben,
thanks that worked. Maybe you would also know why none of my
replication alerts is working.
They are all set up but when I look on the history section of each
alert none of them has ever been called (even though we are using
replication :))
Thanks,
Patricksql

Aggregates in Matrix Reports

I am having a similar issue in a Matrix report. The following is a message from someone else having the same problem.

I have a calculation (Aggregate) that has a scope that is for both the Row and the Column.

Example:

What is the percent of total sales and percent of total category sales?
How do I do these Percentages in a Matrix?

Q1 Q2 Total
Beverages

Lemonade
Sales $100 150 250
% of Bev 44%
Percent of Total 19%

Soda
Sales $125 125 250
% of Bev 46%
Percent of Total 22%
Total Beverages $225 275 500

Snacks
Peanuts
Sales $100 150 250
% of Snacks
% of Total

Cookies
Sales $ 200 250 450
% of Snacks
% of Total
Total Snacks 300 400 700
Total Sales 525 675 1300

Any Ideas?

Assuming you have a matrix called "Matrix" with a row grouping called "CategoryGroup", you can calculate percentages in matrix cells using aggregate functions with explicit scope names.
E.g. for the percentage of sales within the current category group:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "CategoryGroup")

Percentage of sales within total sales:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "Matrix")
Or:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "DataSetName")

-- Robert|||What if I am not using a matrix. I just have a report that is now counting the items in subfields and I also want to include a percentage of the total that the subfield is.
animals
cats
lions 30
tigers 20
pumas 50
bears
grizzly 10
etc.
total 200
I want to include a percentage column
animals
cats
lions 16 8%
tigers 10 5%
pumas 30 15%
etc.
|||

Not sure I understand. It sounds like you are using a table with table groups. Is the "total" calculated for the entire table, or for individual groups?

In both cases, you can just use a similar approach for calculating the percentages:

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1_AnimalTypeGroup")

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1")

-- Robert

|||

I have a similar question. I too am using a matrix for my report. It is an employee headcount report. I have row groups for dept and employee ID and I have column groups for the month and the headcount. I also have parameters on Dept and month. The data shows as follows:

Dept Emp ID# Emp Name Jan Feb March

HR 123 H. Potter 1 1 1

IT 231 R. Weasley 1 1 1

Sales 879 C. Digory 1 1 0

I want to format the report so that if there is a change in the headcount number for an employee, the row is highlighted in a different color. So in the example provided above, the last column would be highlighted in red.

I think the logic would be to add up the total of the row sum(fields!headcount.value) and divide it by the number of months (parameter!month.count) and then compare the value in the first column (January) to the result.

However I am not sure of the exact syntax for this formula nor am I sure where to place this formula within the layout of the report. Should I add another column grouping? Or would this formula go somewhere in the group properties for the employee?

Any help would be greatly appreciated

Linda

|||Robert, you are great. This example helped me to get the results I wanted.

Aggregates in Matrix Reports

I am having a similar issue in a Matrix report. The following is a message from someone else having the same problem.

I have a calculation (Aggregate) that has a scope that is for both the Row and the Column.

Example:

What is the percent of total sales and percent of total category sales?
How do I do these Percentages in a Matrix?

Q1 Q2 Total
Beverages

Lemonade
Sales $100 150 250
% of Bev 44%
Percent of Total 19%

Soda
Sales $125 125 250
% of Bev 46%
Percent of Total 22%
Total Beverages $225 275 500

Snacks
Peanuts
Sales $100 150 250
% of Snacks
% of Total

Cookies
Sales $ 200 250 450
% of Snacks
% of Total
Total Snacks 300 400 700
Total Sales 525 675 1300

Any Ideas?

Assuming you have a matrix called "Matrix" with a row grouping called "CategoryGroup", you can calculate percentages in matrix cells using aggregate functions with explicit scope names.
E.g. for the percentage of sales within the current category group:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "CategoryGroup")

Percentage of sales within total sales:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "Matrix")
Or:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "DataSetName")

-- Robert|||What if I am not using a matrix. I just have a report that is now counting the items in subfields and I also want to include a percentage of the total that the subfield is.
animals
cats
lions 30
tigers 20
pumas 50
bears
grizzly 10
etc.
total 200
I want to include a percentage column
animals
cats
lions 16 8%
tigers 10 5%
pumas 30 15%
etc.
|||

Not sure I understand. It sounds like you are using a table with table groups. Is the "total" calculated for the entire table, or for individual groups?

In both cases, you can just use a similar approach for calculating the percentages:

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1_AnimalTypeGroup")

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1")

-- Robert

|||

I have a similar question. I too am using a matrix for my report. It is an employee headcount report. I have row groups for dept and employee ID and I have column groups for the month and the headcount. I also have parameters on Dept and month. The data shows as follows:

Dept Emp ID# Emp Name Jan Feb March

HR 123 H. Potter 1 1 1

IT 231 R. Weasley 1 1 1

Sales 879 C. Digory 1 1 0

I want to format the report so that if there is a change in the headcount number for an employee, the row is highlighted in a different color. So in the example provided above, the last column would be highlighted in red.

I think the logic would be to add up the total of the row sum(fields!headcount.value) and divide it by the number of months (parameter!month.count) and then compare the value in the first column (January) to the result.

However I am not sure of the exact syntax for this formula nor am I sure where to place this formula within the layout of the report. Should I add another column grouping? Or would this formula go somewhere in the group properties for the employee?

Any help would be greatly appreciated

Linda

|||Robert, you are great. This example helped me to get the results I wanted.

Aggregates in Matrix Reports

I am having a similar issue in a Matrix report. The following is a message from someone else having the same problem.

I have a calculation (Aggregate) that has a scope that is for both the Row and the Column.

Example:

What is the percent of total sales and percent of total category sales?
How do I do these Percentages in a Matrix?

Q1 Q2 Total
Beverages

Lemonade
Sales $100 150 250
% of Bev 44%
Percent of Total 19%

Soda
Sales $125 125 250
% of Bev 46%
Percent of Total 22%
Total Beverages $225 275 500

Snacks
Peanuts
Sales $100 150 250
% of Snacks
% of Total

Cookies
Sales $ 200 250 450
% of Snacks
% of Total
Total Snacks 300 400 700
Total Sales 525 675 1300

Any Ideas?

Assuming you have a matrix called "Matrix" with a row grouping called "CategoryGroup", you can calculate percentages in matrix cells using aggregate functions with explicit scope names.
E.g. for the percentage of sales within the current category group:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "CategoryGroup")

Percentage of sales within total sales:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "Matrix")
Or:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "DataSetName")

-- Robert|||What if I am not using a matrix. I just have a report that is now counting the items in subfields and I also want to include a percentage of the total that the subfield is.
animals
cats
lions 30
tigers 20
pumas 50
bears
grizzly 10
etc.
total 200
I want to include a percentage column
animals
cats
lions 16 8%
tigers 10 5%
pumas 30 15%
etc.
|||

Not sure I understand. It sounds like you are using a table with table groups. Is the "total" calculated for the entire table, or for individual groups?

In both cases, you can just use a similar approach for calculating the percentages:

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1_AnimalTypeGroup")

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1")

-- Robert

|||

I have a similar question. I too am using a matrix for my report. It is an employee headcount report. I have row groups for dept and employee ID and I have column groups for the month and the headcount. I also have parameters on Dept and month. The data shows as follows:

Dept Emp ID# Emp Name Jan Feb March

HR 123 H. Potter 1 1 1

IT 231 R. Weasley 1 1 1

Sales 879 C. Digory 1 1 0

I want to format the report so that if there is a change in the headcount number for an employee, the row is highlighted in a different color. So in the example provided above, the last column would be highlighted in red.

I think the logic would be to add up the total of the row sum(fields!headcount.value) and divide it by the number of months (parameter!month.count) and then compare the value in the first column (January) to the result.

However I am not sure of the exact syntax for this formula nor am I sure where to place this formula within the layout of the report. Should I add another column grouping? Or would this formula go somewhere in the group properties for the employee?

Any help would be greatly appreciated

Linda

|||Robert, you are great. This example helped me to get the results I wanted.

Aggregates in Matrix Reports

I am having a similar issue in a Matrix report. The following is a message from someone else having the same problem.

I have a calculation (Aggregate) that has a scope that is for both the Row and the Column.

Example:

What is the percent of total sales and percent of total category sales?
How do I do these Percentages in a Matrix?

Q1 Q2 Total
Beverages

Lemonade
Sales $100 150 250
% of Bev 44%
Percent of Total 19%

Soda
Sales $125 125 250
% of Bev 46%
Percent of Total 22%
Total Beverages $225 275 500

Snacks
Peanuts
Sales $100 150 250
% of Snacks
% of Total

Cookies
Sales $ 200 250 450
% of Snacks
% of Total
Total Snacks 300 400 700
Total Sales 525 675 1300

Any Ideas?

Assuming you have a matrix called "Matrix" with a row grouping called "CategoryGroup", you can calculate percentages in matrix cells using aggregate functions with explicit scope names.
E.g. for the percentage of sales within the current category group:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "CategoryGroup")

Percentage of sales within total sales:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "Matrix")
Or:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "DataSetName")

-- Robert|||What if I am not using a matrix. I just have a report that is now counting the items in subfields and I also want to include a percentage of the total that the subfield is.
animals
cats
lions 30
tigers 20
pumas 50
bears
grizzly 10
etc.
total 200
I want to include a percentage column
animals
cats
lions 16 8%
tigers 10 5%
pumas 30 15%
etc.
|||

Not sure I understand. It sounds like you are using a table with table groups. Is the "total" calculated for the entire table, or for individual groups?

In both cases, you can just use a similar approach for calculating the percentages:

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1_AnimalTypeGroup")

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1")

-- Robert

|||

I have a similar question. I too am using a matrix for my report. It is an employee headcount report. I have row groups for dept and employee ID and I have column groups for the month and the headcount. I also have parameters on Dept and month. The data shows as follows:

Dept Emp ID# Emp Name Jan Feb March

HR 123 H. Potter 1 1 1

IT 231 R. Weasley 1 1 1

Sales 879 C. Digory 1 1 0

I want to format the report so that if there is a change in the headcount number for an employee, the row is highlighted in a different color. So in the example provided above, the last column would be highlighted in red.

I think the logic would be to add up the total of the row sum(fields!headcount.value) and divide it by the number of months (parameter!month.count) and then compare the value in the first column (January) to the result.

However I am not sure of the exact syntax for this formula nor am I sure where to place this formula within the layout of the report. Should I add another column grouping? Or would this formula go somewhere in the group properties for the employee?

Any help would be greatly appreciated

Linda

|||Robert, you are great. This example helped me to get the results I wanted.

Aggregates in Matrix Reports

I am having a similar issue in a Matrix report. The following is a message from someone else having the same problem.

I have a calculation (Aggregate) that has a scope that is for both the Row and the Column.

Example:

What is the percent of total sales and percent of total category sales?
How do I do these Percentages in a Matrix?

Q1 Q2 Total
Beverages

Lemonade
Sales $100 150 250
% of Bev 44%
Percent of Total 19%

Soda
Sales $125 125 250
% of Bev 46%
Percent of Total 22%
Total Beverages $225 275 500

Snacks
Peanuts
Sales $100 150 250
% of Snacks
% of Total

Cookies
Sales $ 200 250 450
% of Snacks
% of Total
Total Snacks 300 400 700
Total Sales 525 675 1300

Any Ideas?

Assuming you have a matrix called "Matrix" with a row grouping called "CategoryGroup", you can calculate percentages in matrix cells using aggregate functions with explicit scope names.
E.g. for the percentage of sales within the current category group:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "CategoryGroup")

Percentage of sales within total sales:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "Matrix")
Or:
=Sum(Fields!SalesAmount.Value) / Sum(Fields!SalesAmount.Value, "DataSetName")

-- Robert|||What if I am not using a matrix. I just have a report that is now counting the items in subfields and I also want to include a percentage of the total that the subfield is.
animals
cats
lions 30
tigers 20
pumas 50
bears
grizzly 10
etc.
total 200
I want to include a percentage column
animals
cats
lions 16 8%
tigers 10 5%
pumas 30 15%
etc.
|||

Not sure I understand. It sounds like you are using a table with table groups. Is the "total" calculated for the entire table, or for individual groups?

In both cases, you can just use a similar approach for calculating the percentages:

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1_AnimalTypeGroup")

=Sum(Fields!amount.Value) / Sum(Fields!amount.Value, "table1")

-- Robert

|||

I have a similar question. I too am using a matrix for my report. It is an employee headcount report. I have row groups for dept and employee ID and I have column groups for the month and the headcount. I also have parameters on Dept and month. The data shows as follows:

Dept Emp ID# Emp Name Jan Feb March

HR 123 H. Potter 1 1 1

IT 231 R. Weasley 1 1 1

Sales 879 C. Digory 1 1 0

I want to format the report so that if there is a change in the headcount number for an employee, the row is highlighted in a different color. So in the example provided above, the last column would be highlighted in red.

I think the logic would be to add up the total of the row sum(fields!headcount.value) and divide it by the number of months (parameter!month.count) and then compare the value in the first column (January) to the result.

However I am not sure of the exact syntax for this formula nor am I sure where to place this formula within the layout of the report. Should I add another column grouping? Or would this formula go somewhere in the group properties for the employee?

Any help would be greatly appreciated

Linda

|||Robert, you are great. This example helped me to get the results I wanted.

after system restore the agent does not start

This is a multi-part message in MIME format.
--=_NextPart_000_00E5_01C442B1.3C673D60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi group,
we have a server that had a server restore (near mirror, the system = admin had to work out a few kinks). After the restore, the sql server = agent does not start. When trying start it in service, it appears to be = trying to start, but at the end the MMC gives a message
Could not start the SQLSERVERAGENT service on local computer. The = service did not return an error. This could be an internal error or an = internal service error.
Window event log shows the following error:
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot = be found. The local computer may not have the necessary registry = information or message DLL files to display messages from a remote = computer. The following information is part of the event: 17050, = initerrlog: Could not open error log file 'e:\MSSQL\log\ERRORLOG'. = Operating system error =3D 32(The process cannot access the file because = it is being used by another process.).
Can someone offer the fix? Thanks.
The following is the configuration:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Quentin
--=_NextPart_000_00E5_01C442B1.3C673D60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi group,

we have a server that had a server = restore (near mirror, the system admin had to work out a few kinks). After the = restore, the sql server agent does not start. When trying start it in = service, it appears to be trying to start, but at the end the MMC gives a message

Could not start the SQLSERVERAGENT = service on local computer. The service did not return an error. This could be = an internal error or an internal service error.

Window event log shows the following error:

The description for Event ID ( 17055 ) = in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the = necessary registry information or message DLL files to display messages from a = remote computer. The following information is part of the event: 17050, = initerrlog: Could not open error log file 'e:\MSSQL\log\ERRORLOG'. Operating system = error =3D 32(The process cannot access the file because it is being used by = another process.).

Can someone offer the fix? Thanks.

The following is the = configuration:

Microsoft SQL Server 2000 - = 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 = Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: = Service Pack 3)

Quentin

--=_NextPart_000_00E5_01C442B1.3C673D60--This is a multi-part message in MIME format.
--=_NextPart_000_013D_01C442EE.20BD19D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
The log mentioned, is the normal name for the SQL Server error log... =It looks like SQL is trying to open it a second time, (as if you have 2 =instances of SQL Server trying to write to the same log file)... THis =can be changed in SEM startup properties...
However it might be possible that your SQL Agent is trying to open the =log ( in SEM right click SQL Agent and go to properties to discover the =log name it is using..)
All in all it looks to me that the error you are showing is not related =to the SQL Agent not starting...Ensure the agent is using an NT login =that is a SQL Server administrator.
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's =community of SQL Server professionals.
www.sqlpass.org
"Quentin Ran" <ab@.who.com> wrote in message =news:OwDGnstQEHA.1960@.TK2MSFTNGP10.phx.gbl...
Hi group,
we have a server that had a server restore (near mirror, the system =admin had to work out a few kinks). After the restore, the sql server =agent does not start. When trying start it in service, it appears to be =trying to start, but at the end the MMC gives a message
Could not start the SQLSERVERAGENT service on local computer. The =service did not return an error. This could be an internal error or an =internal service error.
Window event log shows the following error:
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) =cannot be found. The local computer may not have the necessary registry =information or message DLL files to display messages from a remote =computer. The following information is part of the event: 17050, =initerrlog: Could not open error log file 'e:\MSSQL\log\ERRORLOG'. =Operating system error =3D 32(The process cannot access the file because =it is being used by another process.).
Can someone offer the fix? Thanks.
The following is the configuration:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Quentin
--=_NextPart_000_013D_01C442EE.20BD19D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

The log mentioned, is the normal name =for the SQL Server error log... It looks like SQL is trying to open it a second =time, (as if you have 2 instances of SQL Server trying to write to the same log =file)... THis can be changed in SEM startup properties...
However it might be possible that your =SQL Agent is trying to open the log ( in SEM right click SQL Agent and go to =properties to discover the log name it is using..)
All in all it looks to me that the =error you are showing is not related to the SQL Agent not starting...Ensure the agent =is using an NT login that is a SQL Server administrator.
-- Wayne Snyder, MCDBA, SQL Server MVPMariner, =Charlotte, NChttp://www.mariner-usa.com">www.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and =it's community of SQL Server professionals.http://www.sqlpass.org">www.sqlpass.org
"Quentin Ran" wrote in message news:OwDGnstQEHA.1960=@.TK2MSFTNGP10.phx.gbl...
Hi group,

we have a server that had a server =restore (near mirror, the system admin had to work out a few kinks). After the = restore, the sql server agent does not start. When trying start =it in service, it appears to be trying to start, but at the end the MMC =gives a message

Could not start the SQLSERVERAGENT =service on local computer. The service did not return an error. This =could be an internal error or an internal service error.

Window event log shows the following error:

The description for Event ID ( 17055 =) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the =necessary registry information or message DLL files to display messages from a =remote computer. The following information is part of the event: 17050, =initerrlog: Could not open error log file 'e:\MSSQL\log\ERRORLOG'. Operating =system error =3D 32(The process cannot access the file because it is being used by =another process.).

Can someone offer the fix? Thanks.

The following is the =configuration:

Microsoft SQL Server 2000 - =8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 =(Build 2195: Service Pack 3)

Quentin

---

--=_NextPart_000_013D_01C442EE.20BD19D0--|||>>The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer.
sounds like the sqlagent thinks it's running on a different computer.
does this restored server have a different name than the original
server?
>>Could not open error log file 'e:\MSSQL\log\ERRORLOG'. Operating
system error = 32(The process cannot access the file because it is being
used by another process.).
this, as the other poster pointed out, sounds like something is using
that log file. that log file is for sqlserver. you should specify a
different log file for the agent, generally should be something like
e:\mssql\log\sqlagent.out
Quentin Ran wrote:
> Hi group, we have a server that had a server restore (near mirror, the
> system admin had to work out a few kinks). After the restore, the sql
> server agent does not start. When trying start it in service, it
> appears to be trying to start, but at the end the MMC gives a
> message Could not start the SQLSERVERAGENT service on local computer.
> The service did not return an error. This could be an internal error
> or an internal service error. Window event log shows the following
> error: The description for Event ID ( 17055 ) in Source ( MSSQLSERVER
> ) cannot be found. The local computer may not have the necessary
> registry information or message DLL files to display messages from a
> remote computer. The following information is part of the event:
> 17050, initerrlog: Could not open error log file
> 'e:\MSSQL\log\ERRORLOG'. Operating system error = 32(The process
> cannot access the file because it is being used by another
> process.). Can someone offer the fix? Thanks. The following is the
> configuration: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> May 31 2003 16:08:15
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack
> 3) Quentin|||Thanks for both responses.
The restored server has exactly the same name as before. SQL Server Agent
is running off a server admin account.
SQL Server Service uses the error log file e:\MSSQL\log\ERRORLOG, and SQL
Server Agent Service uses the error log file E:\MSSQL\LOG\SQLAGENT.OUT. The
server service log seems to work at least half way -- when the server
service starts, it records what it was doing like opening the databases. In
fact it even recorded a restore of a database. The fact that it did not
record any failure of launching the server agent may be due to it never was
asked to do so -- Windows may not know to direct such event there. The
agent log actually also contains some entries after the starting of the
server service, but not those ones that agent service start failed.
Any additional comments?
Quentin
"ch" <ch@.dontemailme.com> wrote in message
news:40B4980C.B82ABDFE@.dontemailme.com...
> >>The local computer may not have the necessary registry information or
> message DLL files to display messages from a remote computer.
> sounds like the sqlagent thinks it's running on a different computer.
> does this restored server have a different name than the original
> server?
>
> >>Could not open error log file 'e:\MSSQL\log\ERRORLOG'. Operating
> system error = 32(The process cannot access the file because it is being
> used by another process.).
> this, as the other poster pointed out, sounds like something is using
> that log file. that log file is for sqlserver. you should specify a
> different log file for the agent, generally should be something like
> e:\mssql\log\sqlagent.out
>
>
> Quentin Ran wrote:
> > Hi group, we have a server that had a server restore (near mirror, the
> > system admin had to work out a few kinks). After the restore, the sql
> > server agent does not start. When trying start it in service, it
> > appears to be trying to start, but at the end the MMC gives a
> > message Could not start the SQLSERVERAGENT service on local computer.
> > The service did not return an error. This could be an internal error
> > or an internal service error. Window event log shows the following
> > error: The description for Event ID ( 17055 ) in Source ( MSSQLSERVER
> > ) cannot be found. The local computer may not have the necessary
> > registry information or message DLL files to display messages from a
> > remote computer. The following information is part of the event:
> > 17050, initerrlog: Could not open error log file
> > 'e:\MSSQL\log\ERRORLOG'. Operating system error = 32(The process
> > cannot access the file because it is being used by another
> > process.). Can someone offer the fix? Thanks. The following is the
> > configuration: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> > May 31 2003 16:08:15
> > Copyright (c) 1988-2003 Microsoft Corporation
> > Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack
> > 3) Quentin
>|||maybe there are some registry settings incorrect due to the restore of the
server.
try this.
create an nt account that is local admin on the server.
using enterprise manager, change the sqlserver and sqlagent services to use that
account.
restart server. see if agent starts properly.
now go back using enterprise manager and reset your sqlserver and sqlagent
accounts to whatever account(s) they were using before.
restart server. see if agent starts properly.
if that doesn't work, see if you can get them to run properly using the system
account for the two services.
be sure to use enterprise manager to make changes to the accounts the services
use.
Quentin Ran wrote:
> Thanks for both responses.
> The restored server has exactly the same name as before. SQL Server Agent
> is running off a server admin account.
> SQL Server Service uses the error log file e:\MSSQL\log\ERRORLOG, and SQL
> Server Agent Service uses the error log file E:\MSSQL\LOG\SQLAGENT.OUT. The
> server service log seems to work at least half way -- when the server
> service starts, it records what it was doing like opening the databases. In
> fact it even recorded a restore of a database. The fact that it did not
> record any failure of launching the server agent may be due to it never was
> asked to do so -- Windows may not know to direct such event there. The
> agent log actually also contains some entries after the starting of the
> server service, but not those ones that agent service start failed.
> Any additional comments?
> Quentin
> "ch" <ch@.dontemailme.com> wrote in message
> news:40B4980C.B82ABDFE@.dontemailme.com...
> > >>The local computer may not have the necessary registry information or
> > message DLL files to display messages from a remote computer.
> >
> > sounds like the sqlagent thinks it's running on a different computer.
> > does this restored server have a different name than the original
> > server?
> >
> >
> > >>Could not open error log file 'e:\MSSQL\log\ERRORLOG'. Operating
> > system error = 32(The process cannot access the file because it is being
> > used by another process.).
> >
> > this, as the other poster pointed out, sounds like something is using
> > that log file. that log file is for sqlserver. you should specify a
> > different log file for the agent, generally should be something like
> > e:\mssql\log\sqlagent.out
> >
> >
> >
> >
> > Quentin Ran wrote:
> >
> > > Hi group, we have a server that had a server restore (near mirror, the
> > > system admin had to work out a few kinks). After the restore, the sql
> > > server agent does not start. When trying start it in service, it
> > > appears to be trying to start, but at the end the MMC gives a
> > > message Could not start the SQLSERVERAGENT service on local computer.
> > > The service did not return an error. This could be an internal error
> > > or an internal service error. Window event log shows the following
> > > error: The description for Event ID ( 17055 ) in Source ( MSSQLSERVER
> > > ) cannot be found. The local computer may not have the necessary
> > > registry information or message DLL files to display messages from a
> > > remote computer. The following information is part of the event:
> > > 17050, initerrlog: Could not open error log file
> > > 'e:\MSSQL\log\ERRORLOG'. Operating system error = 32(The process
> > > cannot access the file because it is being used by another
> > > process.). Can someone offer the fix? Thanks. The following is the
> > > configuration: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> > > May 31 2003 16:08:15
> > > Copyright (c) 1988-2003 Microsoft Corporation
> > > Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack
> > > 3) Quentin
> >|||Neither a local admin account nor the system account would start them.
There must be wrong registry settings, and we don't know which ones and the
correct values.
"ch" <ch@.dontemailme.com> wrote in message
news:40B4BCFB.1AF8E97B@.dontemailme.com...
> maybe there are some registry settings incorrect due to the restore of the
> server.
> try this.
> create an nt account that is local admin on the server.
> using enterprise manager, change the sqlserver and sqlagent services to
use that
> account.
> restart server. see if agent starts properly.
> now go back using enterprise manager and reset your sqlserver and sqlagent
> accounts to whatever account(s) they were using before.
> restart server. see if agent starts properly.
> if that doesn't work, see if you can get them to run properly using the
system
> account for the two services.
> be sure to use enterprise manager to make changes to the accounts the
services
> use.
>
> Quentin Ran wrote:
> > Thanks for both responses.
> >
> > The restored server has exactly the same name as before. SQL Server
Agent
> > is running off a server admin account.
> >
> > SQL Server Service uses the error log file e:\MSSQL\log\ERRORLOG, and
SQL
> > Server Agent Service uses the error log file E:\MSSQL\LOG\SQLAGENT.OUT.
The
> > server service log seems to work at least half way -- when the server
> > service starts, it records what it was doing like opening the databases.
In
> > fact it even recorded a restore of a database. The fact that it did not
> > record any failure of launching the server agent may be due to it never
was
> > asked to do so -- Windows may not know to direct such event there. The
> > agent log actually also contains some entries after the starting of the
> > server service, but not those ones that agent service start failed.
> >
> > Any additional comments?
> >
> > Quentin
> >
> > "ch" <ch@.dontemailme.com> wrote in message
> > news:40B4980C.B82ABDFE@.dontemailme.com...
> > > >>The local computer may not have the necessary registry information
or
> > > message DLL files to display messages from a remote computer.
> > >
> > > sounds like the sqlagent thinks it's running on a different computer.
> > > does this restored server have a different name than the original
> > > server?
> > >
> > >
> > > >>Could not open error log file 'e:\MSSQL\log\ERRORLOG'. Operating
> > > system error = 32(The process cannot access the file because it is
being
> > > used by another process.).
> > >
> > > this, as the other poster pointed out, sounds like something is using
> > > that log file. that log file is for sqlserver. you should specify a
> > > different log file for the agent, generally should be something like
> > > e:\mssql\log\sqlagent.out
> > >
> > >
> > >
> > >
> > > Quentin Ran wrote:
> > >
> > > > Hi group, we have a server that had a server restore (near mirror,
the
> > > > system admin had to work out a few kinks). After the restore, the
sql
> > > > server agent does not start. When trying start it in service, it
> > > > appears to be trying to start, but at the end the MMC gives a
> > > > message Could not start the SQLSERVERAGENT service on local
computer.
> > > > The service did not return an error. This could be an internal
error
> > > > or an internal service error. Window event log shows the following
> > > > error: The description for Event ID ( 17055 ) in Source (
MSSQLSERVER
> > > > ) cannot be found. The local computer may not have the necessary
> > > > registry information or message DLL files to display messages from a
> > > > remote computer. The following information is part of the event:
> > > > 17050, initerrlog: Could not open error log file
> > > > 'e:\MSSQL\log\ERRORLOG'. Operating system error = 32(The process
> > > > cannot access the file because it is being used by another
> > > > process.). Can someone offer the fix? Thanks. The following is the
> > > > configuration: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> > > > May 31 2003 16:08:15
> > > > Copyright (c) 1988-2003 Microsoft Corporation
> > > > Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack
> > > > 3) Quentin
> > >
>|||check this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;283811
Quentin Ran wrote:
> Neither a local admin account nor the system account would start them.
> There must be wrong registry settings, and we don't know which ones and the
> correct values.
> "ch" <ch@.dontemailme.com> wrote in message
> news:40B4BCFB.1AF8E97B@.dontemailme.com...
> > maybe there are some registry settings incorrect due to the restore of the
> > server.
> > try this.
> > create an nt account that is local admin on the server.
> > using enterprise manager, change the sqlserver and sqlagent services to
> use that
> > account.
> > restart server. see if agent starts properly.
> > now go back using enterprise manager and reset your sqlserver and sqlagent
> > accounts to whatever account(s) they were using before.
> > restart server. see if agent starts properly.
> > if that doesn't work, see if you can get them to run properly using the
> system
> > account for the two services.
> > be sure to use enterprise manager to make changes to the accounts the
> services
> > use.
> >
> >
> >
> > Quentin Ran wrote:
> >
> > > Thanks for both responses.
> > >
> > > The restored server has exactly the same name as before. SQL Server
> Agent
> > > is running off a server admin account.
> > >
> > > SQL Server Service uses the error log file e:\MSSQL\log\ERRORLOG, and
> SQL
> > > Server Agent Service uses the error log file E:\MSSQL\LOG\SQLAGENT.OUT.
> The
> > > server service log seems to work at least half way -- when the server
> > > service starts, it records what it was doing like opening the databases.
> In
> > > fact it even recorded a restore of a database. The fact that it did not
> > > record any failure of launching the server agent may be due to it never
> was
> > > asked to do so -- Windows may not know to direct such event there. The
> > > agent log actually also contains some entries after the starting of the
> > > server service, but not those ones that agent service start failed.
> > >
> > > Any additional comments?
> > >
> > > Quentin
> > >
> > > "ch" <ch@.dontemailme.com> wrote in message
> > > news:40B4980C.B82ABDFE@.dontemailme.com...
> > > > >>The local computer may not have the necessary registry information
> or
> > > > message DLL files to display messages from a remote computer.
> > > >
> > > > sounds like the sqlagent thinks it's running on a different computer.
> > > > does this restored server have a different name than the original
> > > > server?
> > > >
> > > >
> > > > >>Could not open error log file 'e:\MSSQL\log\ERRORLOG'. Operating
> > > > system error = 32(The process cannot access the file because it is
> being
> > > > used by another process.).
> > > >
> > > > this, as the other poster pointed out, sounds like something is using
> > > > that log file. that log file is for sqlserver. you should specify a
> > > > different log file for the agent, generally should be something like
> > > > e:\mssql\log\sqlagent.out
> > > >
> > > >
> > > >
> > > >
> > > > Quentin Ran wrote:
> > > >
> > > > > Hi group, we have a server that had a server restore (near mirror,
> the
> > > > > system admin had to work out a few kinks). After the restore, the
> sql
> > > > > server agent does not start. When trying start it in service, it
> > > > > appears to be trying to start, but at the end the MMC gives a
> > > > > message Could not start the SQLSERVERAGENT service on local
> computer.
> > > > > The service did not return an error. This could be an internal
> error
> > > > > or an internal service error. Window event log shows the following
> > > > > error: The description for Event ID ( 17055 ) in Source (
> MSSQLSERVER
> > > > > ) cannot be found. The local computer may not have the necessary
> > > > > registry information or message DLL files to display messages from a
> > > > > remote computer. The following information is part of the event:
> > > > > 17050, initerrlog: Could not open error log file
> > > > > 'e:\MSSQL\log\ERRORLOG'. Operating system error = 32(The process
> > > > > cannot access the file because it is being used by another
> > > > > process.). Can someone offer the fix? Thanks. The following is the
> > > > > configuration: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> > > > > May 31 2003 16:08:15
> > > > > Copyright (c) 1988-2003 Microsoft Corporation
> > > > > Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack
> > > > > 3) Quentin
> > > >
> >|||Thanks.
"ch" <ch@.dontemailme.com> wrote in message
news:40B4D8F9.5C7C10D7@.dontemailme.com...
> check this article
> http://support.microsoft.com/default.aspx?scid=kb;en-us;283811
>
> Quentin Ran wrote:
> > Neither a local admin account nor the system account would start them.
> > There must be wrong registry settings, and we don't know which ones and
the
> > correct values.
> >
> > "ch" <ch@.dontemailme.com> wrote in message
> > news:40B4BCFB.1AF8E97B@.dontemailme.com...
> > > maybe there are some registry settings incorrect due to the restore of
the
> > > server.
> > > try this.
> > > create an nt account that is local admin on the server.
> > > using enterprise manager, change the sqlserver and sqlagent services
to
> > use that
> > > account.
> > > restart server. see if agent starts properly.
> > > now go back using enterprise manager and reset your sqlserver and
sqlagent
> > > accounts to whatever account(s) they were using before.
> > > restart server. see if agent starts properly.
> > > if that doesn't work, see if you can get them to run properly using
the
> > system
> > > account for the two services.
> > > be sure to use enterprise manager to make changes to the accounts the
> > services
> > > use.
> > >
> > >
> > >
> > > Quentin Ran wrote:
> > >
> > > > Thanks for both responses.
> > > >
> > > > The restored server has exactly the same name as before. SQL Server
> > Agent
> > > > is running off a server admin account.
> > > >
> > > > SQL Server Service uses the error log file e:\MSSQL\log\ERRORLOG,
and
> > SQL
> > > > Server Agent Service uses the error log file
E:\MSSQL\LOG\SQLAGENT.OUT.
> > The
> > > > server service log seems to work at least half way -- when the
server
> > > > service starts, it records what it was doing like opening the
databases.
> > In
> > > > fact it even recorded a restore of a database. The fact that it did
not
> > > > record any failure of launching the server agent may be due to it
never
> > was
> > > > asked to do so -- Windows may not know to direct such event there.
The
> > > > agent log actually also contains some entries after the starting of
the
> > > > server service, but not those ones that agent service start failed.
> > > >
> > > > Any additional comments?
> > > >
> > > > Quentin
> > > >
> > > > "ch" <ch@.dontemailme.com> wrote in message
> > > > news:40B4980C.B82ABDFE@.dontemailme.com...
> > > > > >>The local computer may not have the necessary registry
information
> > or
> > > > > message DLL files to display messages from a remote computer.
> > > > >
> > > > > sounds like the sqlagent thinks it's running on a different
computer.
> > > > > does this restored server have a different name than the original
> > > > > server?
> > > > >
> > > > >
> > > > > >>Could not open error log file 'e:\MSSQL\log\ERRORLOG'. Operating
> > > > > system error = 32(The process cannot access the file because it is
> > being
> > > > > used by another process.).
> > > > >
> > > > > this, as the other poster pointed out, sounds like something is
using
> > > > > that log file. that log file is for sqlserver. you should
specify a
> > > > > different log file for the agent, generally should be something
like
> > > > > e:\mssql\log\sqlagent.out
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Quentin Ran wrote:
> > > > >
> > > > > > Hi group, we have a server that had a server restore (near
mirror,
> > the
> > > > > > system admin had to work out a few kinks). After the restore,
the
> > sql
> > > > > > server agent does not start. When trying start it in service,
it
> > > > > > appears to be trying to start, but at the end the MMC gives a
> > > > > > message Could not start the SQLSERVERAGENT service on local
> > computer.
> > > > > > The service did not return an error. This could be an internal
> > error
> > > > > > or an internal service error. Window event log shows the
following
> > > > > > error: The description for Event ID ( 17055 ) in Source (
> > MSSQLSERVER
> > > > > > ) cannot be found. The local computer may not have the necessary
> > > > > > registry information or message DLL files to display messages
from a
> > > > > > remote computer. The following information is part of the event:
> > > > > > 17050, initerrlog: Could not open error log file
> > > > > > 'e:\MSSQL\log\ERRORLOG'. Operating system error = 32(The process
> > > > > > cannot access the file because it is being used by another
> > > > > > process.). Can someone offer the fix? Thanks. The following is
the
> > > > > > configuration: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> > > > > > May 31 2003 16:08:15
> > > > > > Copyright (c) 1988-2003 Microsoft Corporation
> > > > > > Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack
> > > > > > 3) Quentin
> > > > >
> > >
>

After SP4 I got 'no such interface supported' in snapshot agent

Hi All,
After SP4 I cannot run merge replication.
Snapshot agent try 10 times to start and on the end
give me a message 'No such interface supported. blalblabla'.
Do You have suggestion ?
Regards,
Tomasz Skorupa
Hi Tomasz,
Assuming you were talking about SQL2000 SP4, such errors can typically be
resolved by doing the following:
regsvr32 "%PrograFiles%\Microsoft SQL Server\80\COM\replagnt.dll"
"%PrograFiles%\Microsoft SQL Server\80\COM\snapshot.exe" /RegServer
"%PrograFiles%\Microsoft SQL Server\80\COM\logread.exe" /RegServer
"%PrograFiles%\Microsoft SQL Server\80\COM\distrib.exe" /RegServer
"%PrograFiles%\Microsoft SQL Server\80\COM\qrdrsvc.exe" /RegServer
"%PrograFiles%\Microsoft SQL Server\80\COM\replmerg.exe" /RegServer
If the above didn't resolve the issue, you may want to check the version of
sqlrepss.dll in the Binn directory of your sql server instance. (Post the
version number here if you don't know whether it looks right or not.)
Now even if you manage to resolve the issue, the bigger mystery here is why
you managed to get your machine in the current state in the first place. It
would be great if you can let us know of any recent unusual activity on the
machine that might have led to the problem. For example, were there any error
messages when you ran the SP4? Have you ever install SQL2005 on the machine
(note: SQL2005 express comes with VS2005 beta also)?
-Raymond
"Tomasz Skorupa" wrote:

> Hi All,
> After SP4 I cannot run merge replication.
> Snapshot agent try 10 times to start and on the end
> give me a message 'No such interface supported. blalblabla'.
> Do You have suggestion ?
> Regards,
> Tomasz Skorupa
>
>
|||Hi Raymond,
First of all, thank You for Your support.
"Raymond Mak [MSFT]" <RaymondMakMSFT@.discussions.microsoft.com> wrote in
message news:E827B5F7-D25A-40B0-AF97-B4D461395139@.microsoft.com...
<...>
> Assuming you were talking about SQL2000 SP4
Yes of course.

> resolved by doing the following:
<...>
> "%PrograFiles%\Microsoft SQL Server\80\COM\replmerg.exe" /RegServer
I have the same problem on other machine with similar software and hardware
configuration.
I reregister this files on both but it not correct problem.

> If the above didn't resolve the issue, you may want to check the version
> of
> sqlrepss.dll in the Binn directory of your sql server instance. (Post the
> version number here if you don't know whether it looks right or not.)
It is 2000.80.2039.0 on both computers.

> Now even if you manage to resolve the issue, the bigger mystery here is
> why
> you managed to get your machine in the current state in the first place.
> It
> would be great if you can let us know of any recent unusual activity on
> the
> machine that might have led to the problem. For example, were there any
> error
> messages when you ran the SP4? Have you ever install SQL2005 on the
> machine
> (note: SQL2005 express comes with VS2005 beta also)?
Our last install before SQL SP4 was MS Virtual PC.
On virtual pc we have SQL Server 2005 and Visual Studio .Net 2005
(Technology Preview).
On both computers SP4 was installed without any error or warning message.
Regards,
Tomasz Skorupa

After restoring the Database getting this message "Cannot Modify record"

Good Morning Friends
I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
have got one application developed by some software agency using VB 6.0
and sql server 7.0. Since last 6 years everything worked
Three days my SQLserver machine crashed because of hard disk failure.
After much effort of two days I restored all the data from the
backup.In our Application primarily there are two sections Members and
Agency. Everything working fine in the Members section i.e browsing,
modification, deletion of records etc. But in the agency section only
browsing of record is working if I want to Edit the record and then
press the save button it gives the error message " Cannot Modify
Record, Please close the screen and reopen. All changes will be lost."
Actions Taken till now:
1. Change the deafult db to "ABC" for the user "CFC" Logging into the
SQLserver. This was the arrangement before crashing.
2. Granted the server role "db owner", "db creator" to the user "CFC".
3. Checked the tables permission of Members section (Where Modify is
working) as well as agency section (Where Modify is not working), both
the tables have same kind of permission.
4. Tried to get answer on google but of no help.
Please help me urgently.
Thanks
Deepak SinhaSo the application is not reporting the actual SQL Server error message?
Without that information, you are shooting in the dark. I suggest you run a
SQL Profiler trace and also include Errors/Exceptions. This will hopefully
help identify the cause of the error.
You mention that you restored from backup. Was this a SQL Server backup?
Did you reinstall SQL Server?
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
> Good Morning Friends
> I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> have got one application developed by some software agency using VB 6.0
> and sql server 7.0. Since last 6 years everything worked
> Three days my SQLserver machine crashed because of hard disk failure.
> After much effort of two days I restored all the data from the
> backup.In our Application primarily there are two sections Members and
> Agency. Everything working fine in the Members section i.e browsing,
> modification, deletion of records etc. But in the agency section only
> browsing of record is working if I want to Edit the record and then
> press the save button it gives the error message " Cannot Modify
> Record, Please close the screen and reopen. All changes will be lost."
> Actions Taken till now:
> 1. Change the deafult db to "ABC" for the user "CFC" Logging into the
> SQLserver. This was the arrangement before crashing.
> 2. Granted the server role "db owner", "db creator" to the user "CFC".
> 3. Checked the tables permission of Members section (Where Modify is
> working) as well as agency section (Where Modify is not working), both
> the tables have same kind of permission.
> 4. Tried to get answer on google but of no help.
> Please help me urgently.
> Thanks
> Deepak Sinha
>|||Thanks for ur reply Guzman.
1. Yes It was a SQL server backup
2. I did not reinstall SQL server .
I will run a SQL profiler trace and get back.
Thanks again.
Deepak
Dan Guzman wrote:[vbcol=seagreen]
> So the application is not reporting the actual SQL Server error message?
> Without that information, you are shooting in the dark. I suggest you run
a
> SQL Profiler trace and also include Errors/Exceptions. This will hopefull
y
> help identify the cause of the error.
> You mention that you restored from backup. Was this a SQL Server backup?
> Did you reinstall SQL Server?
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...|||How do I run SQL profiler with Errors/Exceptions included? By "Errors"
do you mean those Errors which I am getting in the application i.e
"Cannot Modify..." ! If yes How do I include this message in the
profiler, becse I do not see there any option for inclusion of my error
message. Please guide.
Deepak
microsoft . public . sqlserver wrote:[vbcol=seagreen]
> Thanks for ur reply Guzman.
> 1. Yes It was a SQL server backup
> 2. I did not reinstall SQL server .
> I will run a SQL profiler trace and get back.
> Thanks again.
> Deepak
> Dan Guzman wrote:|||> How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> do you mean those Errors which I am getting in the application i.e
> "Cannot Modify..." !
The 'Cannot Modify' message is not a SQL Server error message; it is a
generic message generated by the VB6 application, probably in response to a
SQL Server error. Hopefully, the trace will allow you to identify the
actual SQL Server error so that you can take corrective action.
I don't have SQL 7 Profiler available but I believe the steps are similar to
SQL 2000 Profiler. There should be an Errors and Warnings event class.
Include all those events.
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...
> How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> do you mean those Errors which I am getting in the application i.e
> "Cannot Modify..." ! If yes How do I include this message in the
> profiler, becse I do not see there any option for inclusion of my error
> message. Please guide.
> Deepak
> microsoft . public . sqlserver wrote:
>|||Sir,
On running SQL profiler with Error/Exceptions included It is showing
"Error: 16821, Severity: 16, State: 1" it is also giving another error
message
"Operating system Error 87., The Parameter is incorrect"
All these error messages in front of the database ID master while my
application is running on the database "ABC"
When I
Dan Guzman wrote:[vbcol=seagreen]
> The 'Cannot Modify' message is not a SQL Server error message; it is a
> generic message generated by the VB6 application, probably in response to
a
> SQL Server error. Hopefully, the trace will allow you to identify the
> actual SQL Server error so that you can take corrective action.
> I don't have SQL 7 Profiler available but I believe the steps are similar
to
> SQL 2000 Profiler. There should be an Errors and Warnings event class.
> Include all those events.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...|||Dear Sir
I ran the SQL profiler and I got these error messages
1. Error 16821, Severity: 16, state: 1
2. Operating system Error 87., The parameter is incorrect
3. sp_executesql N'UPDATE "INSDB".."INS_M_agency" SET
"reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4,'', ''
go
When I ran the above SQL statement in the Query Analyzer It is giving
Error message "Server: Msg 170, Level 15, State 1, Line 1"
" Line 1: Incorrect syntax near 'INSDB'."
4. UPDATE "INSDB".."INS_M_agency" SET
"reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4
g0
5. After the hard disk crash at the time of restoration I got this
Error message "[SQL-DMO] You must be logged in as 'sa' or a member of
sysadmin, or a member of dbcreator" to get rid of this problem I
downloaded SQL server Service pack 2 from microsoft site and installed
it. After the restoration every other part of the application working
except this. I doubt is it because of the service pack 2 ? Can I
upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
Please guide
Thanks
Deepak Sinha
microsoft . public . sqlserver wrote:[vbcol=seagreen]
> Sir,
> On running SQL profiler with Error/Exceptions included It is showing
> "Error: 16821, Severity: 16, State: 1" it is also giving another error
> message
> "Operating system Error 87., The Parameter is incorrect"
> All these error messages in front of the database ID master while my
> application is running on the database "ABC"
> When I
> Dan Guzman wrote:|||> except this. I doubt is it because of the service pack 2 ? Can I
> upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
I suggest you install SP4 since that's the final service pack for SQL 7.
Otherwise, you should run the same service pack as the original system.
That may be the underlying cause of these errors.
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154857843.655253.136200@.m73g2000cwd.googlegroups.com...
> Dear Sir
> I ran the SQL profiler and I got these error messages
> 1. Error 16821, Severity: 16, state: 1
> 2. Operating system Error 87., The parameter is incorrect
> 3. sp_executesql N'UPDATE "INSDB".."INS_M_agency" SET
> "reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4,'', ''
> go
> When I ran the above SQL statement in the Query Analyzer It is giving
> Error message "Server: Msg 170, Level 15, State 1, Line 1"
> " Line 1: Incorrect syntax near 'INSDB'."
>
> 4. UPDATE "INSDB".."INS_M_agency" SET
> "reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4
> g0
> 5. After the hard disk crash at the time of restoration I got this
> Error message "[SQL-DMO] You must be logged in as 'sa' or a member of
> sysadmin, or a member of dbcreator" to get rid of this problem I
> downloaded SQL server Service pack 2 from microsoft site and installed
> it. After the restoration every other part of the application working
> except this. I doubt is it because of the service pack 2 ? Can I
> upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
> Please guide
> Thanks
> Deepak Sinha
> microsoft . public . sqlserver wrote:
>|||I downloaded and installed the service pack 3 now my Enterprise Manager
is not starting after giving the previous user name(tre) and
password(****). It is saying "Connection failed check SQL server
registration properties" When I edit the reg. properties by giving
previous user-id and pwd it is saying "cannot open default database
'<ID>' . using master database instead". I tried changing default
database at the command prompt
C:\mssql7\binn>isql -E -d
1>use master
2>go
1>sp_defaultdb tre, insdb
2>go
Default database changed
1>exit
When I go back to Enterprise Manager it is still same. I am in a real
mess.
Pl. Guide.
Deepka
Dan Guzman wrote:[vbcol=seagreen]
> I suggest you install SP4 since that's the final service pack for SQL 7.
> Otherwise, you should run the same service pack as the original system.
> That may be the underlying cause of these errors.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154857843.655253.136200@.m73g2000cwd.googlegroups.com...|||Do you get any messages when you access the database?

>isql -E -d
>USE insdb
>GO
>exit
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154869759.625272.196410@.m73g2000cwd.googlegroups.com...
>I downloaded and installed the service pack 3 now my Enterprise Manager
> is not starting after giving the previous user name(tre) and
> password(****). It is saying "Connection failed check SQL server
> registration properties" When I edit the reg. properties by giving
> previous user-id and pwd it is saying "cannot open default database
> '<ID>' . using master database instead". I tried changing default
> database at the command prompt
> C:\mssql7\binn>isql -E -d
> 1>use master
> 2>go
> 1>sp_defaultdb tre, insdb
> 2>go
> Default database changed
> 1>exit
> When I go back to Enterprise Manager it is still same. I am in a real
> mess.
> Pl. Guide.
> Deepka
> Dan Guzman wrote:
>

After restoring the Database getting this message "Cannot Modify record"

Good Morning Friends
I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
have got one application developed by some software agency using VB 6.0
and sql server 7.0. Since last 6 years everything worked
Three days my SQLserver machine crashed because of hard disk failure.
After much effort of two days I restored all the data from the
backup.In our Application primarily there are two sections Members and
Agency. Everything working fine in the Members section i.e browsing,
modification, deletion of records etc. But in the agency section only
browsing of record is working if I want to Edit the record and then
press the save button it gives the error message " Cannot Modify
Record, Please close the screen and reopen. All changes will be lost."
Actions Taken till now:
1. Change the deafult db to "ABC" for the user "CFC" Logging into the
SQLserver. This was the arrangement before crashing.
2. Granted the server role "db owner", "db creator" to the user "CFC".
3. Checked the tables permission of Members section (Where Modify is
working) as well as agency section (Where Modify is not working), both
the tables have same kind of permission.
4. Tried to get answer on google but of no help.
Please help me urgently.
Thanks
Deepak SinhaSo the application is not reporting the actual SQL Server error message?
Without that information, you are shooting in the dark. I suggest you run a
SQL Profiler trace and also include Errors/Exceptions. This will hopefully
help identify the cause of the error.
You mention that you restored from backup. Was this a SQL Server backup?
Did you reinstall SQL Server?
--
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
> Good Morning Friends
> I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> have got one application developed by some software agency using VB 6.0
> and sql server 7.0. Since last 6 years everything worked
> Three days my SQLserver machine crashed because of hard disk failure.
> After much effort of two days I restored all the data from the
> backup.In our Application primarily there are two sections Members and
> Agency. Everything working fine in the Members section i.e browsing,
> modification, deletion of records etc. But in the agency section only
> browsing of record is working if I want to Edit the record and then
> press the save button it gives the error message " Cannot Modify
> Record, Please close the screen and reopen. All changes will be lost."
> Actions Taken till now:
> 1. Change the deafult db to "ABC" for the user "CFC" Logging into the
> SQLserver. This was the arrangement before crashing.
> 2. Granted the server role "db owner", "db creator" to the user "CFC".
> 3. Checked the tables permission of Members section (Where Modify is
> working) as well as agency section (Where Modify is not working), both
> the tables have same kind of permission.
> 4. Tried to get answer on google but of no help.
> Please help me urgently.
> Thanks
> Deepak Sinha
>|||Thanks for ur reply Guzman.
1. Yes It was a SQL server backup
2. I did not reinstall SQL server .
I will run a SQL profiler trace and get back.
Thanks again.
Deepak
Dan Guzman wrote:
> So the application is not reporting the actual SQL Server error message?
> Without that information, you are shooting in the dark. I suggest you run a
> SQL Profiler trace and also include Errors/Exceptions. This will hopefully
> help identify the cause of the error.
> You mention that you restored from backup. Was this a SQL Server backup?
> Did you reinstall SQL Server?
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
> > Good Morning Friends
> >
> > I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> > have got one application developed by some software agency using VB 6.0
> > and sql server 7.0. Since last 6 years everything worked
> > Three days my SQLserver machine crashed because of hard disk failure.
> > After much effort of two days I restored all the data from the
> > backup.In our Application primarily there are two sections Members and
> > Agency. Everything working fine in the Members section i.e browsing,
> > modification, deletion of records etc. But in the agency section only
> > browsing of record is working if I want to Edit the record and then
> > press the save button it gives the error message " Cannot Modify
> > Record, Please close the screen and reopen. All changes will be lost."
> > Actions Taken till now:
> > 1. Change the deafult db to "ABC" for the user "CFC" Logging into the
> > SQLserver. This was the arrangement before crashing.
> > 2. Granted the server role "db owner", "db creator" to the user "CFC".
> > 3. Checked the tables permission of Members section (Where Modify is
> > working) as well as agency section (Where Modify is not working), both
> > the tables have same kind of permission.
> > 4. Tried to get answer on google but of no help.
> >
> > Please help me urgently.
> >
> > Thanks
> >
> > Deepak Sinha
> >|||How do I run SQL profiler with Errors/Exceptions included? By "Errors"
do you mean those Errors which I am getting in the application i.e
"Cannot Modify..." ! If yes How do I include this message in the
profiler, becse I do not see there any option for inclusion of my error
message. Please guide.
Deepak
microsoft . public . sqlserver wrote:
> Thanks for ur reply Guzman.
> 1. Yes It was a SQL server backup
> 2. I did not reinstall SQL server .
> I will run a SQL profiler trace and get back.
> Thanks again.
> Deepak
> Dan Guzman wrote:
> > So the application is not reporting the actual SQL Server error message?
> > Without that information, you are shooting in the dark. I suggest you run a
> > SQL Profiler trace and also include Errors/Exceptions. This will hopefully
> > help identify the cause of the error.
> >
> > You mention that you restored from backup. Was this a SQL Server backup?
> > Did you reinstall SQL Server?
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> > news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
> > > Good Morning Friends
> > >
> > > I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> > > have got one application developed by some software agency using VB 6.0
> > > and sql server 7.0. Since last 6 years everything worked
> > > Three days my SQLserver machine crashed because of hard disk failure.
> > > After much effort of two days I restored all the data from the
> > > backup.In our Application primarily there are two sections Members and
> > > Agency. Everything working fine in the Members section i.e browsing,
> > > modification, deletion of records etc. But in the agency section only
> > > browsing of record is working if I want to Edit the record and then
> > > press the save button it gives the error message " Cannot Modify
> > > Record, Please close the screen and reopen. All changes will be lost."
> > > Actions Taken till now:
> > > 1. Change the deafult db to "ABC" for the user "CFC" Logging into the
> > > SQLserver. This was the arrangement before crashing.
> > > 2. Granted the server role "db owner", "db creator" to the user "CFC".
> > > 3. Checked the tables permission of Members section (Where Modify is
> > > working) as well as agency section (Where Modify is not working), both
> > > the tables have same kind of permission.
> > > 4. Tried to get answer on google but of no help.
> > >
> > > Please help me urgently.
> > >
> > > Thanks
> > >
> > > Deepak Sinha
> > >|||> How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> do you mean those Errors which I am getting in the application i.e
> "Cannot Modify..." !
The 'Cannot Modify' message is not a SQL Server error message; it is a
generic message generated by the VB6 application, probably in response to a
SQL Server error. Hopefully, the trace will allow you to identify the
actual SQL Server error so that you can take corrective action.
I don't have SQL 7 Profiler available but I believe the steps are similar to
SQL 2000 Profiler. There should be an Errors and Warnings event class.
Include all those events.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...
> How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> do you mean those Errors which I am getting in the application i.e
> "Cannot Modify..." ! If yes How do I include this message in the
> profiler, becse I do not see there any option for inclusion of my error
> message. Please guide.
> Deepak
> microsoft . public . sqlserver wrote:
>> Thanks for ur reply Guzman.
>> 1. Yes It was a SQL server backup
>> 2. I did not reinstall SQL server .
>> I will run a SQL profiler trace and get back.
>> Thanks again.
>> Deepak
>> Dan Guzman wrote:
>> > So the application is not reporting the actual SQL Server error
>> > message?
>> > Without that information, you are shooting in the dark. I suggest you
>> > run a
>> > SQL Profiler trace and also include Errors/Exceptions. This will
>> > hopefully
>> > help identify the cause of the error.
>> >
>> > You mention that you restored from backup. Was this a SQL Server
>> > backup?
>> > Did you reinstall SQL Server?
>> >
>> > --
>> > Hope this helps.
>> >
>> > Dan Guzman
>> > SQL Server MVP
>> >
>> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
>> > news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
>> > > Good Morning Friends
>> > >
>> > > I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
>> > > have got one application developed by some software agency using VB
>> > > 6.0
>> > > and sql server 7.0. Since last 6 years everything worked
>> > > Three days my SQLserver machine crashed because of hard disk failure.
>> > > After much effort of two days I restored all the data from the
>> > > backup.In our Application primarily there are two sections Members
>> > > and
>> > > Agency. Everything working fine in the Members section i.e browsing,
>> > > modification, deletion of records etc. But in the agency section only
>> > > browsing of record is working if I want to Edit the record and then
>> > > press the save button it gives the error message " Cannot Modify
>> > > Record, Please close the screen and reopen. All changes will be
>> > > lost."
>> > > Actions Taken till now:
>> > > 1. Change the deafult db to "ABC" for the user "CFC" Logging into the
>> > > SQLserver. This was the arrangement before crashing.
>> > > 2. Granted the server role "db owner", "db creator" to the user
>> > > "CFC".
>> > > 3. Checked the tables permission of Members section (Where Modify is
>> > > working) as well as agency section (Where Modify is not working),
>> > > both
>> > > the tables have same kind of permission.
>> > > 4. Tried to get answer on google but of no help.
>> > >
>> > > Please help me urgently.
>> > >
>> > > Thanks
>> > >
>> > > Deepak Sinha
>> > >
>|||Sir,
On running SQL profiler with Error/Exceptions included It is showing
"Error: 16821, Severity: 16, State: 1" it is also giving another error
message
"Operating system Error 87., The Parameter is incorrect"
All these error messages in front of the database ID master while my
application is running on the database "ABC"
When I
Dan Guzman wrote:
> > How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> > do you mean those Errors which I am getting in the application i.e
> > "Cannot Modify..." !
> The 'Cannot Modify' message is not a SQL Server error message; it is a
> generic message generated by the VB6 application, probably in response to a
> SQL Server error. Hopefully, the trace will allow you to identify the
> actual SQL Server error so that you can take corrective action.
> I don't have SQL 7 Profiler available but I believe the steps are similar to
> SQL 2000 Profiler. There should be an Errors and Warnings event class.
> Include all those events.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...
> > How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> > do you mean those Errors which I am getting in the application i.e
> > "Cannot Modify..." ! If yes How do I include this message in the
> > profiler, becse I do not see there any option for inclusion of my error
> > message. Please guide.
> >
> > Deepak
> >
> > microsoft . public . sqlserver wrote:
> >> Thanks for ur reply Guzman.
> >> 1. Yes It was a SQL server backup
> >> 2. I did not reinstall SQL server .
> >>
> >> I will run a SQL profiler trace and get back.
> >> Thanks again.
> >>
> >> Deepak
> >> Dan Guzman wrote:
> >> > So the application is not reporting the actual SQL Server error
> >> > message?
> >> > Without that information, you are shooting in the dark. I suggest you
> >> > run a
> >> > SQL Profiler trace and also include Errors/Exceptions. This will
> >> > hopefully
> >> > help identify the cause of the error.
> >> >
> >> > You mention that you restored from backup. Was this a SQL Server
> >> > backup?
> >> > Did you reinstall SQL Server?
> >> >
> >> > --
> >> > Hope this helps.
> >> >
> >> > Dan Guzman
> >> > SQL Server MVP
> >> >
> >> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> >> > news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
> >> > > Good Morning Friends
> >> > >
> >> > > I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> >> > > have got one application developed by some software agency using VB
> >> > > 6.0
> >> > > and sql server 7.0. Since last 6 years everything worked
> >> > > Three days my SQLserver machine crashed because of hard disk failure.
> >> > > After much effort of two days I restored all the data from the
> >> > > backup.In our Application primarily there are two sections Members
> >> > > and
> >> > > Agency. Everything working fine in the Members section i.e browsing,
> >> > > modification, deletion of records etc. But in the agency section only
> >> > > browsing of record is working if I want to Edit the record and then
> >> > > press the save button it gives the error message " Cannot Modify
> >> > > Record, Please close the screen and reopen. All changes will be
> >> > > lost."
> >> > > Actions Taken till now:
> >> > > 1. Change the deafult db to "ABC" for the user "CFC" Logging into the
> >> > > SQLserver. This was the arrangement before crashing.
> >> > > 2. Granted the server role "db owner", "db creator" to the user
> >> > > "CFC".
> >> > > 3. Checked the tables permission of Members section (Where Modify is
> >> > > working) as well as agency section (Where Modify is not working),
> >> > > both
> >> > > the tables have same kind of permission.
> >> > > 4. Tried to get answer on google but of no help.
> >> > >
> >> > > Please help me urgently.
> >> > >
> >> > > Thanks
> >> > >
> >> > > Deepak Sinha
> >> > >
> >|||Dear Sir
I ran the SQL profiler and I got these error messages
1. Error 16821, Severity: 16, state: 1
2. Operating system Error 87., The parameter is incorrect
3. sp_executesql N'UPDATE "INSDB".."INS_M_agency" SET
"reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4,'', ''
go
When I ran the above SQL statement in the Query Analyzer It is giving
Error message "Server: Msg 170, Level 15, State 1, Line 1"
" Line 1: Incorrect syntax near 'INSDB'."
4. UPDATE "INSDB".."INS_M_agency" SET
"reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4
g0
5. After the hard disk crash at the time of restoration I got this
Error message "[SQL-DMO] You must be logged in as 'sa' or a member of
sysadmin, or a member of dbcreator" to get rid of this problem I
downloaded SQL server Service pack 2 from microsoft site and installed
it. After the restoration every other part of the application working
except this. I doubt is it because of the service pack 2 ? Can I
upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
Please guide
Thanks
Deepak Sinha
microsoft . public . sqlserver wrote:
> Sir,
> On running SQL profiler with Error/Exceptions included It is showing
> "Error: 16821, Severity: 16, State: 1" it is also giving another error
> message
> "Operating system Error 87., The Parameter is incorrect"
> All these error messages in front of the database ID master while my
> application is running on the database "ABC"
> When I
> Dan Guzman wrote:
> > > How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> > > do you mean those Errors which I am getting in the application i.e
> > > "Cannot Modify..." !
> >
> > The 'Cannot Modify' message is not a SQL Server error message; it is a
> > generic message generated by the VB6 application, probably in response to a
> > SQL Server error. Hopefully, the trace will allow you to identify the
> > actual SQL Server error so that you can take corrective action.
> >
> > I don't have SQL 7 Profiler available but I believe the steps are similar to
> > SQL 2000 Profiler. There should be an Errors and Warnings event class.
> > Include all those events.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> > news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...
> > > How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> > > do you mean those Errors which I am getting in the application i.e
> > > "Cannot Modify..." ! If yes How do I include this message in the
> > > profiler, becse I do not see there any option for inclusion of my error
> > > message. Please guide.
> > >
> > > Deepak
> > >
> > > microsoft . public . sqlserver wrote:
> > >> Thanks for ur reply Guzman.
> > >> 1. Yes It was a SQL server backup
> > >> 2. I did not reinstall SQL server .
> > >>
> > >> I will run a SQL profiler trace and get back.
> > >> Thanks again.
> > >>
> > >> Deepak
> > >> Dan Guzman wrote:
> > >> > So the application is not reporting the actual SQL Server error
> > >> > message?
> > >> > Without that information, you are shooting in the dark. I suggest you
> > >> > run a
> > >> > SQL Profiler trace and also include Errors/Exceptions. This will
> > >> > hopefully
> > >> > help identify the cause of the error.
> > >> >
> > >> > You mention that you restored from backup. Was this a SQL Server
> > >> > backup?
> > >> > Did you reinstall SQL Server?
> > >> >
> > >> > --
> > >> > Hope this helps.
> > >> >
> > >> > Dan Guzman
> > >> > SQL Server MVP
> > >> >
> > >> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> > >> > news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
> > >> > > Good Morning Friends
> > >> > >
> > >> > > I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> > >> > > have got one application developed by some software agency using VB
> > >> > > 6.0
> > >> > > and sql server 7.0. Since last 6 years everything worked
> > >> > > Three days my SQLserver machine crashed because of hard disk failure.
> > >> > > After much effort of two days I restored all the data from the
> > >> > > backup.In our Application primarily there are two sections Members
> > >> > > and
> > >> > > Agency. Everything working fine in the Members section i.e browsing,
> > >> > > modification, deletion of records etc. But in the agency section only
> > >> > > browsing of record is working if I want to Edit the record and then
> > >> > > press the save button it gives the error message " Cannot Modify
> > >> > > Record, Please close the screen and reopen. All changes will be
> > >> > > lost."
> > >> > > Actions Taken till now:
> > >> > > 1. Change the deafult db to "ABC" for the user "CFC" Logging into the
> > >> > > SQLserver. This was the arrangement before crashing.
> > >> > > 2. Granted the server role "db owner", "db creator" to the user
> > >> > > "CFC".
> > >> > > 3. Checked the tables permission of Members section (Where Modify is
> > >> > > working) as well as agency section (Where Modify is not working),
> > >> > > both
> > >> > > the tables have same kind of permission.
> > >> > > 4. Tried to get answer on google but of no help.
> > >> > >
> > >> > > Please help me urgently.
> > >> > >
> > >> > > Thanks
> > >> > >
> > >> > > Deepak Sinha
> > >> > >
> > >|||> except this. I doubt is it because of the service pack 2 ? Can I
> upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
I suggest you install SP4 since that's the final service pack for SQL 7.
Otherwise, you should run the same service pack as the original system.
That may be the underlying cause of these errors.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154857843.655253.136200@.m73g2000cwd.googlegroups.com...
> Dear Sir
> I ran the SQL profiler and I got these error messages
> 1. Error 16821, Severity: 16, state: 1
> 2. Operating system Error 87., The parameter is incorrect
> 3. sp_executesql N'UPDATE "INSDB".."INS_M_agency" SET
> "reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4,'', ''
> go
> When I ran the above SQL statement in the Query Analyzer It is giving
> Error message "Server: Msg 170, Level 15, State 1, Line 1"
> " Line 1: Incorrect syntax near 'INSDB'."
>
> 4. UPDATE "INSDB".."INS_M_agency" SET
> "reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4
> g0
> 5. After the hard disk crash at the time of restoration I got this
> Error message "[SQL-DMO] You must be logged in as 'sa' or a member of
> sysadmin, or a member of dbcreator" to get rid of this problem I
> downloaded SQL server Service pack 2 from microsoft site and installed
> it. After the restoration every other part of the application working
> except this. I doubt is it because of the service pack 2 ? Can I
> upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
> Please guide
> Thanks
> Deepak Sinha
> microsoft . public . sqlserver wrote:
>> Sir,
>> On running SQL profiler with Error/Exceptions included It is showing
>> "Error: 16821, Severity: 16, State: 1" it is also giving another error
>> message
>> "Operating system Error 87., The Parameter is incorrect"
>> All these error messages in front of the database ID master while my
>> application is running on the database "ABC"
>> When I
>> Dan Guzman wrote:
>> > > How do I run SQL profiler with Errors/Exceptions included? By
>> > > "Errors"
>> > > do you mean those Errors which I am getting in the application i.e
>> > > "Cannot Modify..." !
>> >
>> > The 'Cannot Modify' message is not a SQL Server error message; it is a
>> > generic message generated by the VB6 application, probably in response
>> > to a
>> > SQL Server error. Hopefully, the trace will allow you to identify the
>> > actual SQL Server error so that you can take corrective action.
>> >
>> > I don't have SQL 7 Profiler available but I believe the steps are
>> > similar to
>> > SQL 2000 Profiler. There should be an Errors and Warnings event class.
>> > Include all those events.
>> >
>> > --
>> > Hope this helps.
>> >
>> > Dan Guzman
>> > SQL Server MVP
>> >
>> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
>> > news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...
>> > > How do I run SQL profiler with Errors/Exceptions included? By
>> > > "Errors"
>> > > do you mean those Errors which I am getting in the application i.e
>> > > "Cannot Modify..." ! If yes How do I include this message in the
>> > > profiler, becse I do not see there any option for inclusion of my
>> > > error
>> > > message. Please guide.
>> > >
>> > > Deepak
>> > >
>> > > microsoft . public . sqlserver wrote:
>> > >> Thanks for ur reply Guzman.
>> > >> 1. Yes It was a SQL server backup
>> > >> 2. I did not reinstall SQL server .
>> > >>
>> > >> I will run a SQL profiler trace and get back.
>> > >> Thanks again.
>> > >>
>> > >> Deepak
>> > >> Dan Guzman wrote:
>> > >> > So the application is not reporting the actual SQL Server error
>> > >> > message?
>> > >> > Without that information, you are shooting in the dark. I suggest
>> > >> > you
>> > >> > run a
>> > >> > SQL Profiler trace and also include Errors/Exceptions. This will
>> > >> > hopefully
>> > >> > help identify the cause of the error.
>> > >> >
>> > >> > You mention that you restored from backup. Was this a SQL Server
>> > >> > backup?
>> > >> > Did you reinstall SQL Server?
>> > >> >
>> > >> > --
>> > >> > Hope this helps.
>> > >> >
>> > >> > Dan Guzman
>> > >> > SQL Server MVP
>> > >> >
>> > >> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in
>> > >> > message
>> > >> > news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
>> > >> > > Good Morning Friends
>> > >> > >
>> > >> > > I am in real soup. I am new to SQL server 7.0 and Visual basic
>> > >> > > 6.0. I
>> > >> > > have got one application developed by some software agency using
>> > >> > > VB
>> > >> > > 6.0
>> > >> > > and sql server 7.0. Since last 6 years everything worked
>> > >> > > Three days my SQLserver machine crashed because of hard disk
>> > >> > > failure.
>> > >> > > After much effort of two days I restored all the data from the
>> > >> > > backup.In our Application primarily there are two sections
>> > >> > > Members
>> > >> > > and
>> > >> > > Agency. Everything working fine in the Members section i.e
>> > >> > > browsing,
>> > >> > > modification, deletion of records etc. But in the agency section
>> > >> > > only
>> > >> > > browsing of record is working if I want to Edit the record and
>> > >> > > then
>> > >> > > press the save button it gives the error message " Cannot Modify
>> > >> > > Record, Please close the screen and reopen. All changes will be
>> > >> > > lost."
>> > >> > > Actions Taken till now:
>> > >> > > 1. Change the deafult db to "ABC" for the user "CFC" Logging
>> > >> > > into the
>> > >> > > SQLserver. This was the arrangement before crashing.
>> > >> > > 2. Granted the server role "db owner", "db creator" to the user
>> > >> > > "CFC".
>> > >> > > 3. Checked the tables permission of Members section (Where
>> > >> > > Modify is
>> > >> > > working) as well as agency section (Where Modify is not
>> > >> > > working),
>> > >> > > both
>> > >> > > the tables have same kind of permission.
>> > >> > > 4. Tried to get answer on google but of no help.
>> > >> > >
>> > >> > > Please help me urgently.
>> > >> > >
>> > >> > > Thanks
>> > >> > >
>> > >> > > Deepak Sinha
>> > >> > >
>> > >
>|||I downloaded and installed the service pack 3 now my Enterprise Manager
is not starting after giving the previous user name(tre) and
password(****). It is saying "Connection failed check SQL server
registration properties" When I edit the reg. properties by giving
previous user-id and pwd it is saying "cannot open default database
'<ID>' . using master database instead". I tried changing default
database at the command prompt
C:\mssql7\binn>isql -E -d
1>use master
2>go
1>sp_defaultdb tre, insdb
2>go
Default database changed
1>exit
When I go back to Enterprise Manager it is still same. I am in a real
mess.
Pl. Guide.
Deepka
Dan Guzman wrote:
> > except this. I doubt is it because of the service pack 2 ? Can I
> > upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
> I suggest you install SP4 since that's the final service pack for SQL 7.
> Otherwise, you should run the same service pack as the original system.
> That may be the underlying cause of these errors.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154857843.655253.136200@.m73g2000cwd.googlegroups.com...
> > Dear Sir
> > I ran the SQL profiler and I got these error messages
> > 1. Error 16821, Severity: 16, state: 1
> > 2. Operating system Error 87., The parameter is incorrect
> > 3. sp_executesql N'UPDATE "INSDB".."INS_M_agency" SET
> > "reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4,'', ''
> > go
> >
> > When I ran the above SQL statement in the Query Analyzer It is giving
> > Error message "Server: Msg 170, Level 15, State 1, Line 1"
> > " Line 1: Incorrect syntax near 'INSDB'."
> >
> >
> > 4. UPDATE "INSDB".."INS_M_agency" SET
> > "reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4
> > g0
> >
> > 5. After the hard disk crash at the time of restoration I got this
> > Error message "[SQL-DMO] You must be logged in as 'sa' or a member of
> > sysadmin, or a member of dbcreator" to get rid of this problem I
> > downloaded SQL server Service pack 2 from microsoft site and installed
> > it. After the restoration every other part of the application working
> > except this. I doubt is it because of the service pack 2 ? Can I
> > upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
> >
> > Please guide
> >
> > Thanks
> > Deepak Sinha
> >
> > microsoft . public . sqlserver wrote:
> >> Sir,
> >>
> >> On running SQL profiler with Error/Exceptions included It is showing
> >> "Error: 16821, Severity: 16, State: 1" it is also giving another error
> >> message
> >> "Operating system Error 87., The Parameter is incorrect"
> >> All these error messages in front of the database ID master while my
> >> application is running on the database "ABC"
> >> When I
> >> Dan Guzman wrote:
> >> > > How do I run SQL profiler with Errors/Exceptions included? By
> >> > > "Errors"
> >> > > do you mean those Errors which I am getting in the application i.e
> >> > > "Cannot Modify..." !
> >> >
> >> > The 'Cannot Modify' message is not a SQL Server error message; it is a
> >> > generic message generated by the VB6 application, probably in response
> >> > to a
> >> > SQL Server error. Hopefully, the trace will allow you to identify the
> >> > actual SQL Server error so that you can take corrective action.
> >> >
> >> > I don't have SQL 7 Profiler available but I believe the steps are
> >> > similar to
> >> > SQL 2000 Profiler. There should be an Errors and Warnings event class.
> >> > Include all those events.
> >> >
> >> > --
> >> > Hope this helps.
> >> >
> >> > Dan Guzman
> >> > SQL Server MVP
> >> >
> >> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> >> > news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...
> >> > > How do I run SQL profiler with Errors/Exceptions included? By
> >> > > "Errors"
> >> > > do you mean those Errors which I am getting in the application i.e
> >> > > "Cannot Modify..." ! If yes How do I include this message in the
> >> > > profiler, becse I do not see there any option for inclusion of my
> >> > > error
> >> > > message. Please guide.
> >> > >
> >> > > Deepak
> >> > >
> >> > > microsoft . public . sqlserver wrote:
> >> > >> Thanks for ur reply Guzman.
> >> > >> 1. Yes It was a SQL server backup
> >> > >> 2. I did not reinstall SQL server .
> >> > >>
> >> > >> I will run a SQL profiler trace and get back.
> >> > >> Thanks again.
> >> > >>
> >> > >> Deepak
> >> > >> Dan Guzman wrote:
> >> > >> > So the application is not reporting the actual SQL Server error
> >> > >> > message?
> >> > >> > Without that information, you are shooting in the dark. I suggest
> >> > >> > you
> >> > >> > run a
> >> > >> > SQL Profiler trace and also include Errors/Exceptions. This will
> >> > >> > hopefully
> >> > >> > help identify the cause of the error.
> >> > >> >
> >> > >> > You mention that you restored from backup. Was this a SQL Server
> >> > >> > backup?
> >> > >> > Did you reinstall SQL Server?
> >> > >> >
> >> > >> > --
> >> > >> > Hope this helps.
> >> > >> >
> >> > >> > Dan Guzman
> >> > >> > SQL Server MVP
> >> > >> >
> >> > >> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in
> >> > >> > message
> >> > >> > news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
> >> > >> > > Good Morning Friends
> >> > >> > >
> >> > >> > > I am in real soup. I am new to SQL server 7.0 and Visual basic
> >> > >> > > 6.0. I
> >> > >> > > have got one application developed by some software agency using
> >> > >> > > VB
> >> > >> > > 6.0
> >> > >> > > and sql server 7.0. Since last 6 years everything worked
> >> > >> > > Three days my SQLserver machine crashed because of hard disk
> >> > >> > > failure.
> >> > >> > > After much effort of two days I restored all the data from the
> >> > >> > > backup.In our Application primarily there are two sections
> >> > >> > > Members
> >> > >> > > and
> >> > >> > > Agency. Everything working fine in the Members section i.e
> >> > >> > > browsing,
> >> > >> > > modification, deletion of records etc. But in the agency section
> >> > >> > > only
> >> > >> > > browsing of record is working if I want to Edit the record and
> >> > >> > > then
> >> > >> > > press the save button it gives the error message " Cannot Modify
> >> > >> > > Record, Please close the screen and reopen. All changes will be
> >> > >> > > lost."
> >> > >> > > Actions Taken till now:
> >> > >> > > 1. Change the deafult db to "ABC" for the user "CFC" Logging
> >> > >> > > into the
> >> > >> > > SQLserver. This was the arrangement before crashing.
> >> > >> > > 2. Granted the server role "db owner", "db creator" to the user
> >> > >> > > "CFC".
> >> > >> > > 3. Checked the tables permission of Members section (Where
> >> > >> > > Modify is
> >> > >> > > working) as well as agency section (Where Modify is not
> >> > >> > > working),
> >> > >> > > both
> >> > >> > > the tables have same kind of permission.
> >> > >> > > 4. Tried to get answer on google but of no help.
> >> > >> > >
> >> > >> > > Please help me urgently.
> >> > >> > >
> >> > >> > > Thanks
> >> > >> > >
> >> > >> > > Deepak Sinha
> >> > >> > >
> >> > >
> >|||Do you get any messages when you access the database?
>isql -E -d
>USE insdb
>GO
>exit
--
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154869759.625272.196410@.m73g2000cwd.googlegroups.com...
>I downloaded and installed the service pack 3 now my Enterprise Manager
> is not starting after giving the previous user name(tre) and
> password(****). It is saying "Connection failed check SQL server
> registration properties" When I edit the reg. properties by giving
> previous user-id and pwd it is saying "cannot open default database
> '<ID>' . using master database instead". I tried changing default
> database at the command prompt
> C:\mssql7\binn>isql -E -d
> 1>use master
> 2>go
> 1>sp_defaultdb tre, insdb
> 2>go
> Default database changed
> 1>exit
> When I go back to Enterprise Manager it is still same. I am in a real
> mess.
> Pl. Guide.
> Deepka
> Dan Guzman wrote:
>> > except this. I doubt is it because of the service pack 2 ? Can I
>> > upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
>> I suggest you install SP4 since that's the final service pack for SQL 7.
>> Otherwise, you should run the same service pack as the original system.
>> That may be the underlying cause of these errors.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
>> news:1154857843.655253.136200@.m73g2000cwd.googlegroups.com...
>> > Dear Sir
>> > I ran the SQL profiler and I got these error messages
>> > 1. Error 16821, Severity: 16, state: 1
>> > 2. Operating system Error 87., The parameter is incorrect
>> > 3. sp_executesql N'UPDATE "INSDB".."INS_M_agency" SET
>> > "reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4,'', ''
>> > go
>> >
>> > When I ran the above SQL statement in the Query Analyzer It is giving
>> > Error message "Server: Msg 170, Level 15, State 1, Line 1"
>> > " Line 1: Incorrect syntax near 'INSDB'."
>> >
>> >
>> > 4. UPDATE "INSDB".."INS_M_agency" SET
>> > "reg_code"=@.P1,"agen_name"=@.P2,"agen_place"=@.P3,"estb_date"=@.P4
>> > g0
>> >
>> > 5. After the hard disk crash at the time of restoration I got this
>> > Error message "[SQL-DMO] You must be logged in as 'sa' or a member of
>> > sysadmin, or a member of dbcreator" to get rid of this problem I
>> > downloaded SQL server Service pack 2 from microsoft site and installed
>> > it. After the restoration every other part of the application working
>> > except this. I doubt is it because of the service pack 2 ? Can I
>> > upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
>> >
>> > Please guide
>> >
>> > Thanks
>> > Deepak Sinha
>> >
>> > microsoft . public . sqlserver wrote:
>> >> Sir,
>> >>
>> >> On running SQL profiler with Error/Exceptions included It is showing
>> >> "Error: 16821, Severity: 16, State: 1" it is also giving another error
>> >> message
>> >> "Operating system Error 87., The Parameter is incorrect"
>> >> All these error messages in front of the database ID master while my
>> >> application is running on the database "ABC"
>> >> When I
>> >> Dan Guzman wrote:
>> >> > > How do I run SQL profiler with Errors/Exceptions included? By
>> >> > > "Errors"
>> >> > > do you mean those Errors which I am getting in the application i.e
>> >> > > "Cannot Modify..." !
>> >> >
>> >> > The 'Cannot Modify' message is not a SQL Server error message; it is
>> >> > a
>> >> > generic message generated by the VB6 application, probably in
>> >> > response
>> >> > to a
>> >> > SQL Server error. Hopefully, the trace will allow you to identify
>> >> > the
>> >> > actual SQL Server error so that you can take corrective action.
>> >> >
>> >> > I don't have SQL 7 Profiler available but I believe the steps are
>> >> > similar to
>> >> > SQL 2000 Profiler. There should be an Errors and Warnings event
>> >> > class.
>> >> > Include all those events.
>> >> >
>> >> > --
>> >> > Hope this helps.
>> >> >
>> >> > Dan Guzman
>> >> > SQL Server MVP
>> >> >
>> >> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in
>> >> > message
>> >> > news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...
>> >> > > How do I run SQL profiler with Errors/Exceptions included? By
>> >> > > "Errors"
>> >> > > do you mean those Errors which I am getting in the application i.e
>> >> > > "Cannot Modify..." ! If yes How do I include this message in the
>> >> > > profiler, becse I do not see there any option for inclusion of my
>> >> > > error
>> >> > > message. Please guide.
>> >> > >
>> >> > > Deepak
>> >> > >
>> >> > > microsoft . public . sqlserver wrote:
>> >> > >> Thanks for ur reply Guzman.
>> >> > >> 1. Yes It was a SQL server backup
>> >> > >> 2. I did not reinstall SQL server .
>> >> > >>
>> >> > >> I will run a SQL profiler trace and get back.
>> >> > >> Thanks again.
>> >> > >>
>> >> > >> Deepak
>> >> > >> Dan Guzman wrote:
>> >> > >> > So the application is not reporting the actual SQL Server error
>> >> > >> > message?
>> >> > >> > Without that information, you are shooting in the dark. I
>> >> > >> > suggest
>> >> > >> > you
>> >> > >> > run a
>> >> > >> > SQL Profiler trace and also include Errors/Exceptions. This
>> >> > >> > will
>> >> > >> > hopefully
>> >> > >> > help identify the cause of the error.
>> >> > >> >
>> >> > >> > You mention that you restored from backup. Was this a SQL
>> >> > >> > Server
>> >> > >> > backup?
>> >> > >> > Did you reinstall SQL Server?
>> >> > >> >
>> >> > >> > --
>> >> > >> > Hope this helps.
>> >> > >> >
>> >> > >> > Dan Guzman
>> >> > >> > SQL Server MVP
>> >> > >> >
>> >> > >> > "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in
>> >> > >> > message
>> >> > >> > news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...
>> >> > >> > > Good Morning Friends
>> >> > >> > >
>> >> > >> > > I am in real soup. I am new to SQL server 7.0 and Visual
>> >> > >> > > basic
>> >> > >> > > 6.0. I
>> >> > >> > > have got one application developed by some software agency
>> >> > >> > > using
>> >> > >> > > VB
>> >> > >> > > 6.0
>> >> > >> > > and sql server 7.0. Since last 6 years everything worked
>> >> > >> > > Three days my SQLserver machine crashed because of hard disk
>> >> > >> > > failure.
>> >> > >> > > After much effort of two days I restored all the data from
>> >> > >> > > the
>> >> > >> > > backup.In our Application primarily there are two sections
>> >> > >> > > Members
>> >> > >> > > and
>> >> > >> > > Agency. Everything working fine in the Members section i.e
>> >> > >> > > browsing,
>> >> > >> > > modification, deletion of records etc. But in the agency
>> >> > >> > > section
>> >> > >> > > only
>> >> > >> > > browsing of record is working if I want to Edit the record
>> >> > >> > > and
>> >> > >> > > then
>> >> > >> > > press the save button it gives the error message " Cannot
>> >> > >> > > Modify
>> >> > >> > > Record, Please close the screen and reopen. All changes will
>> >> > >> > > be
>> >> > >> > > lost."
>> >> > >> > > Actions Taken till now:
>> >> > >> > > 1. Change the deafult db to "ABC" for the user "CFC" Logging
>> >> > >> > > into the
>> >> > >> > > SQLserver. This was the arrangement before crashing.
>> >> > >> > > 2. Granted the server role "db owner", "db creator" to the
>> >> > >> > > user
>> >> > >> > > "CFC".
>> >> > >> > > 3. Checked the tables permission of Members section (Where
>> >> > >> > > Modify is
>> >> > >> > > working) as well as agency section (Where Modify is not
>> >> > >> > > working),
>> >> > >> > > both
>> >> > >> > > the tables have same kind of permission.
>> >> > >> > > 4. Tried to get answer on google but of no help.
>> >> > >> > >
>> >> > >> > > Please help me urgently.
>> >> > >> > >
>> >> > >> > > Thanks
>> >> > >> > >
>> >> > >> > > Deepak Sinha
>> >> > >> > >
>> >> > >
>> >
>