|
|
Posted by Dan Guzman on 09/08/06 11:22
You still have an open thread on this subject ("Restore Messed Up Table
Names"). Erland Sommarskog asked you a couple of questions and is still
waiting for a response.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"David C. Barber" <david@NOSPAMdbarber.com> wrote in message
news:MZudnTwxaZGNl5zYnZ2dnUVZ_omdnZ2d@comcast.com...
> 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]
|