Viewing 15 posts - 46,426 through 46,440 (of 49,571 total)
My guess is that when you made the backup, there were two entries in the destination box.
If there were, then the backup was striped across the 2, and you...
May 24, 2008 at 2:18 pm
The collective wisdom of google seems to indicate it's a dBase file format, also used in Foxpro and a few other apps
http://en.wikipedia.org/wiki/DBASE#File_formats
Not particularly relevant to a thread on corrupt SQL...
May 24, 2008 at 2:10 pm
Table and index definitions please.
How many rows do the two tables have? How many does this query return?
May 24, 2008 at 2:03 pm
bbop1322 (5/23/2008)
When you setup the trace, switch over to the Events Selection tab and ensure that the NTUserName and LoginName columns are coming back.
Providing the app's not using a single...
May 23, 2008 at 6:42 am
Grant Fritchey (5/23/2008)
BTW, keeping this a bit on topic, I'd be perfectly happy to just study all this stuff and learn, but they do ask us to test every so...
May 23, 2008 at 6:40 am
Books online has some examples of triggers.
Most likely you want something like this (pseudo code only. Will not work as written)
CREATE TRIGGER trg_Audit ON <Name of table to be monitored>
FOR...
May 23, 2008 at 6:33 am
Profiler may help you locate where the hacks are coming from. It depends how your app is set up.
Do you have any logging implemented in the appllcaton?
Ultimatly, the only real...
May 23, 2008 at 4:06 am
A trigger fires only when data is changed (in the caseof an insert trigger on insert) in the table that the trigger is on.
Your trigger is only going to fire...
May 23, 2008 at 2:26 am
Find me a server with 100,000 TB of storage, and then we can talk.
Asking if something will have good performance is like asking how long a piece of string is....
May 23, 2008 at 1:31 am
I think what you need is a scheduled job.
The trigger as you've written it will select a whole bunch of data whenever someone inserts into the master..log_tbl table.
From what you...
May 23, 2008 at 1:08 am
The technical limitations are listed in Books Online.
Max size of a single file - 16 TB. Max size of a log - 2TB, max files per DB 32767, max database...
May 23, 2008 at 12:53 am
(Reposting my earlier comments here to keep all the discussion in one place)
Start with profiler. Run during busy periods (I would recommend you use server-side trace events rather than the...
May 23, 2008 at 12:26 am
Posted in wrong forum. Please direct replies to the following thread.
http://www.sqlservercentral.com/Forums/Topic505583-65-1.aspx
May 23, 2008 at 12:25 am
Grant Fritchey (5/22/2008)
I picked martial arts just because its something that I'm into.
What style?
May 23, 2008 at 12:22 am
Viewing 15 posts - 46,426 through 46,440 (of 49,571 total)