|
|
Posted by David C. Barber on 09/08/06 06:14
This updates a previous post.
We have updated our SQL Server 2000 to new hardware by reinstalling SQL
Server 2K to a new, dual processor server. We performed a full SQL backup
of the entire server, and did a full restore onto the new hardware, which
has the same server name and IP address. One difference has bitten us,
however.
When I perform an sp_who standard procedure call in VB6, the dbname field
comes back with our database names padded with spaces out to 100 characters
total length. Database names in the left panel of Enterprise Manager also
show this padding. This seems only to apply to databases we restored in
their entirety, and not either newly created ones, or standard SQL Server
ones (e.g. master, model, msdb, Northwind, pubs tempdb).
Would really like to know how this could have happened since it has affected
some applications.
Navigation:
[Reply to this message]
|