Cannot write a small row! Please help...

Hi everyone,
This is weird. Please help!
I have a long row in the form:
WordA WordB WordC WordD etc...
The above row is 5,294 bytes in size.
I got the soundex equivalent of this row. It now became:
SoundexA SoundexB SoundexC SoundexD etc...
It's size is now 2,898 bytes. AS you would expect as soundex returns a
4 letter code.
I attempt to write the soundex field to its place in the database. I
get the followign error message:
Cannot create a row of size 9602 which is greater than the allowable
maximum of 8060.
The statement has been terminated.
Now, I am totally confused - Does anyone know why this is happening?
Any ideas/suggestions/comments/diagnostics that I could run would be
great. Please help me!
Confused,
Al.Could it be that your possible row size is exceeded ? Not the actual
used one, but the highest possible. Therefore you should have gotten an
error while creating or altering the table once upon a time.
SELECT Sum(ISNULL(CHARACTER_MAXIMUM_LENGTH,length)) from
INFORMATION_SCHEMA.Columns col
INNER join systypes
on systypes.name = col.Data_type
Where table_name = 'YourTable'
HTH, jens Suessmeyer.|||Thanks jens,
I ran this cool command on my table and get the answer: 8392
Unfortunately I don't know where it is! Can you help me locate it or
suggest possible solutions? Can you recommend what I should do please?
Any assistance much appreciated.
Thank you,
Al.|||Sure, you should narrow down your datatypes that these fit on a
datapage of 8060 bytes. In some cases some columns use wasted datatypes
as somebody just assumes how many bytes are to go in that column. If
there is in some cases reengineering,l the people narrow down the
datatypes because they know the actual data size of the columns later.
Or you can split out the table to some "Soundex table" qwhich
references 1by1 the original table and just point with the same PK on
this.
HTH, jens Suessmeyer.

Cannot write a small row! Please help...

Hi everyone,
This is weird. Please help!
I have a long row in the form:
WordAWordBWordCWordD etc...
The above row is 5,294 bytes in size.
I got the soundex equivalent of this row. It now became:
SoundexASoundexBSoundexCSoundexD etc...
It's size is now 2,898 bytes. AS you would expect as soundex returns a
4 letter code.
I attempt to write the soundex field to its place in the database. I
get the followign error message:
Cannot create a row of size 9602 which is greater than the allowable
maximum of 8060.
The statement has been terminated.
Now, I am totally confused - Does anyone know why this is happening?
Any ideas/suggestions/comments/diagnostics that I could run would be
great. Please help me!
Confused,
Al.
Could it be that your possible row size is exceeded ? Not the actual
used one, but the highest possible. Therefore you should have gotten an
error while creating or altering the table once upon a time.
SELECT Sum(ISNULL(CHARACTER_MAXIMUM_LENGTH,length)) from
INFORMATION_SCHEMA.Columns col
INNER join systypes
on systypes.name = col.Data_type
Where table_name = 'YourTable'
HTH, jens Suessmeyer.
|||Thanks jens,
I ran this cool command on my table and get the answer: 8392
Unfortunately I don't know where it is! Can you help me locate it or
suggest possible solutions? Can you recommend what I should do please?
Any assistance much appreciated.
Thank you,
Al.
|||Sure, you should narrow down your datatypes that these fit on a
datapage of 8060 bytes. In some cases some columns use wasted datatypes
as somebody just assumes how many bytes are to go in that column. If
there is in some cases reengineering,l the people narrow down the
datatypes because they know the actual data size of the columns later.
Or you can split out the table to some "Soundex table" qwhich
references 1by1 the original table and just point with the same PK on
this.
HTH, jens Suessmeyer.

Cannot write a small row! Please help...

Hi everyone,
This is weird. Please help!
I have a long row in the form:
WordA WordB WordC WordD etc...
The above row is 5,294 bytes in size.
I got the soundex equivalent of this row. It now became:
SoundexA SoundexB SoundexC SoundexD etc...
It's size is now 2,898 bytes. AS you would expect as soundex returns a
4 letter code.
I attempt to write the soundex field to its place in the database. I
get the followign error message:
Cannot create a row of size 9602 which is greater than the allowable
maximum of 8060.
The statement has been terminated.
Now, I am totally confused - Does anyone know why this is happening?
Any ideas/suggestions/comments/diagnostics that I could run would be
great. Please help me!
Confused,
Al.Could it be that your possible row size is exceeded ? Not the actual
used one, but the highest possible. Therefore you should have gotten an
error while creating or altering the table once upon a time.
SELECT Sum(ISNULL(CHARACTER_MAXIMUM_LENGTH,leng
th)) from
INFORMATION_SCHEMA.Columns col
INNER join systypes
on systypes.name = col.Data_type
Where table_name = 'YourTable'
HTH, jens Suessmeyer.|||Thanks jens,
I ran this cool command on my table and get the answer: 8392
Unfortunately I don't know where it is! Can you help me locate it or
suggest possible solutions? Can you recommend what I should do please?
Any assistance much appreciated.
Thank you,
Al.|||Sure, you should narrow down your datatypes that these fit on a
datapage of 8060 bytes. In some cases some columns use wasted datatypes
as somebody just assumes how many bytes are to go in that column. If
there is in some cases reengineering,l the people narrow down the
datatypes because they know the actual data size of the columns later.
Or you can split out the table to some "Soundex table" qwhich
references 1by1 the original table and just point with the same PK on
this.
HTH, jens Suessmeyer.

Cannot take Backup in Tape..............Why ? what is wrong with this tape?

Hi there.
I haver very weird problem. I have installed BackupExec for Windows on our S
taging Server. It run goods with our Backup jobs but when i go to SQL Server
and try to backup and database on tape. It gives me this error :
The media family on device '\\.'Tape0' is incorrectly formed. SQL Server can
not process this media family.
BACKUP DATABASE is terminating abnormally.
What could be wrong ?
What can i do to make my backup run on Tape.
P.S
Tape is DELL (Media Recognition System) 20 GB.
System is Dell PowerEdge.
Thanks for any response
Abid MalikChange \\.Tape0 to
\\.\Tape0 ( you are missing a whack!)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abid Malik" <abidmunirmalik@.hotmail.com> wrote in message
news:9859C468-C59D-45FD-A045-D1EAE4BE61BF@.microsoft.com...
> Hi there.
> I haver very weird problem. I have installed BackupExec for Windows on our
Staging Server. It run goods with our Backup jobs but when i go to SQL
Server and try to backup and database on tape. It gives me this error :
> The media family on device '\\.'Tape0' is incorrectly formed. SQL Server
cannot process this media family.
> BACKUP DATABASE is terminating abnormally.
> What could be wrong ?
> What can i do to make my backup run on Tape.
> P.S
> Tape is DELL (Media Recognition System) 20 GB.
> System is Dell PowerEdge.
>
> Thanks for any response
> Abid Malik
>

Cannot restore a copy of SQL2000 to SQL2005

I ran into a weird problem trying to restore a backup copy of SQL2000
database into the new SQL2005 server. I copied the backup file
"databasename.bak" to the backup folder of the new SQL2005 server but cannot
see it using browse in restore function.
help!!!
BillI would say that was not exactly the same directory or there is a
permissions issue. Verify the complete path or try some other location.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Bill Nguyen" wrote:

> I ran into a weird problem trying to restore a backup copy of SQL2000
> database into the new SQL2005 server. I copied the backup file
> "databasename.bak" to the backup folder of the new SQL2005 server but cann
ot
> see it using browse in restore function.
> help!!!
> Bill
>
>|||Ben;
You're correct. I looked into the wrong folder.
After that, I ran into a different problem though:
I upgraded the SQLserver 2005 to SP1 ans tried to restore a copy of SQL2000
from another server to it. SQL 05 refused to restore saying that the backup
is for another SQLserver instance! I don't remember running into this
problem last time I did the same task.
Any idea why?
Thanks again.
Bill
Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:B1063714-ACF3-461D-885C-FCE372E210D4@.microsoft.com...[vbcol=seagreen]
> I would say that was not exactly the same directory or there is a
> permissions issue. Verify the complete path or try some other location.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Bill Nguyen" wrote:
>

Cannot restore a copy of SQL2000 to SQL2005

I ran into a weird problem trying to restore a backup copy of SQL2000
database into the new SQL2005 server. I copied the backup file
"databasename.bak" to the backup folder of the new SQL2005 server but cannot
see it using browse in restore function.
help!!!
BillI would say that was not exactly the same directory or there is a
permissions issue. Verify the complete path or try some other location.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Bill Nguyen" wrote:
> I ran into a weird problem trying to restore a backup copy of SQL2000
> database into the new SQL2005 server. I copied the backup file
> "databasename.bak" to the backup folder of the new SQL2005 server but cannot
> see it using browse in restore function.
> help!!!
> Bill
>
>|||Ben;
You're correct. I looked into the wrong folder.
After that, I ran into a different problem though:
I upgraded the SQLserver 2005 to SP1 ans tried to restore a copy of SQL2000
from another server to it. SQL 05 refused to restore saying that the backup
is for another SQLserver instance! I don't remember running into this
problem last time I did the same task.
Any idea why?
Thanks again.
Bill
Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:B1063714-ACF3-461D-885C-FCE372E210D4@.microsoft.com...
> I would say that was not exactly the same directory or there is a
> permissions issue. Verify the complete path or try some other location.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Bill Nguyen" wrote:
>> I ran into a weird problem trying to restore a backup copy of SQL2000
>> database into the new SQL2005 server. I copied the backup file
>> "databasename.bak" to the backup folder of the new SQL2005 server but
>> cannot
>> see it using browse in restore function.
>> help!!!
>> Bill
>>