SQLAgentMail: message

Showing posts with label message. Show all posts

Friday, March 23, 2012

Question On Stored Procedures

Hello and thank you for taking the time to read this message.I realize this maybe a little out of scope but I was just wondering if anybody had some suggestions about the best way to learn how to write stored procedures in sql sever. I've written some very simple ones, but the more research I do, the more I realize I don't know. I have learned some things by just getting into the ASP books but these really don't fully "tackle" the subject per say. If anybody has any suggestions as to a method or a book, it would be greatly appreciated.
Best Regards,
JasonCheck out this highly recommended book:

Rob Veiera's Professional SQL Server 2000 Programming

You might also consider Ken Henderson'sThe Guru's Guide to SQL Server Stored Procedures, XML, and HTML.

sql

Wednesday, March 7, 2012

Question on Error message

Running SQL Server 2000 and new to the DBMS. Getting a consistent error
messahe on a test system
'Backup failed to complete the command EmptyTransactionLog1"
I checked the documentation, and the OS logs but no additional info.
Seems to be happening either at startup ot shortly thereafter.
Any thoughts on this?
As a newbie, one (of many) things I find a bit confusing in SQL Server
is that if someone clicked through the database...selected all
tasks...create backup etc...that that backup would not show up in a
database maintenance plan. If you go into that wizard anything already
set to run does not show.
Is there any way to determine if somebody has any type of backup taking
place on a db other than log messages?
Thanks in advance.
GerryIn Enterprise Manager, Under Management, you will find both Backup jobs and
Maintenance plans.
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1153322062.758721.87120@.m73g2000cwd.googlegroups.com...
> Running SQL Server 2000 and new to the DBMS. Getting a consistent error
> messahe on a test system
> 'Backup failed to complete the command EmptyTransactionLog1"
> I checked the documentation, and the OS logs but no additional info.
> Seems to be happening either at startup ot shortly thereafter.
> Any thoughts on this?
> As a newbie, one (of many) things I find a bit confusing in SQL Server
> is that if someone clicked through the database...selected all
> tasks...create backup etc...that that backup would not show up in a
> database maintenance plan. If you go into that wizard anything already
> set to run does not show.
> Is there any way to determine if somebody has any type of backup taking
> place on a db other than log messages?
> Thanks in advance.
> Gerry
>|||Arnie:
I don't see anything in either place. I assume that means that no
backups are taking place.
What I'm not clear on is if no backups of any type are taking
place...why am I getting the 'backup failed to complete the comand'
error message
Thanks
Gerry
Arnie Rowland wrote:
> In Enterprise Manager, Under Management, you will find both Backup jobs and
> Maintenance plans.
> --
> Arnie Rowland
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "DataPro" <datapro01@.yahoo.com> wrote in message
> news:1153322062.758721.87120@.m73g2000cwd.googlegroups.com...
> > Running SQL Server 2000 and new to the DBMS. Getting a consistent error
> > messahe on a test system
> >
> > 'Backup failed to complete the command EmptyTransactionLog1"
> >
> > I checked the documentation, and the OS logs but no additional info.
> > Seems to be happening either at startup ot shortly thereafter.
> >
> > Any thoughts on this?
> >
> > As a newbie, one (of many) things I find a bit confusing in SQL Server
> > is that if someone clicked through the database...selected all
> > tasks...create backup etc...that that backup would not show up in a
> > database maintenance plan. If you go into that wizard anything already
> > set to run does not show.
> >
> > Is there any way to determine if somebody has any type of backup taking
> > place on a db other than log messages?
> >
> > Thanks in advance.
> >
> > Gerry
> >|||Check to see if there are Maintenance Plans configured. Backup could be part
of a Maintenance Plan.
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1153401613.227886.99740@.h48g2000cwc.googlegroups.com...
> Arnie:
> I don't see anything in either place. I assume that means that no
> backups are taking place.
> What I'm not clear on is if no backups of any type are taking
> place...why am I getting the 'backup failed to complete the comand'
> error message
> Thanks
> Gerry
>
> Arnie Rowland wrote:
>> In Enterprise Manager, Under Management, you will find both Backup jobs
>> and
>> Maintenance plans.
>> --
>> Arnie Rowland
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>> "DataPro" <datapro01@.yahoo.com> wrote in message
>> news:1153322062.758721.87120@.m73g2000cwd.googlegroups.com...
>> > Running SQL Server 2000 and new to the DBMS. Getting a consistent error
>> > messahe on a test system
>> >
>> > 'Backup failed to complete the command EmptyTransactionLog1"
>> >
>> > I checked the documentation, and the OS logs but no additional info.
>> > Seems to be happening either at startup ot shortly thereafter.
>> >
>> > Any thoughts on this?
>> >
>> > As a newbie, one (of many) things I find a bit confusing in SQL Server
>> > is that if someone clicked through the database...selected all
>> > tasks...create backup etc...that that backup would not show up in a
>> > database maintenance plan. If you go into that wizard anything already
>> > set to run does not show.
>> >
>> > Is there any way to determine if somebody has any type of backup taking
>> > place on a db other than log messages?
>> >
>> > Thanks in advance.
>> >
>> > Gerry
>> >
>|||No, there aren't.
Wouldn't the command 'EmptyTransactionLog' be some kind of truncation
command?
Arnie Rowland wrote:
> Check to see if there are Maintenance Plans configured. Backup could be part
> of a Maintenance Plan.
> --
> Arnie Rowland
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "DataPro" <datapro01@.yahoo.com> wrote in message
> news:1153401613.227886.99740@.h48g2000cwc.googlegroups.com...
> > Arnie:
> >
> > I don't see anything in either place. I assume that means that no
> > backups are taking place.
> >
> > What I'm not clear on is if no backups of any type are taking
> > place...why am I getting the 'backup failed to complete the comand'
> > error message
> >
> > Thanks
> > Gerry
> >
> >
> > Arnie Rowland wrote:
> >> In Enterprise Manager, Under Management, you will find both Backup jobs
> >> and
> >> Maintenance plans.
> >>
> >> --
> >> Arnie Rowland
> >> Most good judgment comes from experience.
> >> Most experience comes from bad judgment.
> >> - Anonymous
> >>
> >>
> >> "DataPro" <datapro01@.yahoo.com> wrote in message
> >> news:1153322062.758721.87120@.m73g2000cwd.googlegroups.com...
> >> > Running SQL Server 2000 and new to the DBMS. Getting a consistent error
> >> > messahe on a test system
> >> >
> >> > 'Backup failed to complete the command EmptyTransactionLog1"
> >> >
> >> > I checked the documentation, and the OS logs but no additional info.
> >> > Seems to be happening either at startup ot shortly thereafter.
> >> >
> >> > Any thoughts on this?
> >> >
> >> > As a newbie, one (of many) things I find a bit confusing in SQL Server
> >> > is that if someone clicked through the database...selected all
> >> > tasks...create backup etc...that that backup would not show up in a
> >> > database maintenance plan. If you go into that wizard anything already
> >> > set to run does not show.
> >> >
> >> > Is there any way to determine if somebody has any type of backup taking
> >> > place on a db other than log messages?
> >> >
> >> > Thanks in advance.
> >> >
> >> > Gerry
> >> >
> >|||DataPro wrote:
> No, there aren't.
> Wouldn't the command 'EmptyTransactionLog' be some kind of truncation
> command?
>
Where are you seeing this error message? Can you post the ENTIRE error
message here?
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I haven't seen or heard of such a command. I'm wondering if it is a
'comment' in a script, job, etc.
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1153478749.916109.113570@.i42g2000cwa.googlegroups.com...
> No, there aren't.
> Wouldn't the command 'EmptyTransactionLog' be some kind of truncation
> command?
>
> Arnie Rowland wrote:
>> Check to see if there are Maintenance Plans configured. Backup could be
>> part
>> of a Maintenance Plan.
>> --
>> Arnie Rowland
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>> "DataPro" <datapro01@.yahoo.com> wrote in message
>> news:1153401613.227886.99740@.h48g2000cwc.googlegroups.com...
>> > Arnie:
>> >
>> > I don't see anything in either place. I assume that means that no
>> > backups are taking place.
>> >
>> > What I'm not clear on is if no backups of any type are taking
>> > place...why am I getting the 'backup failed to complete the comand'
>> > error message
>> >
>> > Thanks
>> > Gerry
>> >
>> >
>> > Arnie Rowland wrote:
>> >> In Enterprise Manager, Under Management, you will find both Backup
>> >> jobs
>> >> and
>> >> Maintenance plans.
>> >>
>> >> --
>> >> Arnie Rowland
>> >> Most good judgment comes from experience.
>> >> Most experience comes from bad judgment.
>> >> - Anonymous
>> >>
>> >>
>> >> "DataPro" <datapro01@.yahoo.com> wrote in message
>> >> news:1153322062.758721.87120@.m73g2000cwd.googlegroups.com...
>> >> > Running SQL Server 2000 and new to the DBMS. Getting a consistent
>> >> > error
>> >> > messahe on a test system
>> >> >
>> >> > 'Backup failed to complete the command EmptyTransactionLog1"
>> >> >
>> >> > I checked the documentation, and the OS logs but no additional info.
>> >> > Seems to be happening either at startup ot shortly thereafter.
>> >> >
>> >> > Any thoughts on this?
>> >> >
>> >> > As a newbie, one (of many) things I find a bit confusing in SQL
>> >> > Server
>> >> > is that if someone clicked through the database...selected all
>> >> > tasks...create backup etc...that that backup would not show up in a
>> >> > database maintenance plan. If you go into that wizard anything
>> >> > already
>> >> > set to run does not show.
>> >> >
>> >> > Is there any way to determine if somebody has any type of backup
>> >> > taking
>> >> > place on a db other than log messages?
>> >> >
>> >> > Thanks in advance.
>> >> >
>> >> > Gerry
>> >> >
>> >
>|||This is the message...now repeating every 30 minutes
BACKUP failed to complete the command EmptyTransactionLog;1
It seems to happen shortly after startup and follows this notation in
the log, before just repeating itself over and over
SQL global counter collection task is created.
I did a search on the web and found one reference to this message. But
no clue on what it means.
Thanks
Gerry|||Gerry,
What service pack do you have installed?
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1153765668.194365.252410@.m79g2000cwm.googlegroups.com...
> This is the message...now repeating every 30 minutes
> BACKUP failed to complete the command EmptyTransactionLog;1
> It seems to happen shortly after startup and follows this notation in
> the log, before just repeating itself over and over
> SQL global counter collection task is created.
> I did a search on the web and found one reference to this message. But
> no clue on what it means.
> Thanks
> Gerry
>|||This is a multi-part message in MIME format.
--020206070802010300020903
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
DataPro wrote:
> This is the message...now repeating every 30 minutes
> BACKUP failed to complete the command EmptyTransactionLog;1
> It seems to happen shortly after startup and follows this notation in
> the log, before just repeating itself over and over
> SQL global counter collection task is created.
> I did a search on the web and found one reference to this message. But
> no clue on what it means.
> Thanks
> Gerry
>
Hi Gerry
It sounds like you have a job scheduled to run every 30 minutes that
does something to a logfile. It could the that it tries to backup a
logfile for a database that has been set to SIMPLE recovery.
--
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--020206070802010300020903
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
DataPro wrote:
<blockquote
cite="mid1153765668.194365.252410@.m79g2000cwm.googlegroups.com"
type="cite">
<pre wrap="">This is the message...now repeating every 30 minutes
BACKUP failed to complete the command EmptyTransactionLog;1
It seems to happen shortly after startup and follows this notation in
the log, before just repeating itself over and over
SQL global counter collection task is created.
I did a search on the web and found one reference to this message. But
no clue on what it means.
Thanks
Gerry
</pre>
</blockquote>
Hi Gerry 
 
It sounds like you have a job scheduled to run every 30 minutes that
does something to a logfile. It could the that it tries to backup a
logfile for a database that has been set to SIMPLE recovery. 
 
-- 
Regards 
Steen Schlüter Persson 
Databaseadministrator / Systemadministrator 
 

</body>
</html>
--020206070802010300020903--|||Arnie:
Service pack 4
Gerry
Arnie Rowland wrote:
> Gerry,
> What service pack do you have installed?
> --
> Arnie Rowland
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "DataPro" <datapro01@.yahoo.com> wrote in message
> news:1153765668.194365.252410@.m79g2000cwm.googlegroups.com...
> > This is the message...now repeating every 30 minutes
> >
> > BACKUP failed to complete the command EmptyTransactionLog;1
> >
> > It seems to happen shortly after startup and follows this notation in
> > the log, before just repeating itself over and over
> >
> > SQL global counter collection task is created.
> >
> > I did a search on the web and found one reference to this message. But
> > no clue on what it means.
> >
> > Thanks
> > Gerry
> >|||Steen:
There is no reference in the message to which db might be involved.
However I do see that both databases they are using are set to Simple
mode.
When I look under SQL Agent/Jobs I only see job scheduled to run
every end of month.
Any thoughts ?
Thanks
Gerry
Steen Persson (DK) wrote:
> DataPro wrote:
> > This is the message...now repeating every 30 minutes
> >
> > BACKUP failed to complete the command EmptyTransactionLog;1
> >
> > It seems to happen shortly after startup and follows this notation in
> > the log, before just repeating itself over and over
> >
> > SQL global counter collection task is created.
> >
> > I did a search on the web and found one reference to this message. But
> > no clue on what it means.
> >
> > Thanks
> > Gerry
> >
> >
> Hi Gerry
> It sounds like you have a job scheduled to run every 30 minutes that
> does something to a logfile. It could the that it tries to backup a
> logfile for a database that has been set to SIMPLE recovery.
> --
> Regards
> Steen Schl=FCter Persson
> Databaseadministrator / Systemadministrator
>
> --020206070802010300020903
> Content-Type: text/html; charset=3DISO-8859-1
> X-Google-AttachSize: 1139
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content=3D"text/html;charset=3DISO-8859-1" http-equiv=3D"Content-=Type">
> </head>
> <body bgcolor=3D"#ffffff" text=3D"#000000">
> DataPro wrote:
> <blockquote
> cite=3D"mid1153765668.194365.252410@.m79g2000cwm.googlegroups.com"
> type=3D"cite">
> <pre wrap=3D"">This is the message...now repeating every 30 minutes
> BACKUP failed to complete the command EmptyTransactionLog;1
> It seems to happen shortly after startup and follows this notation in
> the log, before just repeating itself over and over
> SQL global counter collection task is created.
> I did a search on the web and found one reference to this message. But
> no clue on what it means.
> Thanks
> Gerry
> </pre>
> </blockquote>
> Hi Gerry 
> 
> It sounds like you have a job scheduled to run every 30 minutes that
> does something to a logfile. It could the that it tries to backup a
> logfile for a database that has been set to SIMPLE recovery. 
> 
> -- 
> Regards 
> Steen Schlüter Persson 
> Databaseadministrator / Systemadministrator 
> 
> 
> </body>
> </html>
> > --020206070802010300020903--

Question on Error message

Monday, February 20, 2012

Question on attribute keys of measure group

Hi, dear friends,

I encountered a problem processing my cube with the error message telling: processing measure_group_name (which only has a count as its only measure)failed as attribute keys can not be found? Why is that? I have no idea why is that? Does it mean I have to include all the keys of the fact table where the measure group from in the measure groups as measures? Otherwise the system failed to identify the distinct count of the system? Or whatever measures the measure group contains, it alwys have to include all the keys including the dimension keys of dimensions which the measure group is related to?

Thanks in advance for your help and advices and I am always looking forward to hearing from you shortly from you.

With best regards,

Yours sincerely,

This message means that a column used to join the measure group to a dimension contains a value not found in the dimension. This is usually caused by a referential integrity error - the FK does not existing in the PK of the lookup table. However, it can also be caused by the presence of a null in the FK as by default this null will be converted to zero or blank which probably does not exist as a key in the dimension. You can handle the situation of nulls in FK columns within the fact table by setting the NullProcessing option in the advanced tab of the measure group relationship dialog from the Dimension Usage tab of the cube editor.|||

Hi, Matt,

Thanks a lot. Yes, the problem is the matching of the PK and the FK between the tables.

However, the data source view logical key and the relationships between tables are really annoying then, as it is not able to check the integrity of the tables?

With best regards,

Yours sincerely,

|||

So it sounds like you would like to have an option on the Data Source View to validate logical keys and relationships. I'd recommend you file a feature request on http://connect.microsoft.com/SQLServer/Feedback. Such feature requests will be automatically added to our issue tracking system for consideration in future releases and those that originate from a customer such as yourself get extra consideration since we know it's a real world scenario. If you can describe the scenario it will also help as it will allow us to better identify which requests will help the most people and how to implement them so that they actually provide the help intended.

Thanks, Matt

|||

Hi, Matt,

Thanks a lot and this sounds really a good idea of it.

With best regards,

Yours sincerely,

Friday, March 23, 2012

Question On Stored Procedures

Wednesday, March 7, 2012

Question on Error message

Question on Error message

Monday, February 20, 2012

Question on attribute keys of measure group

SQLAgentMail

Blog Archive

About Me