Viewing 15 posts - 32,131 through 32,145 (of 49,552 total)
Please post new questions in a new thread. Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 7:32 am
I suspect you'll have to run a trace to see what happens. Either the table is being dropped and recreated or something's explicitly removing permissions.
Does SQL 7 have profiler?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 7:31 am
Grant Fritchey (6/29/2010)
Although if you move to SQL Server 2008 (or R2), you can use Change Data Capture to perform this type of change tracking without using triggers.
Or Change Tracking,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 6:58 am
Is the table getting dropped and recreated overnight?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 6:03 am
sys.objects -> sysobjects
sys.columns -> syscolumns
sys.types -> systypes
sys.tables -> sysobjects where xtype = 'u'
sys.triggers -> sysobjects where xtype = 'tr'
The column names have changed as well, but you should be able...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 6:02 am
Can you post the schema of the table, all indexes and the trigger definitions?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 5:48 am
Page verify = checksum and backup checksums are separate things. Setting a database's page verify to checksum will not cause the backup to be taken with the Checksum option by...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 3:13 am
You need triggers on the tables that you want to track.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 3:00 am
I'll check the indexes and queries this evening, if I have the time, see if there's anything you can improve. The vast majority of deadlocks can be resolved completely by...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 2:36 am
You didn't mention there had been a database crash. It would have been helpful to know that.
Publish the database, then remove the publication. That should remove all traces of replication...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 2:32 am
singhsatnam84 (6/29/2010)
search for the page with the As and change one byte to a ‘B’ or ‘Z’ or something not an A.
Yup, that'll do the job. It'll invalidate the page...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 1:46 am
You can't run the log reader manually. Check the SQL jobs, check replication monitor.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 1:45 am
DB has to be in full or bulk logged recovery, you need a full backup from before the corruption happened.
http://msdn.microsoft.com/en-us/library/ms175168.aspx
p.s. Notepad will choke on a database file. Download a hex...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 1:30 am
Is the log reader running? If not, start it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 1:29 am
Please don't post in all caps, it's the online equivalent of shouting at us.
To track changes you need either triggers (DDL for structure changes, DML for data changes) or a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 1:28 am
Viewing 15 posts - 32,131 through 32,145 (of 49,552 total)