Booleans?

Hello.
I just changed the databases of a website from Access to SQL Server.
Converting the bases went smothly, but now I recieve error message to my SQL-quereries:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'True'.

The query is: "Select pieces,date from orders where active = True AND company_id <> 19 AND authorize_wait = 0 ORDER BY send_date desc"

When I change int the query to: "active = 1" the page works like before (with Access)

I supose SQL Server is able to understand commands with True/False-quereries, so what is wrong here?
Thank you for your help
/CalleMSSQL does not define a "True" or "False" variable. You need to either use a one as you have in your example OR define a local variable

declare @.True bit
set @.True = 1
Select pieces,date
from orders
where active = @.True
AND company_id <> 19
AND authorize_wait = 0
ORDER BY send_date desc|||Thank you for your response!
/Calle

bogus VM error message with Upgrade Wizard

In All Programs/Microsoft SQL Server - Switch is something called SQL Server
Upgrade Wizard. I have no idea what that does, so I thought I'd start it up
and see what happens.
What happens is that I get an error message saying that my virtual memory is
too low, and should be set at the physical memory + 16 MB. My physical
memory is 512 MB and virtual memory is 767 MB, so the error message is
wrong.
Can someone explain what's going on? What does that thing do, anyway?It's designed to upgrade old 6.5 server configuration and databases to SQL
Server 2K. Are you trying to upgrade old 6.5 server configurations and
databases?
"Paul Pedersen" <no-reply@.swen.com> wrote in message
news:efe2nK%23UFHA.584@.TK2MSFTNGP15.phx.gbl...
> In All Programs/Microsoft SQL Server - Switch is something called SQL
> Server Upgrade Wizard. I have no idea what that does, so I thought I'd
> start it up and see what happens.
> What happens is that I get an error message saying that my virtual memory
> is too low, and should be set at the physical memory + 16 MB. My physical
> memory is 512 MB and virtual memory is 767 MB, so the error message is
> wrong.
> Can someone explain what's going on? What does that thing do, anyway?
>
>|||No, just exploring.
But why does it refuse to run?
"Michael C#" <xyz@.abcdef.com> wrote in message
news:Ofrfe.20738$o32.19288@.fe09.lga...
> It's designed to upgrade old 6.5 server configuration and databases to SQL
> Server 2K. Are you trying to upgrade old 6.5 server configurations and
> databases?
> "Paul Pedersen" <no-reply@.swen.com> wrote in message
> news:efe2nK%23UFHA.584@.TK2MSFTNGP15.phx.gbl...
>|||Maybe because it can't find any 6.5 databases/server configurations? You'd
have to look up the specific reason in the MSKB. Doesn't sound like it's
worth the effort - considering you don't have any 6.5 databases to upgrde
anyway...
"Paul Pedersen" <no-reply@.swen.com> wrote in message
news:uTlQzpEVFHA.2616@.TK2MSFTNGP14.phx.gbl...
> No, just exploring.
> But why does it refuse to run?
>
> "Michael C#" <xyz@.abcdef.com> wrote in message
> news:Ofrfe.20738$o32.19288@.fe09.lga...
>

Bogus ''out of disk space'' error message

When running SQLEVAL.EXE, I'm getting an error message when the installation wizard finished 'reading contents of the package' reading:

There is not enough space on C:\ to extract this package.

Having checked the requirements http://www.microsoft.com/sql/editions/developer/sysreqs.mspx, the free disk space on my c:\ is 45.42Gb.

Any ideas?

See: http://blogs.msdn.com/nikop/archive/2005/03/13/394797.aspx

Bogus 'out of disk space' error message

When running SQLEVAL.EXE, I'm getting an error message when the installation wizard finished 'reading contents of the package' reading:

There is not enough space on C:\ to extract this package.

Having checked the requirements http://www.microsoft.com/sql/editions/developer/sysreqs.mspx, the free disk space on my c:\ is 45.42Gb.

Any ideas?

See: http://blogs.msdn.com/nikop/archive/2005/03/13/394797.aspx

Body type not supported by Remote Host issue

I have recently setup a 2003 server with ISA firewall and an inbound SMTP re
lay to provide message filtering etc and SMTP command
scanning (such as it may be). This server relays to my internal SMTP server
which is an Exchange 5.5. Prior to this my Exchange
server received the email directly from the sending server with even less pr
otection by the ISA server. Since putting the 6.0
SMTP server in, I have been receiving (as admin) NDRs on in bound messages w
ith the error 'Body type not supported by Remote
Host'.
1) - I am not sure that these message really can't be handled by my 5.5. ser
ver. The reason I question this is that the NDR has
the original message as an attachment and I can open many of them in Outlook
that accesses the 5.5 server) and read them just
fine. Some of them are gibberish.
2) - I would really like the messages to continue on to the Exchange server
and let the chips fall as they may as they did before
I put the inbound relay was put in place.
3) - If I must have the NDR on the inbound messages, I would like to prevent
NDRs from being returned to the sender of these
messages. In fact, I think I could live without any NDRs returned to sender
from this relay. I have a 3 rd party spam filtering
service that discards messages to my domain for addresses without mailboxes
and my Exchange server should really provide what ever
other type of NDR that is required.
I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP,
but I am not sure that it applies because
1) - I really expect the procedure is different.
2) - The rejected messages don't indicate an 8bitmime type
3) - MS did not provide an equivalent article for Server 2003
Any information about the error message Body type not supported by Remote Ho
st or suggests would be most appreciated.
Thanks
---
Roy Chastain
KMSystems, Inc.Sorry about the mis-post. My mousing skills seem to be getting worse with a
ge.
On Wed, 23 Jun 2004 08:04:37 -0400, Roy Chastain <roy@.kmsys.com> wrote:

>I have recently setup a 2003 server with ISA firewall and an inbound SMTP r
elay to provide message filtering etc and SMTP command
>scanning (such as it may be). This server relays to my internal SMTP serve
r which is an Exchange 5.5. Prior to this my Exchange
>server received the email directly from the sending server with even less p
rotection by the ISA server. Since putting the 6.0
>SMTP server in, I have been receiving (as admin) NDRs on in bound messages
with the error 'Body type not supported by Remote
>Host'.
>1) - I am not sure that these message really can't be handled by my 5.5. se
rver. The reason I question this is that the NDR has
>the original message as an attachment and I can open many of them in Outloo
k that accesses the 5.5 server) and read them just
>fine. Some of them are gibberish.
>2) - I would really like the messages to continue on to the Exchange server
and let the chips fall as they may as they did before
>I put the inbound relay was put in place.
>3) - If I must have the NDR on the inbound messages, I would like to preven
t NDRs from being returned to the sender of these
>messages. In fact, I think I could live without any NDRs returned to sende
r from this relay. I have a 3 rd party spam filtering
>service that discards messages to my domain for addresses without mailboxes
and my Exchange server should really provide what ever
>other type of NDR that is required.
>I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP
, but I am not sure that it applies because
>1) - I really expect the procedure is different.
>2) - The rejected messages don't indicate an 8bitmime type
>3) - MS did not provide an equivalent article for Server 2003
>Any information about the error message Body type not supported by Remote H
ost or suggests would be most appreciated.
>Thanks
>---
>Roy Chastain
>KMSystems, Inc.
---
Roy Chastain
KMSystems, Inc.

Body type not supported by Remote Host issue

I have recently setup a 2003 server with ISA firewall and an inbound SMTP relay to provide message filtering etc and SMTP command
scanning (such as it may be). This server relays to my internal SMTP server which is an Exchange 5.5. Prior to this my Exchange
server received the email directly from the sending server with even less protection by the ISA server. Since putting the 6.0
SMTP server in, I have been receiving (as admin) NDRs on in bound messages with the error 'Body type not supported by Remote
Host'.
1) - I am not sure that these message really can't be handled by my 5.5. server. The reason I question this is that the NDR has
the original message as an attachment and I can open many of them in Outlook that accesses the 5.5 server) and read them just
fine. Some of them are gibberish.
2) - I would really like the messages to continue on to the Exchange server and let the chips fall as they may as they did before
I put the inbound relay was put in place.
3) - If I must have the NDR on the inbound messages, I would like to prevent NDRs from being returned to the sender of these
messages. In fact, I think I could live without any NDRs returned to sender from this relay. I have a 3 rd party spam filtering
service that discards messages to my domain for addresses without mailboxes and my Exchange server should really provide what ever
other type of NDR that is required.
I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP, but I am not sure that it applies because
1) - I really expect the procedure is different.
2) - The rejected messages don't indicate an 8bitmime type
3) - MS did not provide an equivalent article for Server 2003
Any information about the error message Body type not supported by Remote Host or suggests would be most appreciated.
Thanks
Roy Chastain
KMSystems, Inc.
Sorry about the mis-post. My mousing skills seem to be getting worse with age.
On Wed, 23 Jun 2004 08:04:37 -0400, Roy Chastain <roy@.kmsys.com> wrote:

>I have recently setup a 2003 server with ISA firewall and an inbound SMTP relay to provide message filtering etc and SMTP command
>scanning (such as it may be). This server relays to my internal SMTP server which is an Exchange 5.5. Prior to this my Exchange
>server received the email directly from the sending server with even less protection by the ISA server. Since putting the 6.0
>SMTP server in, I have been receiving (as admin) NDRs on in bound messages with the error 'Body type not supported by Remote
>Host'.
>1) - I am not sure that these message really can't be handled by my 5.5. server. The reason I question this is that the NDR has
>the original message as an attachment and I can open many of them in Outlook that accesses the 5.5 server) and read them just
>fine. Some of them are gibberish.
>2) - I would really like the messages to continue on to the Exchange server and let the chips fall as they may as they did before
>I put the inbound relay was put in place.
>3) - If I must have the NDR on the inbound messages, I would like to prevent NDRs from being returned to the sender of these
>messages. In fact, I think I could live without any NDRs returned to sender from this relay. I have a 3 rd party spam filtering
>service that discards messages to my domain for addresses without mailboxes and my Exchange server should really provide what ever
>other type of NDR that is required.
>I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP, but I am not sure that it applies because
>1) - I really expect the procedure is different.
>2) - The rejected messages don't indicate an 8bitmime type
>3) - MS did not provide an equivalent article for Server 2003
>Any information about the error message Body type not supported by Remote Host or suggests would be most appreciated.
>Thanks
>---
>Roy Chastain
>KMSystems, Inc.
Roy Chastain
KMSystems, Inc.

Bluescreen PFN_LIST_CORRUPT

My SQL2000 server periodically bluescreen with
PFN_LIST_CORRUPT 0x0000004E message,
searching for KB in Microsoft doesn't yield helpful
results. Can you please help me on what happen
to my server?
IanI did a quick search and came up with:
Microsoft Knowledge Base Article - 291806:
How to Troubleshoot a "STOP 0x0000004E PFN_LIST_CORRUPT" Error Message
http://support.microsoft.com/?kbid=291806
HTH
Regards,
Greg Linwood
SQL Server MVP
"@._@. ¥ì¤H ^_^" <ianho@.NOSPAMwellent.com> wrote in message
news:O$#i56UjDHA.684@.TK2MSFTNGP09.phx.gbl...
> My SQL2000 server periodically bluescreen with
> PFN_LIST_CORRUPT 0x0000004E message,
> searching for KB in Microsoft doesn't yield helpful
> results. Can you please help me on what happen
> to my server?
> Ian
>

blog select with comment count

The following sql works great when the field for my main blog message is type nvarchar but doesn't work for text which I need to convert to.

select
a.id, b.textField
count(b.a_id) as myCount
from a left join b on a.id = b.a_id
group by a.id, b.textField

What other methods could i use to get "myCount" within one sql statement?

Thanks in advance, JeffHere is more information:

using sql server 2000 (from asp.net) the following sql works great when the "textForm" field is of type nvarchar but doesn't work for the text type.

I don't believe nvarchar will work for my needs since it is limited to 8000 (4000 due to double storage). I believe I will need to use the text type.

select bm.message_id,
bm.title,
bm.display_date,
bm.message,
count(bc.comment_id) as commentCount
from blog_messages as bm LEFT JOIN blog_comments as bc
on bm.message_id = bc.message_id
where bm.active_flag = 1
group by bm.message_id, bm.title, bm.display_date, bm.message
order by display_date DESC

The purpose of the select statement is to display a list of blog entries that includes the number of comments on each entry. An example of this in cold fusion is found at
http://www.camdenfamily.com/morpheus/blog/

With my limited knowledge of the asp.net repeater control, I'm not sure how to integrate 2 select statements (1st for blog content, 2nd for comment count). It seems the fastest way to get all of the information I want is to use a stored procedure using either a temp table or a cursor to compile all of the data together. However this method may forcee me to select the count from table b for each record of table a which could be time consuming.

Is there any way to achieve this goal with one select using the union statement or another type of join?

Although this might be a better sql question, I am also wondering about alternative asp.net solutions including repeaters with 2 or more select statements or using an array or list.|||How about something like:

select a.id,
b.textField,
myCount = (select count(*) from b where a_id = a.id)
from a

You might need to include a COALESCE function around the correlated subquery to check for NULL and send back a zero.|||it worked! thanks!

select bm.message_id,
bm.title,
bm.display_date,
bm.message,
commentCount = (select count('x')
from blog_comments as bc
where bc.message_id = bm.message_id)
from blog_messages as bm
where bm.active_flag = 1
order by bm.display_date DESC

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin
|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...
|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin
|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...
|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Bizarre maintenance plan failure (db backup)

I am getting a failure on the db backup job of one of my maintenance
plans. It is coming back with the generic error message of,

"sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step
failed."

I then checked the Database Maintenance Plan History page, but this
shows all the steps having run successfully. If I check the drives for
the actual backup files, they exist and look healthy too!

There is plenty of space on the drives, so it is not that.

I've checked the NT logs and all they say is,

"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan for All User Databases''
(0xC06E15E2A9E1414087BE19541D167861) - Status: Failed - Invoked on:
2005-06-29 21:00:04 - Message: The job failed. The Job was invoked by
Schedule 35 (Schedule 1). The last step to run was step 1 (Step 1). "

Which doesn't give me any clues.

Since the backups have actually run to success, I am going to take off
the option on the maintenance plan to "Verfiy the integrity of the
backup upon completion". Maybe it is this that is causing problems,
rather than the backup?

Anyone had anything similar?(nielsonj1976@.yahoo.co.uk) writes:
> I am getting a failure on the db backup job of one of my maintenance
> plans. It is coming back with the generic error message of,
> "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step
> failed."
> I then checked the Database Maintenance Plan History page, but this
> shows all the steps having run successfully. If I check the drives for
> the actual backup files, they exist and look healthy too!
> There is plenty of space on the drives, so it is not that.
> I've checked the NT logs and all they say is,
> "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan for All User Databases''
> (0xC06E15E2A9E1414087BE19541D167861) - Status: Failed - Invoked on:
> 2005-06-29 21:00:04 - Message: The job failed. The Job was invoked by
> Schedule 35 (Schedule 1). The last step to run was step 1 (Step 1). "
> Which doesn't give me any clues.

So did you look at the Job History? Find the backup job, right-click
and select Show History. In this dialog check "Show step details". The
step details usually have some more meat for information.

> Since the backups have actually run to success, I am going to take off
> the option on the maintenance plan to "Verfiy the integrity of the
> backup upon completion". Maybe it is this that is causing problems,
> rather than the backup?

Ehum, if the problem is that the backups don't verify, that I would
not like to know that and not sweep it under the carpet.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||> So did you look at the Job History? Find the backup job, right-click
> and select Show History. In this dialog check "Show step details". The
> step details usually have some more meat for information.

This doesn't really give me any clues either. If I click show step
details, I get it displaying 2 steps,

Step 1: Executed as user: OMNIA\SVC_SQL_Exec. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.

Step 0: (Job Outcome) The job failed. The Job was invoked by Schedule
35 (Schedule 1). The last step to run was step 1 (Step 1).

> > Since the backups have actually run to success, I am going to take off
> > the option on the maintenance plan to "Verfiy the integrity of the
> > backup upon completion". Maybe it is this that is causing problems,
> > rather than the backup?

> Ehum, if the problem is that the backups don't verify, that I would
> not like to know that and not sweep it under the carpet.

Having checked this morning the backup status is still showing Failed
even with the verify option off. The only reason I thought it *could*
be this is that the backups are fairly large (25gb+) so SQL server
could be having problems verifying with the disk space available?|||nielsonj1976@.yahoo.co.uk (nielsonj1976@.yahoo.co.uk) writes:
> This doesn't really give me any clues either. If I click show step
> details, I get it displaying 2 steps,
> Step 1: Executed as user: OMNIA\SVC_SQL_Exec. sqlmaint.exe failed.
> [SQLSTATE 42000] (Error 22029). The step failed.
> Step 0: (Job Outcome) The job failed. The Job was invoked by Schedule
> 35 (Schedule 1). The last step to run was step 1 (Step 1).

I rarely set into maintenance job, so I don't really know where sqlmaint
might write its errors. But looking at the properties of a plan that I've
actually set up, I see that there is a Reporting tab. Have you checked
what's yours, and if that leads to a useful file?

>> > Since the backups have actually run to success, I am going to take off
>> > the option on the maintenance plan to "Verfiy the integrity of the
>> > backup upon completion". Maybe it is this that is causing problems,
>> > rather than the backup?
>> Ehum, if the problem is that the backups don't verify, that I would
>> not like to know that and not sweep it under the carpet.
> Having checked this morning the backup status is still showing Failed
> even with the verify option off. The only reason I thought it *could*
> be this is that the backups are fairly large (25gb+) so SQL server
> could be having problems verifying with the disk space available?

I will have to retract what I said above. I recalled a discussion among
my MVP colleagues who are into server administration. The consensus was
that verification of backups as offered by RESTORE VERIFYOLNLY is useless.
The only way to really verify a backup is to restore it. And run DBCC checks
on the restored copy.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Do your maint plans cover more than 1 database? If so check the recovery modes of each - this error seems to pop up if there are mixed modes within 1 plan.

Bizare xp_sendmail error

Use master
--This works
exec xp_sendmail 'scott_riehl@.b-f.com', @.message='test message'
--This does not work
exec xp_sendmail 'scott_riehl@.b-f.com', @.query='select [name] sysusers'
results are
"ODBC error 4604 (42000) There is no such user or group 'sa4'."
and the 'sa4' changes from 'sa4', to 'sa8', to 'sa0', 'sa' + some random
number.
I've never seen anything like this before, any ideas?
TIA,
ScottDid you forget to include "from" in your query statement?
"Scott Riehl" <scott_riehl@.westmaininteractive.com> wrote in message
news:un5QtxbEEHA.688@.tk2msftngp13.phx.gbl...
> Use master
> --This works
> exec xp_sendmail 'scott_riehl@.b-f.com', @.message='test message'
> --This does not work
> exec xp_sendmail 'scott_riehl@.b-f.com', @.query='select [name] sysusers
'
>
> results are
> "ODBC error 4604 (42000) There is no such user or group 'sa4'."
> and the 'sa4' changes from 'sa4', to 'sa8', to 'sa0', 'sa' + some random
> number.
> I've never seen anything like this before, any ideas?
> TIA,
> Scott
>
>
>
>|||Scott,
See if the resolution found here helps:
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=25318
By the way, the query you are submitting is invalid or you have a typo
here. It isn't likely to work with
select [name] sysusers
so make sure whatever query you submit runs successfully in Query Analyzer.
Steve Kass
Drew University
Scott Riehl wrote:

>Use master
>--This works
>exec xp_sendmail 'scott_riehl@.b-f.com', @.message='test message'
>--This does not work
>exec xp_sendmail 'scott_riehl@.b-f.com', @.query='select [name] sysusers'
>
>results are
>"ODBC error 4604 (42000) There is no such user or group 'sa4'."
>and the 'sa4' changes from 'sa4', to 'sa8', to 'sa0', 'sa' + some random
>number.
>I've never seen anything like this before, any ideas?
>TIA,
>Scott
>
>
>
>
>|||Sorry, that was a typo, the 'From' clause is present.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%236hl67bEEHA.624@.TK2MSFTNGP10.phx.gbl...
> Did you forget to include "from" in your query statement?
> "Scott Riehl" <scott_riehl@.westmaininteractive.com> wrote in message
> news:un5QtxbEEHA.688@.tk2msftngp13.phx.gbl...
>|||Thanks, that is a typo, sorry.
The link is appropriate, I'll try their recommnedations.
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:unoqbJcEEHA.3088@.tk2msftngp13.phx.gbl...
> Scott,
> See if the resolution found here helps:
> http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=25318
> By the way, the query you are submitting is invalid or you have a typo
> here. It isn't likely to work with
> select [name] sysusers
> so make sure whatever query you submit runs successfully in Query
Analyzer.
> Steve Kass
> Drew University
> Scott Riehl wrote:
>
>|||I should have known......a quick reboot fixed everything!
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:unoqbJcEEHA.3088@.tk2msftngp13.phx.gbl...
> Scott,
> See if the resolution found here helps:
> http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=25318
> By the way, the query you are submitting is invalid or you have a typo
> here. It isn't likely to work with
> select [name] sysusers
> so make sure whatever query you submit runs successfully in Query
Analyzer.
> Steve Kass
> Drew University
> Scott Riehl wrote:
>
>

Bitwise operator question

This is a multi-part message in MIME format.
--=_NextPart_000_002D_01C4F892.984E52C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
What is the biggest values that SQL Server supports for bitwise AND and = OR.
The BOL says any of the integer datatypes. But in the examples, it = only references int, smallint and tinyint (and binary conversion stuff).
Does SQL support bigint values as well? eg. 64-bit comparisons?
I've run a couple of sample scripts to test, but I would like some = confirmation from others.
Thanks
Rick Sawtell
MCT, MCSD, MCDBA
--=_NextPart_000_002D_01C4F892.984E52C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
What is the biggest values that SQL = Server supports for bitwise AND and OR.

The BOL says any of the integer datatypes. But in the examples, it only references = int, smallint and tinyint (and binary conversion stuff).

Does SQL support bigint values as = well? eg. 64-bit comparisons?


I've run a couple of sample scripts to = test, but I would like some confirmation from others.


Thanks


Rick Sawtell
MCT, MCSD, MCDBA


--=_NextPart_000_002D_01C4F892.984E52C0--This is a multi-part message in MIME format.
--=_NextPart_000_00C3_01C4F89B.FAB67F60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Sure:
SELECT CONVERT(BIGINT, 35184372088833) & 1
Note: You do need to explicitly convert it to BIGINT or else SQL Server =will try to implicitly convert it to NUMERIC, which does not support =bitwise comparisons.
-- Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Rick Sawtell" <quickening@.msn.com> wrote in message =news:eBlLVTM%23EHA.1396@.tk2msftngp13.phx.gbl...
What is the biggest values that SQL Server supports for bitwise AND =and OR.
The BOL says any of the integer datatypes. But in the examples, it =only references int, smallint and tinyint (and binary conversion stuff).
Does SQL support bigint values as well? eg. 64-bit comparisons?
I've run a couple of sample scripts to test, but I would like some =confirmation from others.
Thanks
Rick Sawtell
MCT, MCSD, MCDBA
--=_NextPart_000_00C3_01C4F89B.FAB67F60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Sure:
SELECT CONVERT(BIGINT, 35184372088833) =& 1
Note: You do need to explicitly =convert it to BIGINT or else SQL Server will try to implicitly convert it to NUMERIC, =which does not support bitwise comparisons.
-- Adam MachanicSQL Server MVPhttp://www.sqljunkies.com/weblog/amachanic">http://www.sqljunkies=.com/weblog/amachanic--
"Rick Sawtell" wrote in =message news:eBlLVTM%23EHA.=1396@.tk2msftngp13.phx.gbl...
What is the biggest values that SQL =Server supports for bitwise AND and OR.

The BOL says any of the integer datatypes. But in the examples, it only references =int, smallint and tinyint (and binary conversion stuff).

Does SQL support bigint values as well? eg. 64-bit comparisons?


I've run a couple of sample scripts =to test, but I would like some confirmation from others.


Thanks


Rick Sawtell
MCT, MCSD, MCDBA

---

--=_NextPart_000_00C3_01C4F89B.FAB67F60--|||Bitwise operaters are supported with BIGINT. Bitmaps are a lousy way to hold
data in a strongly-typed database though, so you shouldn't need bitwise
operators very often.
--
David Portas
SQL Server MVP
--|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:F3772EF4-A53D-4740-9835-642A6BBF767F@.microsoft.com...
> Bitwise operaters are supported with BIGINT. Bitmaps are a lousy way to
> hold
> data in a strongly-typed database though, so you shouldn't need bitwise
> operators very often.
> --
> David Portas
> SQL Server MVP
> --
>
How would you suggest tracking 16000 different options.
Rick|||"Rick Sawtell" <quickening@.msn.com> wrote in message
news:%23svAjAO%23EHA.1524@.TK2MSFTNGP09.phx.gbl...
> How would you suggest tracking 16000 different options.
Certainly not in a 16000-bit bitmask... Assuming those options were for
users, I would do something like this:
CREATE TABLE Options
(
OptionID INT PRIMARY KEY,
OptionName VARCHAR(50),
...
)
CREATE TABLE UserOptions
(
OptionID INT,
UserID INT,
CONSTRAINT FK_UserOptions_Options FOREIGN KEY (OptionID) REFERENCES
Options (OptionID),
CONSTRAINT FK_UserOptions_Users FOREIGN KEY (UserID) REFERENCES
Users (UserID),
CONSTRAINT PK_UserOptions PRIMARY KEY (OptionID, UserID)
)
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||In a table, with atomic columns representing real attributes. How else? :-)
If you have that many elements to track then I would say bitmaps are
definitely no-go. Bitmaps don't benefit from optimization on individual
attributes and every query will force a table-scan with the bitwise
operations performed on every row.
--
David Portas
SQL Server MVP
--