Viewing 15 posts - 1,096 through 1,110 (of 2,897 total)
You could backup transaction logs more frequently, even though 1 day's loss is acceptable to you. You may encounter a problem one day and be glad for the extra recovery...
January 20, 2011 at 7:14 pm
Look at your unique indexes to see which one has "Ignore Duplicate Key" selected.
I suspect you overlooked something.
January 20, 2011 at 12:05 pm
Also, make sure you're on SP3. Various bugs here & there have been fixed (not sure if it woiuld help in this case)
January 20, 2011 at 8:35 am
DROP LOGIN [TestLogin] is the current method
sp_droplogin is the old method and will be removed from SQL at some point.
From your other post:
" ... when iam deleting the login ,automatically...
January 20, 2011 at 4:49 am
"Duplicate key was ignored" means that a matching key already existed in your target table, so that row was not inserted. It's a setting on an index, so that instead...
January 19, 2011 at 8:07 pm
Steve Jones - SSC Editor (1/18/2011)
Make your best guess about what they mean, and make that happen.
Or, if possible, go back to them, and clarify the objective, not the method....
January 19, 2011 at 8:03 pm
Also, you could set your normal t-log backup job to run every 10 minutes during the rebuild time frame.
January 19, 2011 at 9:52 am
Tara-1044200 (1/19/2011)
I understand using the export wizard but how can i mask few columns?
Sorry, I was thinking of "ignore" which will eliminate the column from the output completely. So if...
January 19, 2011 at 9:38 am
Backup your transaction log inbetween index rebuilds.
January 19, 2011 at 4:40 am
You could use the Export Wizrd, 1 for each database, then save them and run all 10 at once in a job. The first one creates (or truncates) the...
January 18, 2011 at 6:45 pm
What does DBCC INPUTBUFFER (or such) give you for the blocked process ?
January 18, 2011 at 2:46 pm
Could you give some more detail.
I don't understand what you mean by " ...in which few columns has to be de identofied. ..."
January 18, 2011 at 2:35 pm
newbieuser (1/17/2011)
We are having issues with the insert statement from the application.. Selects work fine though..
That's why I'm suggesting it's a permission issue, because you need higher permissions for an...
January 17, 2011 at 11:09 am
"right click" Database -> Tasks -> Generate Scripts
Assuming you're on a current service pack, you can choose to export into 1 big file, or into individual files per object.
You...
January 17, 2011 at 9:46 am
Viewing 15 posts - 1,096 through 1,110 (of 2,897 total)