AD group in SQL Server

Hi there
I have some AD groups added to SQL Server. Now this groups was renamed in
the AD, but in the SQL Server there is the old name shown. How can I
syncronize the name of the AD with the name displayed in SQL Server?
Thenks for helping
Juerg
I think the only way to do this (other than dropping/re-adding) is to update
the sysxlogins table..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"JZ" <JZ@.discussions.microsoft.com> wrote in message
news:05C976B7-5230-4745-BB1F-E7560F1FA7BC@.microsoft.com...
> Hi there
> I have some AD groups added to SQL Server. Now this groups was renamed in
> the AD, but in the SQL Server there is the old name shown. How can I
> syncronize the name of the AD with the name displayed in SQL Server?
> Thenks for helping
> Juerg

AD group in SQL Server

Hi there
I have some AD groups added to SQL Server. Now this groups was renamed in
the AD, but in the SQL Server there is the old name shown. How can I
syncronize the name of the AD with the name displayed in SQL Server?
Thenks for helping
JuergI think the only way to do this (other than dropping/re-adding) is to update
the sysxlogins table..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"JZ" <JZ@.discussions.microsoft.com> wrote in message
news:05C976B7-5230-4745-BB1F-E7560F1FA7BC@.microsoft.com...
> Hi there
> I have some AD groups added to SQL Server. Now this groups was renamed in
> the AD, but in the SQL Server there is the old name shown. How can I
> syncronize the name of the AD with the name displayed in SQL Server?
> Thenks for helping
> Juerg

AD group in SQL Server

Hi there
I have some AD groups added to SQL Server. Now this groups was renamed in
the AD, but in the SQL Server there is the old name shown. How can I
syncronize the name of the AD with the name displayed in SQL Server?
Thenks for helping
JuergI think the only way to do this (other than dropping/re-adding) is to update
the sysxlogins table..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"JÜZ" <JZ@.discussions.microsoft.com> wrote in message
news:05C976B7-5230-4745-BB1F-E7560F1FA7BC@.microsoft.com...
> Hi there
> I have some AD groups added to SQL Server. Now this groups was renamed in
> the AD, but in the SQL Server there is the old name shown. How can I
> syncronize the name of the AD with the name displayed in SQL Server?
> Thenks for helping
> Juerg

Actual physical file size

Hi Everybody,
I like to compute the actual physical database file size using queries.

From the EM database properties, the file size shown is not matching with the master..sysaltfiles.size

Ex. Actual file size is 12MB and 1MB for MDF & LDF respectively.
'sysaltfiles' shows 1464 & 96 resp. Since they are shoing it as 8K Pages,
96*8 = 768KB is not matching with 1024KB for the LDF file.
Is there any overheads (additional space from the physical file for file headers) allocated?

Thanks
Babuhm odd, I see the same thing. Additionaly, when calculating via sysaltfiles and comparing it with what a 'dir' shows, I have a match. The EM does show the size correctly in the Space allocated (taskpad), but not the Database Size. In my case it's a 4,56 MB off. Detaching the DB didn't change the size on disk either.|||Hi Kaiowas,

So you are getting the computation of sysaltfiles.size*8K pages matching with those of the physical OS file size. There is no difference in your system.
Mine is not matching. Any idea?|||yes, I did size * 8 * 1024 to get a bytesize to compare against a dir/properties of the actual databasefile.