Hi,
Someone from our headquarters wants a report of how many customers per
"Metropolitation Statistical Area" (MSA) we have in our database. See
http://www.census.gov/population/estimates/metro_general/List4.txt for
the complete list of MSA's.
Problem is, each MSA only lists one, two or three cites per area. For
example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
in that area, such as Roxbury, etc. (However, these four cities all
fall into zip codes either starting with 021 or 022).
So, doing a search by MSA city is impossible. It would miss a lot of
customers whose cities aren't listed in a given MSA, for example,
Roxbury.
Alternatively, I could use the first few digits of the zip codes. For
example, Boston zip codes start with 021 or 022. That would capture all
other cities within that area, I am thinking, or close enough.
However, the MSA website does not have any zip codes listed.
And futhermore, I am the one who has to find these zip codes... seems
like it's going to be very aggravating, long day having to look up
these zip codes.
Please, please please someone tell me there is a listing of zip codes
per MSA... or has ANYONE had to do a similar project - and can give me
some advice?
THANKS
A quick GOOGLE with the words MSA ZIP turned up commercial databases
of zip data that includes the MSA code. The price for the one I
looked at was something like $80, and it is a download so you can
don't have to wait. I know nothing other than that I found it just
now, but $80 seems pretty reasonable. The link to the page I found,
to which I have no connection, is
http://www.zip-codes.com/zip-code-database.asp
Roy Harvey
Beacon Falls, CT
On 13 Dec 2006 11:53:10 -0800, tootsuite@.gmail.com wrote:
>Hi,
>Someone from our headquarters wants a report of how many customers per
>"Metropolitation Statistical Area" (MSA) we have in our database. See
>http://www.census.gov/population/estimates/metro_general/List4.txt for
>the complete list of MSA's.
>Problem is, each MSA only lists one, two or three cites per area. For
>example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
>in that area, such as Roxbury, etc. (However, these four cities all
>fall into zip codes either starting with 021 or 022).
>So, doing a search by MSA city is impossible. It would miss a lot of
>customers whose cities aren't listed in a given MSA, for example,
>Roxbury.
>Alternatively, I could use the first few digits of the zip codes. For
>example, Boston zip codes start with 021 or 022. That would capture all
>other cities within that area, I am thinking, or close enough.
>However, the MSA website does not have any zip codes listed.
>And futhermore, I am the one who has to find these zip codes... seems
>like it's going to be very aggravating, long day having to look up
>these zip codes.
>Please, please please someone tell me there is a listing of zip codes
>per MSA... or has ANYONE had to do a similar project - and can give me
>some advice?
>THANKS
|||> And futhermore, I am the one who has to find these zip codes...
No you don't, as long as you have the ability to spend money on software
and/or a database that does it for you.
We're using one of MaxMind's databases for exactly this purpose: mapping
DMAs to zip codes and then reporting aggregates under each DMA. They have
free versions of the database too (just not as current / complete) and I
think they support web service calls for some of it too (but our volume
couldn't be supported by that).
It sounds like you need MSA and not DMA, though I confess I am not clear on
the differences. So, assuming DMA is not appropriate, some other
alternatives, some of which are free:
http://www.zipdatafiles.com/data/
http://www.zipinfo.com/products/products.htm
http://www.zipcodeworld.com/zipcodepremium.htm
http://www.freedownloadmanager.org/downloads/latitude_longitude_software/
http://www.softjamboree.com/article/zip-code-database.html
http://www.zip-codes.com/zip-code-database.asp
One of these will hopefully meet your requirements and budget.
A
|||You could also determine approximate ZIP code to MSA mappings using the U.S.
Census Bureau's free Tiger database online. Although the ZIP codes in the
Tiger database are actually "ZIP Code Tabulation Areas" and not true ZIP
codes. This inaccuracy and the amount of work involved in downloading and
cleaning up the data would make me recommend buying a commercial product.
Showing posts with label customers. Show all posts
Showing posts with label customers. Show all posts
Friday, February 24, 2012
HELP - Absurd project on a deadline!
Hi,
Someone from our headquarters wants a report of how many customers per
"Metropolitation Statistical Area" (MSA) we have in our database. See
http://www.census.gov/population/estimates/metro_general/List4.txt for
the complete list of MSA's.
Problem is, each MSA only lists one, two or three cites per area. For
example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
in that area, such as Roxbury, etc. (However, these four cities all
fall into zip codes either starting with 021 or 022).
So, doing a search by MSA city is impossible. It would miss a lot of
customers whose cities aren't listed in a given MSA, for example,
Roxbury.
Alternatively, I could use the first few digits of the zip codes. For
example, Boston zip codes start with 021 or 022. That would capture all
other cities within that area, I am thinking, or close enough.
However, the MSA website does not have any zip codes listed.
And futhermore, I am the one who has to find these zip codes... seems
like it's going to be very aggravating, long day having to look up
these zip codes.
Please, please please someone tell me there is a listing of zip codes
per MSA... or has ANYONE had to do a similar project - and can give me
some advice?
THANKSA quick GOOGLE with the words MSA ZIP turned up commercial databases
of zip data that includes the MSA code. The price for the one I
looked at was something like $80, and it is a download so you can
don't have to wait. I know nothing other than that I found it just
now, but $80 seems pretty reasonable. The link to the page I found,
to which I have no connection, is
http://www.zip-codes.com/zip-code-database.asp
Roy Harvey
Beacon Falls, CT
On 13 Dec 2006 11:53:10 -0800, tootsuite@.gmail.com wrote:
>Hi,
>Someone from our headquarters wants a report of how many customers per
>"Metropolitation Statistical Area" (MSA) we have in our database. See
>http://www.census.gov/population/estimates/metro_general/List4.txt for
>the complete list of MSA's.
>Problem is, each MSA only lists one, two or three cites per area. For
>example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
>in that area, such as Roxbury, etc. (However, these four cities all
>fall into zip codes either starting with 021 or 022).
>So, doing a search by MSA city is impossible. It would miss a lot of
>customers whose cities aren't listed in a given MSA, for example,
>Roxbury.
>Alternatively, I could use the first few digits of the zip codes. For
>example, Boston zip codes start with 021 or 022. That would capture all
>other cities within that area, I am thinking, or close enough.
>However, the MSA website does not have any zip codes listed.
>And futhermore, I am the one who has to find these zip codes... seems
>like it's going to be very aggravating, long day having to look up
>these zip codes.
>Please, please please someone tell me there is a listing of zip codes
>per MSA... or has ANYONE had to do a similar project - and can give me
>some advice?
>THANKS|||> And futhermore, I am the one who has to find these zip codes...
No you don't, as long as you have the ability to spend money on software
and/or a database that does it for you.
We're using one of MaxMind's databases for exactly this purpose: mapping
DMAs to zip codes and then reporting aggregates under each DMA. They have
free versions of the database too (just not as current / complete) and I
think they support web service calls for some of it too (but our volume
couldn't be supported by that).
It sounds like you need MSA and not DMA, though I confess I am not clear on
the differences. So, assuming DMA is not appropriate, some other
alternatives, some of which are free:
http://www.zipdatafiles.com/data/
http://www.zipinfo.com/products/products.htm
http://www.zipcodeworld.com/zipcodepremium.htm
http://www.freedownloadmanager.org/downloads/latitude_longitude_software/
http://www.softjamboree.com/article/zip-code-database.html
http://www.zip-codes.com/zip-code-database.asp
One of these will hopefully meet your requirements and budget.
A|||You could also determine approximate ZIP code to MSA mappings using the U.S.
Census Bureau's free Tiger database online. Although the ZIP codes in the
Tiger database are actually "ZIP Code Tabulation Areas" and not true ZIP
codes. This inaccuracy and the amount of work involved in downloading and
cleaning up the data would make me recommend buying a commercial product.
Someone from our headquarters wants a report of how many customers per
"Metropolitation Statistical Area" (MSA) we have in our database. See
http://www.census.gov/population/estimates/metro_general/List4.txt for
the complete list of MSA's.
Problem is, each MSA only lists one, two or three cites per area. For
example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
in that area, such as Roxbury, etc. (However, these four cities all
fall into zip codes either starting with 021 or 022).
So, doing a search by MSA city is impossible. It would miss a lot of
customers whose cities aren't listed in a given MSA, for example,
Roxbury.
Alternatively, I could use the first few digits of the zip codes. For
example, Boston zip codes start with 021 or 022. That would capture all
other cities within that area, I am thinking, or close enough.
However, the MSA website does not have any zip codes listed.
And futhermore, I am the one who has to find these zip codes... seems
like it's going to be very aggravating, long day having to look up
these zip codes.
Please, please please someone tell me there is a listing of zip codes
per MSA... or has ANYONE had to do a similar project - and can give me
some advice?
THANKSA quick GOOGLE with the words MSA ZIP turned up commercial databases
of zip data that includes the MSA code. The price for the one I
looked at was something like $80, and it is a download so you can
don't have to wait. I know nothing other than that I found it just
now, but $80 seems pretty reasonable. The link to the page I found,
to which I have no connection, is
http://www.zip-codes.com/zip-code-database.asp
Roy Harvey
Beacon Falls, CT
On 13 Dec 2006 11:53:10 -0800, tootsuite@.gmail.com wrote:
>Hi,
>Someone from our headquarters wants a report of how many customers per
>"Metropolitation Statistical Area" (MSA) we have in our database. See
>http://www.census.gov/population/estimates/metro_general/List4.txt for
>the complete list of MSA's.
>Problem is, each MSA only lists one, two or three cites per area. For
>example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
>in that area, such as Roxbury, etc. (However, these four cities all
>fall into zip codes either starting with 021 or 022).
>So, doing a search by MSA city is impossible. It would miss a lot of
>customers whose cities aren't listed in a given MSA, for example,
>Roxbury.
>Alternatively, I could use the first few digits of the zip codes. For
>example, Boston zip codes start with 021 or 022. That would capture all
>other cities within that area, I am thinking, or close enough.
>However, the MSA website does not have any zip codes listed.
>And futhermore, I am the one who has to find these zip codes... seems
>like it's going to be very aggravating, long day having to look up
>these zip codes.
>Please, please please someone tell me there is a listing of zip codes
>per MSA... or has ANYONE had to do a similar project - and can give me
>some advice?
>THANKS|||> And futhermore, I am the one who has to find these zip codes...
No you don't, as long as you have the ability to spend money on software
and/or a database that does it for you.
We're using one of MaxMind's databases for exactly this purpose: mapping
DMAs to zip codes and then reporting aggregates under each DMA. They have
free versions of the database too (just not as current / complete) and I
think they support web service calls for some of it too (but our volume
couldn't be supported by that).
It sounds like you need MSA and not DMA, though I confess I am not clear on
the differences. So, assuming DMA is not appropriate, some other
alternatives, some of which are free:
http://www.zipdatafiles.com/data/
http://www.zipinfo.com/products/products.htm
http://www.zipcodeworld.com/zipcodepremium.htm
http://www.freedownloadmanager.org/downloads/latitude_longitude_software/
http://www.softjamboree.com/article/zip-code-database.html
http://www.zip-codes.com/zip-code-database.asp
One of these will hopefully meet your requirements and budget.
A|||You could also determine approximate ZIP code to MSA mappings using the U.S.
Census Bureau's free Tiger database online. Although the ZIP codes in the
Tiger database are actually "ZIP Code Tabulation Areas" and not true ZIP
codes. This inaccuracy and the amount of work involved in downloading and
cleaning up the data would make me recommend buying a commercial product.
HELP - Absurd project on a deadline!
Hi,
Someone from our headquarters wants a report of how many customers per
"Metropolitation Statistical Area" (MSA) we have in our database. See
http://www.census.gov/population/es...neral/List4.txt for
the complete list of MSA's.
Problem is, each MSA only lists one, two or three cites per area. For
example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
in that area, such as Roxbury, etc. (However, these four cities all
fall into zip codes either starting with 021 or 022).
So, doing a search by MSA city is impossible. It would miss a lot of
customers whose cities aren't listed in a given MSA, for example,
Roxbury.
Alternatively, I could use the first few digits of the zip codes. For
example, Boston zip codes start with 021 or 022. That would capture all
other cities within that area, I am thinking, or close enough.
However, the MSA website does not have any zip codes listed.
And futhermore, I am the one who has to find these zip codes... seems
like it's going to be very aggravating, long day having to look up
these zip codes.
Please, please please someone tell me there is a listing of zip codes
per MSA... or has ANYONE had to do a similar project - and can give me
some advice?
THANKSA quick GOOGLE with the words MSA ZIP turned up commercial databases
of zip data that includes the MSA code. The price for the one I
looked at was something like $80, and it is a download so you can
don't have to wait. I know nothing other than that I found it just
now, but $80 seems pretty reasonable. The link to the page I found,
to which I have no connection, is
http://www.zip-codes.com/zip-code-database.asp
Roy Harvey
Beacon Falls, CT
On 13 Dec 2006 11:53:10 -0800, tootsuite@.gmail.com wrote:
>Hi,
>Someone from our headquarters wants a report of how many customers per
>"Metropolitation Statistical Area" (MSA) we have in our database. See
>http://www.census.gov/population/es...neral/List4.txt for
>the complete list of MSA's.
>Problem is, each MSA only lists one, two or three cites per area. For
>example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
>in that area, such as Roxbury, etc. (However, these four cities all
>fall into zip codes either starting with 021 or 022).
>So, doing a search by MSA city is impossible. It would miss a lot of
>customers whose cities aren't listed in a given MSA, for example,
>Roxbury.
>Alternatively, I could use the first few digits of the zip codes. For
>example, Boston zip codes start with 021 or 022. That would capture all
>other cities within that area, I am thinking, or close enough.
>However, the MSA website does not have any zip codes listed.
>And futhermore, I am the one who has to find these zip codes... seems
>like it's going to be very aggravating, long day having to look up
>these zip codes.
>Please, please please someone tell me there is a listing of zip codes
>per MSA... or has ANYONE had to do a similar project - and can give me
>some advice?
>THANKS|||> And futhermore, I am the one who has to find these zip codes...
No you don't, as long as you have the ability to spend money on software
and/or a database that does it for you.
We're using one of MaxMind's databases for exactly this purpose: mapping
DMAs to zip codes and then reporting aggregates under each DMA. They have
free versions of the database too (just not as current / complete) and I
think they support web service calls for some of it too (but our volume
couldn't be supported by that).
It sounds like you need MSA and not DMA, though I confess I am not clear on
the differences. So, assuming DMA is not appropriate, some other
alternatives, some of which are free:
http://www.zipdatafiles.com/data/
http://www.zipinfo.com/products/products.htm
http://www.zipcodeworld.com/zipcodepremium.htm
http://www.freedownloadmanager.org/...itude_software/
http://www.softjamboree.com/article...e-database.html
http://www.zip-codes.com/zip-code-database.asp
One of these will hopefully meet your requirements and budget.
A|||You could also determine approximate ZIP code to MSA mappings using the U.S.
Census Bureau's free Tiger database online. Although the ZIP codes in the
Tiger database are actually "ZIP Code Tabulation Areas" and not true ZIP
codes. This inaccuracy and the amount of work involved in downloading and
cleaning up the data would make me recommend buying a commercial product.
Someone from our headquarters wants a report of how many customers per
"Metropolitation Statistical Area" (MSA) we have in our database. See
http://www.census.gov/population/es...neral/List4.txt for
the complete list of MSA's.
Problem is, each MSA only lists one, two or three cites per area. For
example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
in that area, such as Roxbury, etc. (However, these four cities all
fall into zip codes either starting with 021 or 022).
So, doing a search by MSA city is impossible. It would miss a lot of
customers whose cities aren't listed in a given MSA, for example,
Roxbury.
Alternatively, I could use the first few digits of the zip codes. For
example, Boston zip codes start with 021 or 022. That would capture all
other cities within that area, I am thinking, or close enough.
However, the MSA website does not have any zip codes listed.
And futhermore, I am the one who has to find these zip codes... seems
like it's going to be very aggravating, long day having to look up
these zip codes.
Please, please please someone tell me there is a listing of zip codes
per MSA... or has ANYONE had to do a similar project - and can give me
some advice?
THANKSA quick GOOGLE with the words MSA ZIP turned up commercial databases
of zip data that includes the MSA code. The price for the one I
looked at was something like $80, and it is a download so you can
don't have to wait. I know nothing other than that I found it just
now, but $80 seems pretty reasonable. The link to the page I found,
to which I have no connection, is
http://www.zip-codes.com/zip-code-database.asp
Roy Harvey
Beacon Falls, CT
On 13 Dec 2006 11:53:10 -0800, tootsuite@.gmail.com wrote:
>Hi,
>Someone from our headquarters wants a report of how many customers per
>"Metropolitation Statistical Area" (MSA) we have in our database. See
>http://www.census.gov/population/es...neral/List4.txt for
>the complete list of MSA's.
>Problem is, each MSA only lists one, two or three cites per area. For
>example, "Boston-Cambridge-Quincy". Which leaves out EVERY other city
>in that area, such as Roxbury, etc. (However, these four cities all
>fall into zip codes either starting with 021 or 022).
>So, doing a search by MSA city is impossible. It would miss a lot of
>customers whose cities aren't listed in a given MSA, for example,
>Roxbury.
>Alternatively, I could use the first few digits of the zip codes. For
>example, Boston zip codes start with 021 or 022. That would capture all
>other cities within that area, I am thinking, or close enough.
>However, the MSA website does not have any zip codes listed.
>And futhermore, I am the one who has to find these zip codes... seems
>like it's going to be very aggravating, long day having to look up
>these zip codes.
>Please, please please someone tell me there is a listing of zip codes
>per MSA... or has ANYONE had to do a similar project - and can give me
>some advice?
>THANKS|||> And futhermore, I am the one who has to find these zip codes...
No you don't, as long as you have the ability to spend money on software
and/or a database that does it for you.
We're using one of MaxMind's databases for exactly this purpose: mapping
DMAs to zip codes and then reporting aggregates under each DMA. They have
free versions of the database too (just not as current / complete) and I
think they support web service calls for some of it too (but our volume
couldn't be supported by that).
It sounds like you need MSA and not DMA, though I confess I am not clear on
the differences. So, assuming DMA is not appropriate, some other
alternatives, some of which are free:
http://www.zipdatafiles.com/data/
http://www.zipinfo.com/products/products.htm
http://www.zipcodeworld.com/zipcodepremium.htm
http://www.freedownloadmanager.org/...itude_software/
http://www.softjamboree.com/article...e-database.html
http://www.zip-codes.com/zip-code-database.asp
One of these will hopefully meet your requirements and budget.
A|||You could also determine approximate ZIP code to MSA mappings using the U.S.
Census Bureau's free Tiger database online. Although the ZIP codes in the
Tiger database are actually "ZIP Code Tabulation Areas" and not true ZIP
codes. This inaccuracy and the amount of work involved in downloading and
cleaning up the data would make me recommend buying a commercial product.
Help
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 =BD......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.This seems to be a duplicate post to the one in "Clients".
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Hi,
To truncate the log file in 6.5 do the below steps:-
use dbname
go
dbcc checktable(syslogs)
go
Dump tran dbname with no_log
After running that execute below command to get the log size.
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Thanks for your help!!
I have a cpl questions if you would not mind.
do users have to be off to run this procedure?
will running this procedure endanger any of the data?
any special things I need to know or do because this is version 6.5?
what do I need to back up before running this procedure?
I really thank you for your help!!
Tom
Hari Prasad wrote:
> Hi,
> To truncate the log file in 6.5 do the below steps:-
> use dbname
> go
> dbcc checktable(syslogs)
> go
> Dump tran dbname with no_log
>
> After running that execute below command to get the log size.
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> SQL Server MVP
> "tommy2" <tommy2@.ptd.net> wrote in message
> news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
> I am having a issue with a customers server. the specs are:
> 2003 server
> sql 6.5
> log file size is 1998MB (customer increased this 2 times this week) Log
> space avail:600mb
> In EM i try and truncate the log file... but the free space never
> increases. Also there is no maint. plan on this database. When I try
> and create one it advises against creating one with databases over
> 400MB.
> SQL has been on this server for 6 months. The problem just started.
> The past day or so these errors are showing up:
>
> Any help?
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (2)
> Event ID: 17060
> Date: 8/4/2006
> Time: 7:51:20 AM
> User: N/A
> Computer: AUX-SERVER
> Description:
> The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
> description; see Help and Support for details. The following
> information is part of the event: Error : 701, Severity: 17, State: 2,
> There is insufficient system memory to run this query..
> Data:
> 0000: bd 02 00 00 11 00 00 00 =BD......
> 0008: 00 00 00 00 07 00 00 00 ......
> 0010: 6d 61 73 74 65 72 00 master.
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 =BD......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.This seems to be a duplicate post to the one in "Clients".
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Hi,
To truncate the log file in 6.5 do the below steps:-
use dbname
go
dbcc checktable(syslogs)
go
Dump tran dbname with no_log
After running that execute below command to get the log size.
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Thanks for your help!!
I have a cpl questions if you would not mind.
do users have to be off to run this procedure?
will running this procedure endanger any of the data?
any special things I need to know or do because this is version 6.5?
what do I need to back up before running this procedure?
I really thank you for your help!!
Tom
Hari Prasad wrote:
> Hi,
> To truncate the log file in 6.5 do the below steps:-
> use dbname
> go
> dbcc checktable(syslogs)
> go
> Dump tran dbname with no_log
>
> After running that execute below command to get the log size.
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> SQL Server MVP
> "tommy2" <tommy2@.ptd.net> wrote in message
> news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
> I am having a issue with a customers server. the specs are:
> 2003 server
> sql 6.5
> log file size is 1998MB (customer increased this 2 times this week) Log
> space avail:600mb
> In EM i try and truncate the log file... but the free space never
> increases. Also there is no maint. plan on this database. When I try
> and create one it advises against creating one with databases over
> 400MB.
> SQL has been on this server for 6 months. The problem just started.
> The past day or so these errors are showing up:
>
> Any help?
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (2)
> Event ID: 17060
> Date: 8/4/2006
> Time: 7:51:20 AM
> User: N/A
> Computer: AUX-SERVER
> Description:
> The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
> description; see Help and Support for details. The following
> information is part of the event: Error : 701, Severity: 17, State: 2,
> There is insufficient system memory to run this query..
> Data:
> 0000: bd 02 00 00 11 00 00 00 =BD......
> 0008: 00 00 00 00 07 00 00 00 ......
> 0010: 6d 61 73 74 65 72 00 master.
Sunday, February 19, 2012
Help
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 =BD......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.This seems to be a duplicate post to the one in "Clients".
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ½......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Hi,
To truncate the log file in 6.5 do the below steps:-
use dbname
go
dbcc checktable(syslogs)
go
Dump tran dbname with no_log
After running that execute below command to get the log size.
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ½......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Thanks for your help!!
I have a cpl questions if you would not mind.
do users have to be off to run this procedure?
will running this procedure endanger any of the data?
any special things I need to know or do because this is version 6.5?
what do I need to back up before running this procedure?
I really thank you for your help!!
Tom
Hari Prasad wrote:
> Hi,
> To truncate the log file in 6.5 do the below steps:-
> use dbname
> go
> dbcc checktable(syslogs)
> go
> Dump tran dbname with no_log
>
> After running that execute below command to get the log size.
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> SQL Server MVP
> "tommy2" <tommy2@.ptd.net> wrote in message
> news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
> I am having a issue with a customers server. the specs are:
> 2003 server
> sql 6.5
> log file size is 1998MB (customer increased this 2 times this week) Log
> space avail:600mb
> In EM i try and truncate the log file... but the free space never
> increases. Also there is no maint. plan on this database. When I try
> and create one it advises against creating one with databases over
> 400MB.
> SQL has been on this server for 6 months. The problem just started.
> The past day or so these errors are showing up:
>
> Any help?
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (2)
> Event ID: 17060
> Date: 8/4/2006
> Time: 7:51:20 AM
> User: N/A
> Computer: AUX-SERVER
> Description:
> The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
> description; see Help and Support for details. The following
> information is part of the event: Error : 701, Severity: 17, State: 2,
> There is insufficient system memory to run this query..
> Data:
> 0000: bd 02 00 00 11 00 00 00 =BD......
> 0008: 00 00 00 00 07 00 00 00 ......
> 0010: 6d 61 73 74 65 72 00 master.
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 =BD......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.This seems to be a duplicate post to the one in "Clients".
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ½......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Hi,
To truncate the log file in 6.5 do the below steps:-
use dbname
go
dbcc checktable(syslogs)
go
Dump tran dbname with no_log
After running that execute below command to get the log size.
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ½......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Thanks for your help!!
I have a cpl questions if you would not mind.
do users have to be off to run this procedure?
will running this procedure endanger any of the data?
any special things I need to know or do because this is version 6.5?
what do I need to back up before running this procedure?
I really thank you for your help!!
Tom
Hari Prasad wrote:
> Hi,
> To truncate the log file in 6.5 do the below steps:-
> use dbname
> go
> dbcc checktable(syslogs)
> go
> Dump tran dbname with no_log
>
> After running that execute below command to get the log size.
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> SQL Server MVP
> "tommy2" <tommy2@.ptd.net> wrote in message
> news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
> I am having a issue with a customers server. the specs are:
> 2003 server
> sql 6.5
> log file size is 1998MB (customer increased this 2 times this week) Log
> space avail:600mb
> In EM i try and truncate the log file... but the free space never
> increases. Also there is no maint. plan on this database. When I try
> and create one it advises against creating one with databases over
> 400MB.
> SQL has been on this server for 6 months. The problem just started.
> The past day or so these errors are showing up:
>
> Any help?
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (2)
> Event ID: 17060
> Date: 8/4/2006
> Time: 7:51:20 AM
> User: N/A
> Computer: AUX-SERVER
> Description:
> The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
> description; see Help and Support for details. The following
> information is part of the event: Error : 701, Severity: 17, State: 2,
> There is insufficient system memory to run this query..
> Data:
> 0000: bd 02 00 00 11 00 00 00 =BD......
> 0008: 00 00 00 00 07 00 00 00 ......
> 0010: 6d 61 73 74 65 72 00 master.
Subscribe to:
Posts (Atom)