I am a support rep for an app running on SQL Server 7 sp3.
The customer had a table mysteriously restored along with the dependencies [sp.s, indexes, etc] for that table.
Is there any logging in sql server that will show when tables or objects have been dropped, recreated or restored?
thanksLook up the msdb..restorehistory table.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"tlr" <anonymous@.discussions.microsoft.com> wrote in message
news:86C067AA-72E8-49CD-A34A-1E79E4E03315@.microsoft.com...
I am a support rep for an app running on SQL Server 7 sp3.
The customer had a table mysteriously restored along with the dependencies
[sp.s, indexes, etc] for that table.
Is there any logging in sql server that will show when tables or objects
have been dropped, recreated or restored?
thanks
Showing posts with label indexes. Show all posts
Showing posts with label indexes. Show all posts
Monday, March 19, 2012
Mysterious indexes "_WA_Sys_..."
I was looking for tables with no indexes, and I keep
finding entries in sysindexes with names
like "_WA_Sys_....", which I certainly don't create.
The last one is possibly attached to a column defined as
nvarchar(128), but its the only column in the table
defined that way, and the other columns don't have such an
index ! very confusing.
Does anyone know what these are ?
Does anyone have an SQL script that will correctly!
identify tables without indexes ? This would be hugely
appreciated !_WA_Sys_...." are SQL Server statstics. You have AUTO Stats turned on.
This is expected. You should leave them alone.
"Jim Trowbridge" <jtrowbridge@.adelaidebank.com.au> wrote in message
news:07be01c36600$78857070$a401280a@.phx.gbl...
I was looking for tables with no indexes, and I keep
finding entries in sysindexes with names
like "_WA_Sys_....", which I certainly don't create.
The last one is possibly attached to a column defined as
nvarchar(128), but its the only column in the table
defined that way, and the other columns don't have such an
index ! very confusing.
Does anyone know what these are ?
Does anyone have an SQL script that will correctly!
identify tables without indexes ? This would be hugely
appreciated !
finding entries in sysindexes with names
like "_WA_Sys_....", which I certainly don't create.
The last one is possibly attached to a column defined as
nvarchar(128), but its the only column in the table
defined that way, and the other columns don't have such an
index ! very confusing.
Does anyone know what these are ?
Does anyone have an SQL script that will correctly!
identify tables without indexes ? This would be hugely
appreciated !_WA_Sys_...." are SQL Server statstics. You have AUTO Stats turned on.
This is expected. You should leave them alone.
"Jim Trowbridge" <jtrowbridge@.adelaidebank.com.au> wrote in message
news:07be01c36600$78857070$a401280a@.phx.gbl...
I was looking for tables with no indexes, and I keep
finding entries in sysindexes with names
like "_WA_Sys_....", which I certainly don't create.
The last one is possibly attached to a column defined as
nvarchar(128), but its the only column in the table
defined that way, and the other columns don't have such an
index ! very confusing.
Does anyone know what these are ?
Does anyone have an SQL script that will correctly!
identify tables without indexes ? This would be hugely
appreciated !
Subscribe to:
Posts (Atom)