Showing posts with label type. Show all posts
Showing posts with label type. Show all posts

Friday, March 23, 2012

Excel Column Data Type Issue

Ok, hopefully a simple issue with a simple fix. I'm importing data from an Excel spreadsheet with values such as: 10, 20, 20 Tall, 40, 40 Tall. The column imports but is treated as numeric with values 10, 20, 20, 40, 40. I set the cells to be treated as text in Excel. Any suggestions?Leave it to Microsoft to make this a painful process. Guessing data types is a nice feature and saves time, but sometimes, dang it, I just want to turn it off!

Anywho, try changing this registry key to 0 in order to change the default of scanning 8 rows to unlimited:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel|||Hi!

I have set the value in the registry (TypeGuessRows=0), but i still don't get the right data type.

What I have figured out:
Lets say I have 25 rows in my column in the Excel file. It that column 13 are numeric values and 12 are text. In this case the column gets indentified as a Numeric type.
Now if there are 12 numeric and 13 text values, then the type is set to text.

Is there any way to get JET engine indentify the coulmn type as text if there is only one text value?
It really sux if the type is determined by the majority of the values, this way there is no sence to increase the number of the sampled rows, as if you have more numeric values then the type will be numeric anyway.

Any help? Ideas?

Excel Column Data Type Issue

Ok, hopefully a simple issue with a simple fix. I'm importing data from an Excel spreadsheet with values such as: 10, 20, 20 Tall, 40, 40 Tall. The column imports but is treated as numeric with values 10, 20, 20, 40, 40. I set the cells to be treated as text in Excel. Any suggestions?Leave it to Microsoft to make this a painful process. Guessing data types is a nice feature and saves time, but sometimes, dang it, I just want to turn it off!

Anywho, try changing this registry key to 0 in order to change the default of scanning 8 rows to unlimited:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel|||Hi!

I have set the value in the registry (TypeGuessRows=0), but i still don't get the right data type.

What I have figured out:
Lets say I have 25 rows in my column in the Excel file. It that column 13 are numeric values and 12 are text. In this case the column gets indentified as a Numeric type.
Now if there are 12 numeric and 13 text values, then the type is set to text.

Is there any way to get JET engine indentify the coulmn type as text if there is only one text value?
It really sux if the type is determined by the majority of the values, this way there is no sence to increase the number of the sampled rows, as if you have more numeric values then the type will be numeric anyway.

Any help? Ideas?

excel column data

im trying to access data in an excel spreadsheet using excel source component...the excel column is type of general and most of the data is numeric, some string..now, when ii hit the preview button, the string data would show up as NULL and the numeric data are correct...i've changed the excel column to TEXT data type and same result, how can i get the string data from this column?OK..GOT IT, ADDING NMEX=1 IN THE EXCEL CONNECTION MANAGER ALLOWS THE READER TO READ MIXED DATA IN THE COLUMN SINCE EXCEL USE THE FIRST 8 ROWS TO DETERMINE THE DATATYPE OF THE COLUMN|||Correction...that's "IMEX" not "NMEX".sql

Monday, March 19, 2012

Example of binary data type in SQL Server

There are two datatypes for storing binary data type in the SQL Server:
1. binary - for fixed length binary data
2. varbinary - for variable length data
My question is: how is data inserted into them? Do they have any
delimiters that go into the insert statement like strings and datetimes
have? What format (hex/decimal?) do they accept data in? Can you please
give me an insert statement example?
When we wrote the SQL Stanardards, we wanted to design a high level
abstract language for data that would be portable beause it would NEVER
deal with the low level PHYSICAL representation of the data.
Why do you wish to write kludges?
|||Water Cooler v2 wrote:
> There are two datatypes for storing binary data type in the SQL Server:
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?
Apparently Celko forgot about the part where you answer the question.
I've always done it by encoding it in hex first. Then you can do
something like this:
insert myTable (myBinaryColumn) values (0x8d7e6a5d4b3e2e1f)
Just put the 0x before whatever hex value you come up with. The
difference between the two is the same as the difference between char
and varchar. In general, if the values in that column are either short
or all roughly (or exactly) the same length, use binary. Otherwise,
use varbinary.
|||In addition to what ZeldorBlat said, if you need to make larger values, keep
in mind that the + operator is used to concatenate binary strings.
eg: 0xA34B + 0xCA02 is 0xA34BCA02
This can help break such strings up over multiple lines in a script.
HTH,
Greg
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1138493601.782824.249580@.o13g2000cwo.googlegr oups.com...
> There are two datatypes for storing binary data type in the SQL Server:
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?
>
|||Are you implying that in your opinion binary data -- such as, for instance,
images -- should never be stored in a SQL DBMS? Aren't standard image
formats such as GIF and JPEG pretty much universal at this point? Why would
storing that data in a SQL DBMS defeat your notion of portability?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1138502955.918869.319550@.g43g2000cwa.googlegr oups.com...
> When we wrote the SQL Stanardards, we wanted to design a high level
> abstract language for data that would be portable beause it would NEVER
> deal with the low level PHYSICAL representation of the data.
> Why do you wish to write kludges?
>
|||--CELKO-- (jcelko212@.earthlink.net) writes:
> When we wrote the SQL Stanardards, we wanted to design a high level
> abstract language for data that would be portable beause it would NEVER
> deal with the low level PHYSICAL representation of the data.
And what if the data is binary? How would you store a JPEG image in a
database? You would disassemble it, and store it in some high-level format?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||>> How would you store a JPEG image in a database? You would disassemble it, and store it in some high-level format? <<
1) Store a file name as a string, so that the application can grab the
file.
2) If this is a serious problem, then use an image base tool. IBM has
one that lets you make a drawing as the query and it will pull out the
ones that are closest; there are several products that do nothign but
face and fingerprint matching; CAD systems that handle 3D objects; etc.
SQL is not the answer to everything.
|||--CELKO-- wrote:
> 1) Store a file name as a string, so that the application can grab the
> file.
> 2) If this is a serious problem, then use an image base tool. IBM has
> one that lets you make a drawing as the query and it will pull out the
> ones that are closest; there are several products that do nothign but
> face and fingerprint matching; CAD systems that handle 3D objects; etc.
>
> SQL is not the answer to everything.
Again, you still haven't answered the question.
|||Amazingly, I agree with Celko here. #1 is what we do and it works
really well. It allows you to have a separate file server when you need
greater storage space for user files without haveing to make your SQL
Server a file server.
|||--CELKO-- (jcelko212@.earthlink.net) writes:[vbcol=seagreen]
it, and store it in some high-level format? <<
> 1) Store a file name as a string, so that the application can grab the
> file.
Yes, this is an option. Just as you could store employee names,
number of car doors or what ever on a file, and then store the file
name in the database.
However, it's difficult to get transactional consistency with a file
system. You commit the transaction, but the file could not be stored
on disk. Or the file is stored on disk, but then the transaction was
rolled back for some resaon. Or consider the case that the file system
is rearranged, and all the file pointers become stale.
It is not uncommon to use this approach in SQL Server though, and
the main reason is probably that the image data type has been difficult
to work with. (Which has nothing to do with its binary-ness to do, but
it's largeness.) With the advent of varbinary(MAX) in SQL 2005, there
may be less reason for this.

> 2) If this is a serious problem, then use an image base tool. IBM has
> one that lets you make a drawing as the query and it will pull out the
> ones that are closest; there are several products that do nothign but
> face and fingerprint matching; CAD systems that handle 3D objects; etc.
> SQL is not the answer to everything.
But it's surprising to hear that it's not the tool to store data.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Example of binary data type in SQL Server

There are two datatypes for storing binary data type in the SQL Server:
1. binary - for fixed length binary data
2. varbinary - for variable length data
My question is: how is data inserted into them? Do they have any
delimiters that go into the insert statement like strings and datetimes
have? What format (hex/decimal?) do they accept data in? Can you please
give me an insert statement example?When we wrote the SQL Stanardards, we wanted to design a high level
abstract language for data that would be portable beause it would NEVER
deal with the low level PHYSICAL representation of the data.
Why do you wish to write kludges?|||Water Cooler v2 wrote:
> There are two datatypes for storing binary data type in the SQL Server:
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?
Apparently Celko forgot about the part where you answer the question.
I've always done it by encoding it in hex first. Then you can do
something like this:
insert myTable (myBinaryColumn) values (0x8d7e6a5d4b3e2e1f)
Just put the 0x before whatever hex value you come up with. The
difference between the two is the same as the difference between char
and varchar. In general, if the values in that column are either short
or all roughly (or exactly) the same length, use binary. Otherwise,
use varbinary.|||In addition to what ZeldorBlat said, if you need to make larger values, keep
in mind that the + operator is used to concatenate binary strings.
eg: 0xA34B + 0xCA02 is 0xA34BCA02
This can help break such strings up over multiple lines in a script.
HTH,
Greg
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1138493601.782824.249580@.o13g2000cwo.googlegroups.com...
> There are two datatypes for storing binary data type in the SQL Server:
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?
>|||Are you implying that in your opinion binary data -- such as, for instance,
images -- should never be stored in a SQL DBMS? Aren't standard image
formats such as GIF and JPEG pretty much universal at this point? Why would
storing that data in a SQL DBMS defeat your notion of portability?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1138502955.918869.319550@.g43g2000cwa.googlegroups.com...
> When we wrote the SQL Stanardards, we wanted to design a high level
> abstract language for data that would be portable beause it would NEVER
> deal with the low level PHYSICAL representation of the data.
> Why do you wish to write kludges?
>|||--CELKO-- (jcelko212@.earthlink.net) writes:
> When we wrote the SQL Stanardards, we wanted to design a high level
> abstract language for data that would be portable beause it would NEVER
> deal with the low level PHYSICAL representation of the data.
And what if the data is binary? How would you store a JPEG image in a
database? You would disassemble it, and store it in some high-level format?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||>> How would you store a JPEG image in a database? You would disassemble it
, and store it in some high-level format? <<
1) Store a file name as a string, so that the application can grab the
file.
2) If this is a serious problem, then use an image base tool. IBM has
one that lets you make a drawing as the query and it will pull out the
ones that are closest; there are several products that do nothign but
face and fingerprint matching; CAD systems that handle 3D objects; etc.
SQL is not the answer to everything.|||--CELKO-- wrote:
> 1) Store a file name as a string, so that the application can grab the
> file.
> 2) If this is a serious problem, then use an image base tool. IBM has
> one that lets you make a drawing as the query and it will pull out the
> ones that are closest; there are several products that do nothign but
> face and fingerprint matching; CAD systems that handle 3D objects; etc.
>
> SQL is not the answer to everything.
Again, you still haven't answered the question.|||Amazingly, I agree with Celko here. #1 is what we do and it works
really well. It allows you to have a separate file server when you need
greater storage space for user files without haveing to make your SQL
Server a file server.|||--CELKO-- (jcelko212@.earthlink.net) writes:
it, and store it in some high-level format? <<[vbcol=seagreen]
> 1) Store a file name as a string, so that the application can grab the
> file.
Yes, this is an option. Just as you could store employee names,
number of car doors or what ever on a file, and then store the file
name in the database.
However, it's difficult to get transactional consistency with a file
system. You commit the transaction, but the file could not be stored
on disk. Or the file is stored on disk, but then the transaction was
rolled back for some resaon. Or consider the case that the file system
is rearranged, and all the file pointers become stale.
It is not uncommon to use this approach in SQL Server though, and
the main reason is probably that the image data type has been difficult
to work with. (Which has nothing to do with its binary-ness to do, but
it's largeness.) With the advent of varbinary(MAX) in SQL 2005, there
may be less reason for this.

> 2) If this is a serious problem, then use an image base tool. IBM has
> one that lets you make a drawing as the query and it will pull out the
> ones that are closest; there are several products that do nothign but
> face and fingerprint matching; CAD systems that handle 3D objects; etc.
> SQL is not the answer to everything.
But it's surprising to hear that it's not the tool to store data.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Example of binary data type in SQL Server

There are two datatypes for storing binary data type in the SQL Server:
1. binary - for fixed length binary data
2. varbinary - for variable length data
My question is: how is data inserted into them? Do they have any
delimiters that go into the insert statement like strings and datetimes
have? What format (hex/decimal?) do they accept data in? Can you please
give me an insert statement example?When we wrote the SQL Stanardards, we wanted to design a high level
abstract language for data that would be portable beause it would NEVER
deal with the low level PHYSICAL representation of the data.
Why do you wish to write kludges?|||Water Cooler v2 wrote:
> There are two datatypes for storing binary data type in the SQL Server:
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?
Apparently Celko forgot about the part where you answer the question.
I've always done it by encoding it in hex first. Then you can do
something like this:
insert myTable (myBinaryColumn) values (0x8d7e6a5d4b3e2e1f)
Just put the 0x before whatever hex value you come up with. The
difference between the two is the same as the difference between char
and varchar. In general, if the values in that column are either short
or all roughly (or exactly) the same length, use binary. Otherwise,
use varbinary.|||In addition to what ZeldorBlat said, if you need to make larger values, keep
in mind that the + operator is used to concatenate binary strings.
eg: 0xA34B + 0xCA02 is 0xA34BCA02
This can help break such strings up over multiple lines in a script.
HTH,
Greg
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1138493601.782824.249580@.o13g2000cwo.googlegroups.com...
> There are two datatypes for storing binary data type in the SQL Server:
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?
>|||Are you implying that in your opinion binary data -- such as, for instance,
images -- should never be stored in a SQL DBMS? Aren't standard image
formats such as GIF and JPEG pretty much universal at this point? Why would
storing that data in a SQL DBMS defeat your notion of portability?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1138502955.918869.319550@.g43g2000cwa.googlegroups.com...
> When we wrote the SQL Stanardards, we wanted to design a high level
> abstract language for data that would be portable beause it would NEVER
> deal with the low level PHYSICAL representation of the data.
> Why do you wish to write kludges?
>|||--CELKO-- (jcelko212@.earthlink.net) writes:
> When we wrote the SQL Stanardards, we wanted to design a high level
> abstract language for data that would be portable beause it would NEVER
> deal with the low level PHYSICAL representation of the data.
And what if the data is binary? How would you store a JPEG image in a
database? You would disassemble it, and store it in some high-level format?
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||>> How would you store a JPEG image in a database? You would disassemble it, and store it in some high-level format? <<
1) Store a file name as a string, so that the application can grab the
file.
2) If this is a serious problem, then use an image base tool. IBM has
one that lets you make a drawing as the query and it will pull out the
ones that are closest; there are several products that do nothign but
face and fingerprint matching; CAD systems that handle 3D objects; etc.
SQL is not the answer to everything.|||--CELKO-- wrote:
> >> How would you store a JPEG image in a database? You would disassemble it, and store it in some high-level format? <<
> 1) Store a file name as a string, so that the application can grab the
> file.
> 2) If this is a serious problem, then use an image base tool. IBM has
> one that lets you make a drawing as the query and it will pull out the
> ones that are closest; there are several products that do nothign but
> face and fingerprint matching; CAD systems that handle 3D objects; etc.
>
> SQL is not the answer to everything.
Again, you still haven't answered the question.|||Amazingly, I agree with Celko here. #1 is what we do and it works
really well. It allows you to have a separate file server when you need
greater storage space for user files without haveing to make your SQL
Server a file server.|||--CELKO-- (jcelko212@.earthlink.net) writes:
>> How would you store a JPEG image in a database? You would disassemble
it, and store it in some high-level format? <<
> 1) Store a file name as a string, so that the application can grab the
> file.
Yes, this is an option. Just as you could store employee names,
number of car doors or what ever on a file, and then store the file
name in the database.
However, it's difficult to get transactional consistency with a file
system. You commit the transaction, but the file could not be stored
on disk. Or the file is stored on disk, but then the transaction was
rolled back for some resaon. Or consider the case that the file system
is rearranged, and all the file pointers become stale.
It is not uncommon to use this approach in SQL Server though, and
the main reason is probably that the image data type has been difficult
to work with. (Which has nothing to do with its binary-ness to do, but
it's largeness.) With the advent of varbinary(MAX) in SQL 2005, there
may be less reason for this.
> 2) If this is a serious problem, then use an image base tool. IBM has
> one that lets you make a drawing as the query and it will pull out the
> ones that are closest; there are several products that do nothign but
> face and fingerprint matching; CAD systems that handle 3D objects; etc.
> SQL is not the answer to everything.
But it's surprising to hear that it's not the tool to store data.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||> #1 is what we do and it works really well.
What's your backup/recovery strategy? What happens if someone replaces
a file? Overwrites the file without changing datetime stamp? Renames a
folder? How do you know that your data has been corrupted / messed up
with?

Example of binary data type in SQL Server

There are two datatypes for storing binary data type in the SQL Server:

1. binary - for fixed length binary data
2. varbinary - for variable length data

My question is: how is data inserted into them? Do they have any
delimiters that go into the insert statement like strings and datetimes
have? What format (hex/decimal?) do they accept data in? Can you please
give me an insert statement example?When we wrote the SQL Stanardards, we wanted to design a high level
abstract language for data that would be portable beause it would NEVER
deal with the low level PHYSICAL representation of the data.

Why do you wish to write kludges?|||Water Cooler v2 wrote:
> There are two datatypes for storing binary data type in the SQL Server:
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?

Apparently Celko forgot about the part where you answer the question.

I've always done it by encoding it in hex first. Then you can do
something like this:

insert myTable (myBinaryColumn) values (0x8d7e6a5d4b3e2e1f)

Just put the 0x before whatever hex value you come up with. The
difference between the two is the same as the difference between char
and varchar. In general, if the values in that column are either short
or all roughly (or exactly) the same length, use binary. Otherwise,
use varbinary.|||In addition to what ZeldorBlat said, if you need to make larger values, keep
in mind that the + operator is used to concatenate binary strings.

eg: 0xA34B + 0xCA02 is 0xA34BCA02

This can help break such strings up over multiple lines in a script.

HTH,

Greg

"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1138493601.782824.249580@.o13g2000cwo.googlegr oups.com...
> There are two datatypes for storing binary data type in the SQL Server:
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?|||--CELKO-- (jcelko212@.earthlink.net) writes:
> When we wrote the SQL Stanardards, we wanted to design a high level
> abstract language for data that would be portable beause it would NEVER
> deal with the low level PHYSICAL representation of the data.

And what if the data is binary? How would you store a JPEG image in a
database? You would disassemble it, and store it in some high-level format?

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||>> How would you store a JPEG image in a database? You would disassemble it, and store it in some high-level format? <<

1) Store a file name as a string, so that the application can grab the
file.

2) If this is a serious problem, then use an image base tool. IBM has
one that lets you make a drawing as the query and it will pull out the
ones that are closest; there are several products that do nothign but
face and fingerprint matching; CAD systems that handle 3D objects; etc.

SQL is not the answer to everything.|||--CELKO-- wrote:
> >> How would you store a JPEG image in a database? You would disassemble it, and store it in some high-level format? <<
> 1) Store a file name as a string, so that the application can grab the
> file.
> 2) If this is a serious problem, then use an image base tool. IBM has
> one that lets you make a drawing as the query and it will pull out the
> ones that are closest; there are several products that do nothign but
> face and fingerprint matching; CAD systems that handle 3D objects; etc.
>
> SQL is not the answer to everything.

Again, you still haven't answered the question.|||Amazingly, I agree with Celko here. #1 is what we do and it works
really well. It allows you to have a separate file server when you need
greater storage space for user files without haveing to make your SQL
Server a file server.|||--CELKO-- (jcelko212@.earthlink.net) writes:
>>> How would you store a JPEG image in a database? You would disassemble
it, and store it in some high-level format? <<
> 1) Store a file name as a string, so that the application can grab the
> file.

Yes, this is an option. Just as you could store employee names,
number of car doors or what ever on a file, and then store the file
name in the database.

However, it's difficult to get transactional consistency with a file
system. You commit the transaction, but the file could not be stored
on disk. Or the file is stored on disk, but then the transaction was
rolled back for some resaon. Or consider the case that the file system
is rearranged, and all the file pointers become stale.

It is not uncommon to use this approach in SQL Server though, and
the main reason is probably that the image data type has been difficult
to work with. (Which has nothing to do with its binary-ness to do, but
it's largeness.) With the advent of varbinary(MAX) in SQL 2005, there
may be less reason for this.

> 2) If this is a serious problem, then use an image base tool. IBM has
> one that lets you make a drawing as the query and it will pull out the
> ones that are closest; there are several products that do nothign but
> face and fingerprint matching; CAD systems that handle 3D objects; etc.
> SQL is not the answer to everything.

But it's surprising to hear that it's not the tool to store data.

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||> #1 is what we do and it works really well.

What's your backup/recovery strategy? What happens if someone replaces
a file? Overwrites the file without changing datetime stamp? Renames a
folder? How do you know that your data has been corrupted / messed up
with?

Wednesday, March 7, 2012

eventvwr.msc message

I keep getting this message in the event viewer -- how can I uninstall reportserver ?
Event Type: Information
Event Source: MSSQL$SQLEXPRESS
Event Category: (2)
Event ID: 17137
Date: 10/22/2006
Time: 10:49:57 AM
User: NT AUTHORITY\NETWORK SERVICE
Computer: ********************
Description:
Starting up database 'ReportServerTempDB'.I'm not sure about SQL Express, but on the SQL 2005 installer you can launch
the uninstall from the Add/Remove Programs select change and during the
uninstall select what component (Reporting Services) you would like to
uninstall.
Steve MunLeeuw
"Jon Paal" <Jon[ nospam ]Paal @. everywhere dot com> wrote in message
news:uhJBURg9GHA.1168@.TK2MSFTNGP03.phx.gbl...
>I keep getting this message in the event viewer -- how can I uninstall
>reportserver ?
> Event Type: Information
> Event Source: MSSQL$SQLEXPRESS
> Event Category: (2)
> Event ID: 17137
> Date: 10/22/2006
> Time: 10:49:57 AM
> User: NT AUTHORITY\NETWORK SERVICE
> Computer: ********************
> Description:
> Starting up database 'ReportServerTempDB'.
>
>

Events in SSRS Reports

Hi,
I would like to have a button type of thing on the report and on click of
it, I need to call a method in the custom assembly.
I was successful creating and using the custom assembly, but not able to
raise an event from the report.
Thanks in advance,
SureshI am not aware of any way to do this. I am aware of a variety of extensions
that are possible: rendering, security, data processing and delivery.
However, this is not like a winform or webform that has a variety of events
you can respond and write your custom code for.
What are you trying to do, perhaps there is another way to solve the
problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Suresh" <Suresh@.discussions.microsoft.com> wrote in message
news:409DCFC3-7875-4A9E-818D-C55094BC0895@.microsoft.com...
> Hi,
> I would like to have a button type of thing on the report and on click of
> it, I need to call a method in the custom assembly.
> I was successful creating and using the custom assembly, but not able to
> raise an event from the report.
> Thanks in advance,
> Suresh|||Thanks Bruce for the response,
After the report is generated from report server, I need to publish this
report to som eother location. I would like to acheive that by the click of a
button. Here Im not sure how to place a button, or just raise an event by the
user to perform that action.
Suresh. India
"Bruce L-C [MVP]" wrote:
> I am not aware of any way to do this. I am aware of a variety of extensions
> that are possible: rendering, security, data processing and delivery.
> However, this is not like a winform or webform that has a variety of events
> you can respond and write your custom code for.
> What are you trying to do, perhaps there is another way to solve the
> problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Suresh" <Suresh@.discussions.microsoft.com> wrote in message
> news:409DCFC3-7875-4A9E-818D-C55094BC0895@.microsoft.com...
> > Hi,
> > I would like to have a button type of thing on the report and on click of
> > it, I need to call a method in the custom assembly.
> > I was successful creating and using the custom assembly, but not able to
> > raise an event from the report.
> >
> > Thanks in advance,
> > Suresh
>
>|||I was looking for a way to reset the rownumber for each group, so I
could display a record count for every item in each group not one
continuous number for the entire report, when I saw this posting.
Access to the group event and being able to set rwonumber back to 1
would solve my task.
Perhaps there is another way to do it?
Thanks,
IanO|||What do you mean you need to publish? Are you wanting to save the report as
PDF somewhere? Or are you talking about publishing the report to another
Server?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Suresh" <Suresh@.discussions.microsoft.com> wrote in message
news:D617027B-61DB-4AA8-AD99-0E39070B60C8@.microsoft.com...
> Thanks Bruce for the response,
> After the report is generated from report server, I need to publish this
> report to som eother location. I would like to acheive that by the click
> of a
> button. Here Im not sure how to place a button, or just raise an event by
> the
> user to perform that action.
> Suresh. India
> "Bruce L-C [MVP]" wrote:
>> I am not aware of any way to do this. I am aware of a variety of
>> extensions
>> that are possible: rendering, security, data processing and delivery.
>> However, this is not like a winform or webform that has a variety of
>> events
>> you can respond and write your custom code for.
>> What are you trying to do, perhaps there is another way to solve the
>> problem.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Suresh" <Suresh@.discussions.microsoft.com> wrote in message
>> news:409DCFC3-7875-4A9E-818D-C55094BC0895@.microsoft.com...
>> > Hi,
>> > I would like to have a button type of thing on the report and on click
>> > of
>> > it, I need to call a method in the custom assembly.
>> > I was successful creating and using the custom assembly, but not able
>> > to
>> > raise an event from the report.
>> >
>> > Thanks in advance,
>> > Suresh
>>

Event-ID: 17052

Has anyone an idea what this type of error means?
Event-ID: 17052
Error: 17882, Severity: 18, State: 1
Error accepting connection request via Net-Library 'SSNETLIB'. Execution
continuing.Hi Tony - I have not see this before myself, but I have found a KB that
describes a possible cause of this error:
http://support.microsoft.com/?id=811887. Hope that helps.
--
Michiel Wories, SQL Server PM
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"Tony Mouton" <tmo@.abm.be> wrote in message
news:uO1wHzXmDHA.2364@.TK2MSFTNGP11.phx.gbl...
> Has anyone an idea what this type of error means?
> Event-ID: 17052
> Error: 17882, Severity: 18, State: 1
> Error accepting connection request via Net-Library 'SSNETLIB'. Execution
> continuing.
>

Sunday, February 26, 2012

Event Type for Object:ALTERED, Object:Created , Object:Deleted Event Class

Hi

I am trying to create a EVENT NOTIFICATION for tracking changes to existing database objects. New Database objects, DEletion of any database objects.

For this I would like to know what is the EEVEN TYPE given in CREATE NOTIFICATION syntax for the three events...

CREATE EVENT NOTIFICATION Logging_Schema_Change_Notification

ON DATABASE

FOR Object:Altered_EVENT -- This is the piece that is failing ...what is the name ?

TO SERVICE 'LoggingSchemaService', 'current database'

GO

regards

Imtiaz

Try

FOR Object_Altered

FOR Object_Created

and

FOR Object_Deleted

Friday, February 24, 2012

Event ID: 17830?

All,
Can't figure out why I am getting this message in my event log...
Event Type: Error
Event Source: MSSQL$SQLSERVER2005
Event Category: (4)
Event ID: 17830
Date: 9/14/2005
Time: 7:06:03 AM
User: N/A
Computer: ADDVMFM12
Description:
A network error occurred while establishing a connection; the connection has
been closed. This may have been caused by client or server login timeout
expiration. Time spent during login: total 3 ms, enqueued 1 ms, network
writes 1 ms, network reads 3 ms, establishing SSL 3 ms, negotiating SSPI 0
ms, validating login 0 ms. [CLIENT: 10.13.0.137]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: a6 45 00 00 14 00 00 00 E.....
0008: 18 00 00 00 41 00 44 00 ...A.D.
0010: 44 00 56 00 4d 00 46 00 D.V.M.F.
0018: 4d 00 31 00 32 00 5c 00 M.1.2.\.
0020: 53 00 51 00 4c 00 53 00 S.Q.L.S.
0028: 45 00 52 00 56 00 45 00 E.R.V.E.
0030: 52 00 32 00 30 00 30 00 R.2.0.0.
0038: 35 00 00 00 00 00 00 00 5......
Anyone have any idea why this is happening?
Thanks
MikeYou'll want to post this in the SQL Server 2005 CTP
newsgroups:
http://communities.microsoft.com/ne...lcid=us

-Sue
On Wed, 14 Sep 2005 07:23:14 -0400, "Mike"
<mgasperino@.mebtel.net> wrote:

>All,
>Can't figure out why I am getting this message in my event log...
>Event Type: Error
>Event Source: MSSQL$SQLSERVER2005
>Event Category: (4)
>Event ID: 17830
>Date: 9/14/2005
>Time: 7:06:03 AM
>User: N/A
>Computer: ADDVMFM12
>Description:
>A network error occurred while establishing a connection; the connection ha
s
>been closed. This may have been caused by client or server login timeout
>expiration. Time spent during login: total 3 ms, enqueued 1 ms, network
>writes 1 ms, network reads 3 ms, establishing SSL 3 ms, negotiating SSPI 0
>ms, validating login 0 ms. [CLIENT: 10.13.0.137]
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: a6 45 00 00 14 00 00 00 E.....
>0008: 18 00 00 00 41 00 44 00 ...A.D.
>0010: 44 00 56 00 4d 00 46 00 D.V.M.F.
>0018: 4d 00 31 00 32 00 5c 00 M.1.2.\.
>0020: 53 00 51 00 4c 00 53 00 S.Q.L.S.
>0028: 45 00 52 00 56 00 45 00 E.R.V.E.
>0030: 52 00 32 00 30 00 30 00 R.2.0.0.
>0038: 35 00 00 00 00 00 00 00 5......
>Anyone have any idea why this is happening?
>Thanks
>Mike
>

Event ID: 17830?

All,
Can't figure out why I am getting this message in my event log...
Event Type: Error
Event Source: MSSQL$SQLSERVER2005
Event Category: (4)
Event ID: 17830
Date: 9/14/2005
Time: 7:06:03 AM
User: N/A
Computer: ADDVMFM12
Description:
A network error occurred while establishing a connection; the connection has
been closed. This may have been caused by client or server login timeout
expiration. Time spent during login: total 3 ms, enqueued 1 ms, network
writes 1 ms, network reads 3 ms, establishing SSL 3 ms, negotiating SSPI 0
ms, validating login 0 ms. [CLIENT: 10.13.0.137]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: a6 45 00 00 14 00 00 00 E.....
0008: 18 00 00 00 41 00 44 00 ...A.D.
0010: 44 00 56 00 4d 00 46 00 D.V.M.F.
0018: 4d 00 31 00 32 00 5c 00 M.1.2.\.
0020: 53 00 51 00 4c 00 53 00 S.Q.L.S.
0028: 45 00 52 00 56 00 45 00 E.R.V.E.
0030: 52 00 32 00 30 00 30 00 R.2.0.0.
0038: 35 00 00 00 00 00 00 00 5......
Anyone have any idea why this is happening?
Thanks
Mike
You'll want to post this in the SQL Server 2005 CTP
newsgroups:
http://communities.microsoft.com/new...r2005&slcid=us
-Sue
On Wed, 14 Sep 2005 07:23:14 -0400, "Mike"
<mgasperino@.mebtel.net> wrote:

>All,
>Can't figure out why I am getting this message in my event log...
>Event Type: Error
>Event Source: MSSQL$SQLSERVER2005
>Event Category: (4)
>Event ID: 17830
>Date: 9/14/2005
>Time: 7:06:03 AM
>User: N/A
>Computer: ADDVMFM12
>Description:
>A network error occurred while establishing a connection; the connection has
>been closed. This may have been caused by client or server login timeout
>expiration. Time spent during login: total 3 ms, enqueued 1 ms, network
>writes 1 ms, network reads 3 ms, establishing SSL 3 ms, negotiating SSPI 0
>ms, validating login 0 ms. [CLIENT: 10.13.0.137]
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: a6 45 00 00 14 00 00 00 E.....
>0008: 18 00 00 00 41 00 44 00 ...A.D.
>0010: 44 00 56 00 4d 00 46 00 D.V.M.F.
>0018: 4d 00 31 00 32 00 5c 00 M.1.2.\.
>0020: 53 00 51 00 4c 00 53 00 S.Q.L.S.
>0028: 45 00 52 00 56 00 45 00 E.R.V.E.
>0030: 52 00 32 00 30 00 30 00 R.2.0.0.
>0038: 35 00 00 00 00 00 00 00 5......
>Anyone have any idea why this is happening?
>Thanks
>Mike
>

Event ID: 17055 Source: MSSQLSERVER Type: Information Login failed

I am having a problem with one of the website we host that accesses an
SQL2000 database. Every so often I get the above mentioned event in the
App. log accompanied by a error reported by the users browser stating
that the login failed for IUSR_xxxxxx. If I log into the server having
the problem and log out the problem resolves itself. I tried using
Profiler to see if I could see any odd activity and there was no
activity what so ever while the problem persisted. Once the problem
corrected by the login/logout I saw normal activity resume in Profiler.
The only this I noticed different after the login/logout fix was that
the network protocol: Named Pipes actioned appeared to be showing up in
Profiles where it was not before. I have checked all my permissions and
everything seems to be in order(especially since the login/logout seems
to resolve it). Any ideas as to what is causing this?
Thank you in advance,
Ethan Cottrell
Structured Business SystemsBased upon your description, it sounds like you're requesting a Windows
Authenticated connection from the web server, and
it is authenticating using the IUSR account. This account doesn't exist on
the SQL Server , so it fails.
If you then login to the server using Named Pipes, you've authenticated
yourself and any new sessions will piggy-back on this.
If you then check for successfull logins at the server, does it show that
IUSR connected successfully or your domain account?
These two articles may give you a better understanding as well.
332167 IIS 6.0: HOW TO: Configure IIS to Control the Anonymous Password
http://support.microsoft.com/?id=332167
229286 FP2000: Cannot Connect to SQL Database on Windows NT Server Computer
http://support.microsoft.com/?id=229286
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
I already had added the IUSR account to SQL and gave it permissions on
the database. Any pages on the site that do not require a connection to
the database are fine, it is only those ASP pages that connect to the
database that are having this problem. When I use Profiler I can see
that the IUSR account has no problems logging in when there is no
problem, but once the problem occurs the IUSR account activity stops and
is replaced by the NT AUTHORITY/ANONYMOUS or something like that.
I think I may have resolved this issue already, but I am keeping an eye
on it. I forgot to mention earlier that the database in question is
accessing data on a linked server also, and I think that may have been
the source of my problem. We had recently installed a new server (server
B) with a different host name from the original. Server A is where the
website and it's database exist and server B is where the database with
additional data exists (it is the primary db for another site). I added
the old server b's host name to DNS to hopefully eliminate and potential
problems, but that may not have been the case. I have since removed all
linked servers and remote servers and recreated them in both instances
of SQL using the correct host name and am using the sa account to
authenticate between them. Does that sound like it could have been the
source of the problem?
Thank you for your response,
Ethan Cottrell
Structured Business Systems
Kevin McDonnell [MSFT] wrote:
> Based upon your description, it sounds like you're requesting a Windows
> Authenticated connection from the web server, and
> it is authenticating using the IUSR account. This account doesn't exist o
n
> the SQL Server , so it fails.
> If you then login to the server using Named Pipes, you've authenticated
> yourself and any new sessions will piggy-back on this.
> If you then check for successfull logins at the server, does it show that
> IUSR connected successfully or your domain account?
>
> These two articles may give you a better understanding as well.
> 332167 IIS 6.0: HOW TO: Configure IIS to Control the Anonymous Password
> http://support.microsoft.com/?id=332167
> 229286 FP2000: Cannot Connect to SQL Database on Windows NT Server Compute
r
> http://support.microsoft.com/?id=229286
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||DNS issues could certainly cause a problem from the web server to the
database.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Friday, February 17, 2012

Event Handler Refresh

I am current using Event Handlers in an SSIS package, but when adding a new EventHandler type eg. OnPreExecute, to an executable within the package, I am unable to see this new EventHandler defined in the hierarchical listing on the left hand combo box (named Executables).

Can't seem to find a Refresh option anywhere. I've only been able to see these newly created EventHandlers in the hierarchical listing by closing and re-opening the package.

Is this a 'feature' or am I missing a Refresh option somewhere.

Thanks.

Check the scope of the eventhandler you have created. Is it possible you are looking in the wrong place in the Package Explorer?

-Jamie

|||

Hi Jamie,

I have checked the scope and I am not looking in the incorrect place.

I wasn't not looking in Package Explorer though, but in the Executables drop-down box on the Event Handlers tab.

However the problem for me is replicated in Package Explorer also. Would you confirm that you are able to duplicate the problem ?

P R W.

|||

I don't seem to be able to repro your issue.

You said you were not looking at the Package Explorer, were you in the Event Handler diagram, then? If yes, and you did set the "Executables" drop down to the correct item, did you also set the "Event Handler" drop down (on the right) to, say"OnPreExecute" if that is the event? Since the default there is "OnError"

If you still get this, pls describe your SQL build version (RTM, SP1?) and your detailed steps. We'll see how we can help.

thanks

wenyang

|||

Hi P R W,

I'm not positive, but I think I saw this before I applied SQL Server 2005 SP1. Have you applied SP1?

Hope this helps,

Andy

Event Error 108

I periodically get the following event error on the system running SSRS:
Event Type: Error
Event Source: Report Server (MSSQLSERVER)
Event Category: Extension
Event ID: 108
Date: 1/24/2008
Time: 10:04:32 AM
User: N/A
Computer: SERENITY
Description:
Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary
extension.
Can anyone tell me what might be causing this?
ThanksHello Tom,
I would like to know more detailed information.
1. What's your SQL Server version? Have you applied latest services pack?
2. Are you using some custom data extension to access the data source?
3. Are you using some subscription to deliver the report?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||1. 9.0.3054
2. No
3. Some reports are delivered by subscription
Thanks
"Wei Lu [MSFT]" wrote:
> Hello Tom,
> I would like to know more detailed information.
> 1. What's your SQL Server version? Have you applied latest services pack?
> 2. Are you using some custom data extension to access the data source?
> 3. Are you using some subscription to deliver the report?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Tom,
If you try to run the report, did you find this event?
If you run the report subscription. Did you find the event?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Wednesday, February 15, 2012

event 7031

Windows 2000 Server SP4, Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
SQL Server is finished with:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7031
Date: 22.03.2004
Time: 10:14:19
User: N/A
Computer: SQL
Description:
The MSSQLSERVER service terminated unexpectedly. It has done this 3 time(s). The following corrective action will be taken in 0 milliseconds: No action.
There are no any messages in Sql Server logs before this error.
What can we do?
Did you search the server for any dump files that may have
been generated when this happened?
-Sue
On Wed, 24 Mar 2004 04:21:08 -0800, Irina Rutman
<anonymous@.discussions.microsoft.com> wrote:

>Windows 2000 Server SP4, Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
>SQL Server is finished with:
>--
>Event Type: Error
>Event Source: Service Control Manager
>Event Category: None
>Event ID: 7031
>Date: 22.03.2004
>Time: 10:14:19
>User: N/A
>Computer: SQL
>Description:
>The MSSQLSERVER service terminated unexpectedly. It has done this 3 time(s). The following corrective action will be taken in 0 milliseconds: No action.
>--
>There are no any messages in Sql Server logs before this error.
>What can we do?
|||Yes. We searched. But there are no any files in all 3 cases.
|||Unfortunately with nothing logged anywhere, it will be
pretty much impossible to figure out what happened. But in
case in happens in again, what you may want to do is setup a
blackbox trace on the server. That way you will have a log
of what was going on in SQL Server the next time it happens.
-Sue
On Thu, 25 Mar 2004 00:46:06 -0800, Irina Rutman
<anonymous@.discussions.microsoft.com> wrote:

>Yes. We searched. But there are no any files in all 3 cases.
|||What do the SQL Server error logs say?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Event 17055: SQL Server Assertion error

Every night I am seeing the below error followed by a restart of SQL. This
occurs at 10:05 PM.
Any ideas?
Thanks,
Bob
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 10/11/2007
Time: 10:05:28 PM
Description:
17066 :
SQL Server Assertion: File: <umsio.cpp>, line=563
Failed Assertion = 'm_busyCnt == 1'.This is often a SQL Server bug, and I'd talk to the MS SQL support.
Linchi
"BobW" wrote:
> Every night I am seeing the below error followed by a restart of SQL. This
> occurs at 10:05 PM.
> Any ideas?
> Thanks,
> Bob
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 10/11/2007
> Time: 10:05:28 PM
> Description:
> 17066 :
> SQL Server Assertion: File: <umsio.cpp>, line=563
> Failed Assertion = 'm_busyCnt == 1'.|||I did find article KB914298 and requested the hotfix. What I find
troublesome is I have two SQL servers are very close to identical and only
one is exhibiting the behavior
Thanks,
Bob
"Linchi Shea" wrote:
> This is often a SQL Server bug, and I'd talk to the MS SQL support.
> Linchi
> "BobW" wrote:
> > Every night I am seeing the below error followed by a restart of SQL. This
> > occurs at 10:05 PM.
> >
> > Any ideas?
> > Thanks,
> > Bob
> >
> >
> > Event Type: Error
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 10/11/2007
> > Time: 10:05:28 PM
> > Description:
> > 17066 :
> > SQL Server Assertion: File: <umsio.cpp>, line=563
> > Failed Assertion = 'm_busyCnt == 1'.|||Dear Bob,
Thank you for posting here.
Before going further, I would like to know you load the data into database
by which method? As KB914298 described, you can workaround this issue by
using either the Bulk-Copy program or Data Transformation Service (DTS) to
import the data. Does this information helps?
Based on my experience, this issue seems to be a data corruption. According
to your situation, we can first attempt to install the hotfix KB914298 and
also run the "DBCC CheckDB" to do the database check. If the issue
persists, we may need to analyze the crash dump file to determine the root
cause. Unfortunately, we cannot help you analyze the dump file in newsgroup
and you may need to speak directly with a Microsoft Support Professional so
that the crash dump can be analyzed. Regarding this point, I'll appreciate
your understanding.
For current situation, my suggestion is:
1. Install the Hotfix KB914298
2. Use "DBCC CheckDB" command to check the allocation and structural
integrity of all the objects in the database. I suggest you check all
databases.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
dbcc_00gy.asp
Please let me know the exact output of DBCC CheckDB. Meanwhile, please pack
the SQL error log and System & Application event log into a zip file. Send
me this zip file to v-adamqu@.microsoft.com I hope we can find any clues
from these.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
| Thread-Topic: Event 17055: SQL Server Assertion error
| thread-index: AcgVAug1OJA0yFz4TWe2zKieAYot/g==| X-WBNR-Posting-Host: 207.46.193.207
| From: =?Utf-8?B?Qm9iVw==?= <Osm3um@.news.postalias>
| References: <4C12F2AF-6B8E-403B-BA80-76C5A48B6C3E@.microsoft.com>
<035A5E8F-8CBB-4255-AACD-83CE90F93846@.microsoft.com>
| Subject: RE: Event 17055: SQL Server Assertion error
| Date: Mon, 22 Oct 2007 16:26:01 -0700
| Lines: 33
| Message-ID: <3C62397A-B661-4F51-82C9-6FF74BE36F21@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2929
| Newsgroups: microsoft.public.sqlserver.server
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:28508
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I did find article KB914298 and requested the hotfix. What I find
| troublesome is I have two SQL servers are very close to identical and
only
| one is exhibiting the behavior
|
| Thanks,
| Bob
|
| "Linchi Shea" wrote:
|
| > This is often a SQL Server bug, and I'd talk to the MS SQL support.
| >
| > Linchi
| >
| > "BobW" wrote:
| >
| > > Every night I am seeing the below error followed by a restart of SQL.
This
| > > occurs at 10:05 PM.
| > >
| > > Any ideas?
| > > Thanks,
| > > Bob
| > >
| > >
| > > Event Type: Error
| > > Event Source: MSSQLSERVER
| > > Event Category: (2)
| > > Event ID: 17055
| > > Date: 10/11/2007
| > > Time: 10:05:28 PM
| > > Description:
| > > 17066 :
| > > SQL Server Assertion: File: <umsio.cpp>, line=563
| > > Failed Assertion = 'm_busyCnt == 1'.
|

eveni id 6005

I get report number 6005 in event log, where can i found relevation
information or what is solution
there is full report
type error
user n/a
source VSS
category none
event id 6005
Sqllib error: Database %1 is stored on multiple volumes, only some of which
are being shadowed.Hi
Maybe checkout and the answers given:
http://tinyurl.com/7zd5f
John
"Drobek" wrote:
> I get report number 6005 in event log, where can i found relevation
> information or what is solution
> there is full report
> type error
> user n/a
> source VSS
> category none
> event id 6005
> Sqllib error: Database %1 is stored on multiple volumes, only some of which
> are being shadowed.
>